Where are the holidays?

[Guilherme]

I'm trying to develop some kind of indicators for task assignment
distribution. I was thinking about getting the days of work (i.e. except
holidays and weekends) and the assignment time by resource. But for that, I
need to select the holidays from db and I don't know where they are found in
Project Server DB Tables.

Does anybody knows where are the holidays we register for the calendar saved
in DB?

 

[Sean Hanson]

These holidays would be exceptions created for each calendar you use, they
are not universal. To my limited knowledge, the calendars are stored in
binary, so other than using Project Pro to open and read the holidays on a
per calendar basis, I am not sure you can get to
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting
SRS Report Packs

 

[Mike Mahoney]

These holidays would be exceptions created for each calendar you use, they
are not universal. To my limited knowledge, the calendars are stored in
binary, so other than using Project Pro to open and read the holidays on a
per calendar basis, I am not sure you can get to
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting
SRS Report Packs






- Show quoted text -

Guilherme

Your requirement sounds suspiciously like a resource histogram. A
data analysis view will do this for you (and show non-workings days if
you want)

regards

Mike