IT Consultant Everyday Notes

Just some problems/solutions storage

OCS: Last registration time for OCS users

I needed to know when OCS (RTM) users registered with their home server the last time. The goal was to figure out how many “dead” users we have to optimize our licensing. Using this blog as a template I created the following SQL query to run against rtcdyn database:

USE rtcdyn
SELECT rtc.dbo.Resource.UserAtHost, rtcdyn.dbo.HomedUserDynamic.LastNewRegisterTime
FROM rtcdyn.dbo.HomedUserDynamic
INNER JOIN rtc.dbo.Resource on rtc.dbo.Resource.ResourceId = rtcdyn.dbo.HomedUserDynamic.OwnerId

The blog contains queries for OCS 2007 R2 and Lync.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: