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 2007 -> SQL Queries
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)






Copyright 2013. EPM Central. All rights reserved.