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
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.
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.
FYI I wrote a PowerShell script to try and help automate this reporting:
Generate Lync User Last Logon Report.
I hope that helps!