How can I how the time that Lync user last logon
Hello everybody, my company installs a standard lync server. For management requirement my supervisor want to know the condition that user uses this service. So I need to know the lync user last longon time. Does any powershell or Lync database table can get this information? Thanks.
May 10th, 2011 1:08am

Sid.Feng,

 

You can find this information in the LCSCDR database.  You would probably need to write a customer query to find the data, I've only examind the data in the table to understand what is in there, and not written a query so I don't have a query that will help.

 

Hope this helps!

 

-kp

Free Windows Admin Tool Kit Click here and download it now
May 10th, 2011 2:00am

Kevin Peters ,

Thanks for your help. But my lync server only has two instances (rtc and rtclocal).

rtc instance (cpsdyn database lis database rgconfig database rgsdyn database rtc database rtcab database rtcab1 database rtcdyn database xds database)

 rtclocal instance (rtc database rtcdyn database xds database)

 The lyns server doesn't have that LCSCDR database or I need to install Archiving service.


May 10th, 2011 3:06am

Hi, Sid,

   Here’re some other methods for reference.

1.        To get the number of clients connected in Lync 2010, you need to do it via performance counters on the SQL server. Look at the SQLServer: User Settable performance counters for the backend SQL instance and add ‘user counter 1′ – this has the number of currently connected users. And you can get more info from this blog.

2.        The script (List Connections to Registrar Pool) which can connect to the backend database and retrieve information.

3.        You can refer to this tool. And hope helpful.

Free Windows Admin Tool Kit Click here and download it now
May 12th, 2011 6:47am

FYI I wrote a PowerShell script to try and help automate this reporting:

Generate Lync User Last Logon Report.

I hope that helps!

September 18th, 2013 9:55pm

Couple years late, but I just found your tool. Worked like a charm. Thanks!
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 12:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics