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?
lee_murphyAsked:
Who is Participating?
 
Dr. Thomas HenkelmannDirector Consulting ServicesCommented:
Hi,

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.

Regards

Thomas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.