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 group by ResourceId, UserAtHost) res on hud.OwnerId...
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 your users by SIP address and return their archive...
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 around SQL to figure out what I needed to read...
Last night I was working with my friend and fellow UC architect, Peter Pawlak, on a customer design item. This particular customer is a subsidiary of a larger organization. The subsidiary is deploying OCS but the parent company is not. Not a problem since each of them have their own forests. However...