SQL Query to get list of exceptions to specific enterprise calendar

Occasional Visitor

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

1 Reply

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