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
ORDER BY UserAtHost

The blog contains queries for OCS 2007 R2 and Lync.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: