Get Scheduled Lync Meetings from SQL

The following query will get 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.

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
FROM Conference