Forum Discussion

SantoshEPM's avatar
SantoshEPM
Copper Contributor
Mar 10, 2021

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

  • Paul_Mather's avatar
    Paul_Mather
    MVP
    Mar 10, 2021

    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