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

Project Server 2003

PWA Login DropDown

Inactive vs. Delete

Actual Work Protected

  2003 SQL Queries

  Enterprise Fields
    Project Fields
    Resource Fields
    Sample Queries

Admin Tools

Re-associate Site

Project Archival

  VBA

 
 
 
Administration -> MS Project Server 2003 -> SQL Queries
Enterprise Tasks Details

The following script generates the list of enterprise tasks details (task name, start/finish dates, work, actual work, outline code level, % complete and % work complete etc.)


SELECT dbo.MSP_PROJECTS.PROJ_NAME,
TASKS.TASK_UID,
TASKS.TASK_OUTLINE_NUM,
TASKS.TASK_NAME,
TASKS.TASK_IS_SUMMARY,
TASKS.TASK_START_DATE,
TASKS.TASK_FINISH_DATE ,
TASKS.TASK_WORK / 60000 AS TASK_WORK_HRS,
TASKS.TASK_ACT_WORK/ 60000 AS TASK_ACT_WORK_HRS,
TASK_PCT_COMP,TASK_PCT_WORK_COMP
FROM
dbo.MSP_TASKS TASKS INNER JOIN
dbo.MSP_PROJECTS ON TASKS.PROJ_ID =
dbo.MSP_PROJECTS.PROJ_ID LEFT OUTER JOIN
dbo.MSP_VIEW_PROJ_TASKS_ENT ENTTASKS
ON ENTTASKS.ENT_ProjectUniqueID = TASKS .PROJ_ID
AND ENTTASKS.ENT_TaskUniqueID =
TASKS.TASK_UID
WHERE (TASKS.PROJ_ID NOT IN
(SELECT PROJ_ID
FROM dbo.MSP_PROJECTS
WHERE PROJ_TYPE <> 0)) AND (TASKS.TASK_UID > 0)



Copyright 2013. EPM Central. All rights reserved.