Forum Discussion
SQL Query to get list of exceptions to specific enterprise calendar
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
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