Sign in
|
Join
|
Help
Home
Blogs
Mike Stacy's Blog
»
All Tags
»
SQL
»
users
(
RSS
)
Browse by Tags
Mike Stacy's Blog
Home
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
OCS SQL Query - Show last OCS logon
SQL Query to return number of users per Front End
Tags
ABS
address book
backup
bandwidth
Blackjack 2
certificate
communicator
CUCM
database
Direct SIP
director
Edge
Exchange
Exchange connection error
licensing
OCS
pool
query
SIP trunk
SQL
Tanjay
UM
update server
users
Vista
View more
Archives
January 2009 (1)
December 2008 (1)
November 2008 (5)
October 2008 (1)
September 2008 (6)
August 2008 (3)
June 2008 (3)
May 2008 (7)
database
OCS
pool
query
OCS SQL Query - Show last OCS logon
I wrote this one a while back to help someone on the forums. select res.UserAtHost as "SIP Address", hud.LastNewRegisterTime as "Last Logon" from rtcdyn.dbo.HomedUserDynamic hud join (Select ResourceId, UserAtHost from rtc.dbo.Resource...
Published
Wed, Nov 11 2008 12:00 PM
by
Mike Stacy
Filed under:
OCS
,
SQL
,
users
,
query
SQL Query to return number of users per Front End
In the last couple weeks myself and some other folks I've spoken with have had the need to know how many users were connected to a particular front end. Unfortunately there's no interface to provide this sort of information, so I decided to poke...
Published
Fri, Aug 08 2008 10:37 AM
by
Mike Stacy
Filed under:
OCS
,
pool
,
database
,
SQL
,
users