The following SQL query will get scheduled conferences from the Skype for Business RTC database. From a Skype for Business 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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
USE RTC --SELECT * FROM Resource --SELECT * FROM Conference SELECT ConfId, CASE WHEN OrganizerId IS NOT NULL THEN (SELECT TOP 1 UserAtHost FROM Resource WHERE OrganizerId LIKE ResourceId) END AS 'UserSIPAddress', Title, ProvisionTime, LastUpdateTime, ExpiryTime, LastActivateTime FROM Conference |
Specified User
|
1 2 3 4 5 6 7 8 9 10 11 12 |
USE RTC SELECT ConfId, CASE WHEN OrganizerId IS NOT NULL THEN (SELECT TOP 1 UserAtHost FROM Resource WHERE OrganizerId LIKE ResourceId) END AS 'UserSIPAddress', Title, ProvisionTime, LastUpdateTime, ExpiryTime, LastActivateTime FROM Conference WHERE (SELECT UserAtHost FROM Resource WHERE OrganizerId LIKE ResourceId) LIKE ('user@itgala.xyz') |
