SQL Query to get list of exceptions to specific enterprise calendar

[SantoshEPM]

Dear Folks
can someone share a SQL Query to get a list of exceptions that belong to a specific enterprise calendar in project server 2016

Regards
Santosh

[#2]

Hello @SantoshEPM 

This data is stored in a table that is not supported to query directly with T-SQL. You can get this information from the REST API - for example: https://{pwaSite}/_api/ProjectServer/Calendars('{calendarGuid')/BaseCalendarExceptions 

Paul