none
How can I how the time that Lync user last logon RRS feed

  • Question

  • 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.
    Tuesday, May 10, 2011 1:08 AM

Answers

  • 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.


    Please remember to click “Mark As Answer” on the post that helps you, and to click “Unmark As Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Noya LauModerator Tuesday, May 17, 2011 1:35 AM
    • Marked as answer by Sid.Feng Wednesday, May 18, 2011 6:30 AM
    Thursday, May 12, 2011 6:47 AM
    Moderator

All replies

  • 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 blog: www.ocsguy.com MVP Communications Server, MCITP: Enterprise Administration | MCTS:OCS | MCSE | MCSA | CCNA
    Tuesday, May 10, 2011 2:00 AM
  • 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.


    Tuesday, May 10, 2011 3:06 AM
  • 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.


    Please remember to click “Mark As Answer” on the post that helps you, and to click “Unmark As Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Noya LauModerator Tuesday, May 17, 2011 1:35 AM
    • Marked as answer by Sid.Feng Wednesday, May 18, 2011 6:30 AM
    Thursday, May 12, 2011 6:47 AM
    Moderator
  • FYI I wrote a PowerShell script to try and help automate this reporting:

    Generate Lync User Last Logon Report.

    I hope that helps!

    Wednesday, September 18, 2013 9:55 PM
  • Couple years late, but I just found your tool. Worked like a charm. Thanks!
    Monday, August 31, 2015 4:26 PM