Project Summary per Resource

[Casper]

Hi there

I'm looking for a SQL query that can give me Project summary data per
Resource. I want to display this data on a custom made dashboard. The
specific fields I want to display per resource is ACWP,BCWP,BCWS and ACWS.
Anyone with ideas

Regards

Casper

 

[Ray McCoppin]

Try this query for example:

SELECT MSP_WEB_RESOURCES.RES_NAME AS Res_Name,
MSP_WEB_PROJECTS.PROJ_NAME AS Proj_Name,
MSP_VIEW_PROJ_RES_STD.ResourceACWP,
MSP_VIEW_PROJ_RES_STD.ResourceBCWP, MSP_VIEW_PROJ_RES_STD.ResourceBCWS
FROM MSP_VIEW_PROJ_RES_STD INNER JOIN
MSP_WEB_PROJECTS ON MSP_VIEW_PROJ_RES_STD.WPROJ_ID =
MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
MSP_WEB_RESOURCES ON
MSP_VIEW_PROJ_RES_STD.ResourceEnterpriseUniqueID = MSP_WEB_RESOURCES.WRES_ID


How this helps


--
Ray McCoppin

Need Project Server Report?
http://www.randsmanagement.com
SRS gantt charts