|
|
|
Project Owners:
The following query displays the list of the project names with details: start date, finish dates of the project and also it diplays the % complete, %work complete, owner, work, duration, last saved date of the project and associated SharePoint site name.
How to Run: Run the following query on SQL Query Analyzer, by selecting Project Server database.
Script:
SELECT MSP_PROJECTS.PROJ_NAME, MSP_TASKS.TASK_START_DATE AS START_DT,
MSP_TASKS.TASK_FINISH_DATE AS FINISH_DT,
MSP_TASKS.TASK_PCT_COMP AS PCT_COMPLETE, MSP_TASKS.TASK_REG_WORK / 60000 AS [WORK], MSP_TASKS.TASK_DUR / 4800 AS DURATION,
MSP_TASKS.TASK_PCT_WORK_COMP AS PCT_WRK, MSP_TASKS.TASK_WORK,
MSP_WEB_RESOURCES.RES_NAME AS OWNER,
MSP_PROJECTS.PROJ_LAST_SAVED AS LAST_SAVED,
MSP_WEB_PROJECTS.WPROJ_LAST_PUB AS LAST_PUBLISHED,
MSP_WEB_PROJECTS.WPROJ_STS_SUBWEB_NAME AS WSS_SITE
FROM MSP_TASKS INNER JOIN
MSP_PROJECTS ON MSP_TASKS.PROJ_ID = MSP_PROJECTS.PROJ_ID INNER JOIN
MSP_WEB_PROJECTS ON MSP_TASKS.PROJ_ID = MSP_WEB_PROJECTS.PROJ_ID
INNER JOIN
MSP_WEB_RESOURCES ON MSP_WEB_PROJECTS.WRES_ID = MSP_WEB_RESOURCES.WRES_ID
WHERE (MSP_TASKS.TASK_ID = 0)
ORDER BY MSP_PROJECTS.PROJ_NAME
|
| |
|
