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...