Resource availability query

[Andrew Stokes]

Hi

I would like to produce a query to use in SQL Reporting Services to pull out
details of resource load and availability. More specifically I would like to
separate real and generic resources and give generic resources zero
availability and real resources their usual 8 hours/day - leave etc. I have
looked around the ProjectServer_Reporting database but I'm having trouble
identifying exactly what to put into the Query. I suppose the query would be
the same as the one used by the Resource Centre graphs for real resouces and
I would create a similar query for generics but give a value of 0 for
availability.

Can any one point me in the right direction.

Regards

Andy

 

[Andrew Stokes]

I forgot to say that its Project Server 2007

 

[Chris Boyd]

Hello,

You might want to take a look at:
http://blogs.msdn.com/project_progr...-the-reporting-database-and-excel-part-1.aspx

as a starting point.

--
Chris Boyd
MS Project
Program Manager

Blog: http://blogs.msdn.com/project_programmability/