728x90
use rtc
SELECT FE.Fqdn as 'FE서버', count(*) as '할당유저수' FROM Resource R with(nolock)
INNER JOIN ResourceDirectory RD ON RD.ResourceId = R.ResourceId
INNER JOIN RoutingGroupAssignment RGA ON RGA.RoutingGroupId = RD.RoutingGroupId
INNER JOIN FrontEnd FE ON FE.FrontEndId = RGA.FrontEndId
GROUP BY FE.Fqdn
각 프론트엔드 서버별 사용자 수가 적절하게 분배 되었는지 확인
728x90
'IT이야기 > S4B&Lync' 카테고리의 다른 글
| Phone Number Normalization Rule Regular Expressions (0) | 2018.10.25 |
|---|---|
| Normalization Rule (0) | 2018.10.24 |
| 복제 상태 확인 (0) | 2018.10.08 |
| SIP 응답코드 (0) | 2018.10.04 |
| Lync 2013 Microsoft Innovation Day 발표 자료 1 (스크랩) (0) | 2016.09.02 |