Get Scheduled Lync Meetings from SQL


The following SQL query will get scheduled conferences from the Lync RTC database. From a Lync Standard Edition server its in the RTCLOCAL instance, otherwise you’ll find it in the backend SQL server. To run the query you will need to open SQL Server Management Console, connect to the database, then open a new Query. Copy the following code snippet and run.

All Users


Specified User




  1. Thanks Andrew,
    it is very useful.
    How can I specific sip address to search the specific user conference information?

  2. Hi, How can I get IP addresses of SfB Client Connected? So we can check from where the Request is coming.

Leave a Reply to John Cancel reply

Please enter your comment!
Please enter your name here