Project Information (Project Center data)
The following query displays the list of the ProjectName,Start date, Finish date,% Complete, Work, ActaulWork,Duration,%Work Complete and Owner details in Project Server 2007.
How to Run: Run the following query by selecting Reporting database.
SQL Query:
SELECT MSP_EpmProject.ProjectName AS ProjectName,
MSP_EpmTask.TaskStartDate AS Start,
MSP_EpmTask.TaskFinishDate AS Finish,
MSP_EpmTask.TaskPercentCompleted AS '%Complete',
MSP_EpmTask.TaskWork AS WorkinHrs,
MSP_EpmTask.TaskActualWork AS ActualWorkinHrs,
MSP_EpmTask.TaskDuration/8 AS DurationDays,
MSP_EpmTask.TaskPercentWorkCompleted AS '%WorkComplete',
MSP_EpmResource.ResourceName AS Owner
FROM MSP_EpmTask INNER JOIN
MSP_EpmProject ON MSP_EpmTask.ProjectUID = MSP_EpmProject.ProjectUID
INNER JOIN
MSP_EpmResource ON MSP_EpmProject.ProjectOwnerResourceUID =
MSP_EpmResource.ResourceUID
WHERE (MSP_EpmTask.TaskOutlineLevel = 0) AND
(MSP_EpmTask.TaskOutlineNumber = 0)
|
