Querying Lync User logon server and logon client types

In the actual operation of Lync Server 2013/skype for Business Server 2015, it is unavoidable to query some of the user's logged-in information to do some auxiliary judgment on some transactions.

For example:

1, query a user login LYNC/SFB front end pool that one server?

2. Query the last time a user registered the front end pool?

3, query a user login LYNC/SFB use the client type?

4, query a front-end server have those users logged in?

The official has an order to check, but the information is very limited, it is difficult to meet the individual needs.

Official Order:

Get-csuserpoolinfo

Links: https://technet.microsoft.com/zh-CN/library/gg398615.aspx

the individual queries mentioned above can be queried by connecting the front-end server database (rtclocal), such as querying Lync Server 2013/skype for Business Server 2015 as an example, using the following SQL command:

Select (CAST (RE). ClientApp as varchar ()) as clientversion,r.userathost as Username,ra. Fqdn

Hrd. Lastnewregistertime as Lastregistertime, EP. Expiresat

From Rtcdyn.dbo.RegistrarEndpoint RE

INNER Join rtc.dbo.Resource R on r.resourceid = RE. ownerID

INNER Join rtcdyn.dbo.Endpoint EP on EP. EndpointId = RE. EndpointId

Inner Join Rtcdyn.dbo.Registrar RA on EP. Registrarid = RA. Registrarid

INNER JOIN rtcdyn.dbo.HomedResourceDynamic HRD on HRD. ownerID = R.resourceid

ORDER by Clientversion,username

Below: Do not know how to use SSMs, please look at the following

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/84/57/wKioL1eN0IOQvumFAAGC4kzv8so775.png-wh_500x0-wm_3 -wmp_4-s_1505679108.png "title=" Userpool.png "alt=" Wkiol1en0ioqvumfaagc4kzv8so775.png-wh_50 "/>

Simple processing to solve the problems encountered in the actual work, welcome to add!

This article is from "Johnson's blog" blog, please be sure to keep this source http://yangqs.blog.51cto.com/127876/1827769

Querying Lync User logon server and logon client types