EPM Central Project Server Tutorials
Home Deployment    MS Project PWA SharePoint Articles Administrators FAQs Consulting Search Site Map
  Error Messages

Project Server 2007

Databases

Extend Workspace

Delete Workspace

Fiscal Periods

Administrative Categories

Timesheet Periods

Lock Timesheets

Queue Administration

2007 SQL Queries

Video - PWA Permissions

Video - Manage Groups

Video - Manage Categories

Video - RBS

 
 
Administration -> MS Project Server 2003 -> SQL Queries -> Project Owners


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





Copyright 2013. EPM Central. All rights reserved.