Sign in
|
Join
|
Help
Home
Blogs
Mike Stacy's Blog
»
All Tags
»
OCS
»
query
(
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
OCS SQL Query - Return Archive User Settings
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)
archive
SQL
users
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
OCS SQL Query - Return Archive User Settings
From time to time I'll be posting SQL queries that I use for various reasons. I don't claim to be a SQL query expert and so I won't guarantee that these are written with the best syntax or performance characteristics. This query will list...
Published
Wed, Nov 11 2008 11:52 AM
by
Mike Stacy
Filed under:
OCS
,
SQL
,
query
,
archive