[Lync/SFB] 사용자 Primary Server 찾는 쿼리

use rtc

declare @sipQuery nvarchar(250)

set @sipQuery = 'test1@contoso.com'

select FE.Fqdn,R.UserAtHost, * from FrontEnd FE

join RoutingGroupAssignment RGA

On FE.FrontEndId = RGA.FrontEndId

join ResourceDirectory RD

on RGA.RoutingGroupId = RD.RoutingGroupId

join Resource R

on RD.ResourceId = R.ResourceId

where R.UserAtHost = @sipQuery

Aggregated Presence state	Description
3,000-4,499	Available
4,500-5,999	Available - Idle
6,000-7,499	Busy
7,500-8,999	Busy - Idle
9,000-11,999	Do Not Disturb
12,000-14,999	Be Right Back
15,000-17,999	Away
18,000+	Offline

참고

https://msdn.microsoft.com/en-us/library/bb878933.aspx

http://mikestacy.typepad.com/mike-stacys-blog/2009/08/are-you-really-away.htmlㄴ