Querying Lync User logon server and logon client types

Source: Internet
Author: User

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:


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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.