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

 

 

Andrew Morpeth
Andrew Morpethhttps://ucgeek.co/author/amorpeth/
Andrew is a Modern Workplace Consultant specialising in Microsoft technologies based in Auckland, New Zealand; Andrew is a Director and Professional Services Manager at Lucidity Cloud Services and a Microsoft MVP.

Related Articles

NZ to get native Microsoft Teams calling

New Zealand (NZ) is set to get native Microsoft Teams calling by July 2021 - this feature allows you to replace your telephony solution with Microsoft Teams. Microsoft Teams calling for NZ further reduces the barrier to using Microsoft Teams as a telephony replacement solution for New Zealand businesses.

Microsoft Teams Calling Options for Telephony Replacement

Microsoft Teams Calling provides telephony replacement capability that could replace your PABX or any other solution you may have. This article takes you through the options and when to use them, and the licencing you will require to activate this feature for your users.
00:13:43

Skype for Business Response Groups Made Easy

Call Flow Manager for Skype for Business and Lync makes creating and managing Response Groups easy! No more bouncing between interfaces to configure a simple call flow. Call Flow Manager brings all the functionality of the Response Group service into a single user interface

7 COMMENTS

  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.

  3. Andrew,
    First, thank you for this query. I think this is what I was looking for as I needed to pull a list of conferences out of my 2 pools. Next issue is figuring out which are “active” or not and maybe find a way to clear out the inactive/outdated ones from the database. I’m hoping this data can help.

    This query returned a LOT of conferences (user base of approx. 20k users), but is there a way I can tell from this data if the meeting is still active or not? IE, overall it returned 13366 lines. Of those, 13312 have NULL in ExpiryTime and 9936 have NULL in LastActivateTime.

    Thank you for your help.. and this query.

    • Hi Mike. In the past I have used Excel filters to filter to non-expired meetings, then ordered by last active. This appears give you re-occurring and still active meetings + meetings that have not occurred yet (never been active). Hope that helps a little. The report is certainly not perfect.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Andrew Morpeth
Andrew Morpethhttps://ucgeek.co/author/amorpeth/
Andrew is a Modern Workplace Consultant specialising in Microsoft technologies based in Auckland, New Zealand; Andrew is a Director and Professional Services Manager at Lucidity Cloud Services and a Microsoft MVP.

Latest Articles

NZ to get native Microsoft Teams calling

New Zealand (NZ) is set to get native Microsoft Teams calling by July 2021 - this feature allows you to replace your telephony solution with Microsoft Teams. Microsoft Teams calling for NZ further reduces the barrier to using Microsoft Teams as a telephony replacement solution for New Zealand businesses.

Microsoft Teams Calling Options for Telephony Replacement

Microsoft Teams Calling provides telephony replacement capability that could replace your PABX or any other solution you may have. This article takes you through the options and when to use them, and the licencing you will require to activate this feature for your users.
00:13:43

Skype for Business Response Groups Made Easy

Call Flow Manager for Skype for Business and Lync makes creating and managing Response Groups easy! No more bouncing between interfaces to configure a simple call flow. Call Flow Manager brings all the functionality of the Response Group service into a single user interface
00:13:30

Office 365 Backup with Synology NAS

There are many reasons that you may want to back up your Office 365 data. The most common reasons I see are data sovereignty...

Microsoft 365 Feature Roundup Dec 2020

Feature Roundup Presentation Microsoft 365 key feature releases and announcements for June to December 2020, in an easy to digest PowerPoint format.