We help IT Professionals succeed at work.

In Project Server 2013 where are the work exceptions stored?

I'm trying to create a report, linked directly to the SQL reporting tables and want to include details of when each resource is unavailable due to some exception, such as a vacation.  Can I link to this information in SQL or is it saved in the Global Template, and if so, what's the easiest way to link to it? Some sort of Export from Project Professional?
Watch Question

Director Consulting Services

unfortunately the calendars, availabilities and rates are stored in a binary format in the pub schema of the ProjectServer database. From the Project client you can open the resources and export the data you are looking for with a macro that just walks through all the resource and writes the exceptions to a file or also to a SQL table where you can extract it.