Tuesday, March 25, 2008

Query to find the deleted Tasks in Projects

All,

Hope this query will help you in finding the Deleted tasks form MS-Project 2003. In this case, team members can see the PWA tasks in their timesheet but they can't update the Actual hrs.
Run this query against ProjectServer database:

select
mp.Proj_Name AS [Project Name],
ma.TASK_NAME AS [Task Name] ,
ma.ASSN_START_DATE AS [Start date],
ma.ASSN_FINISH_DATE AS [Finish date],
ma.ASSN_WORK/60000 As 'Work',
ma.ASSN_ACT_WORK/60000 As 'Actual Hours Reported',
mr.RES_NAME As Resource
from MSP_WEB_ASSIGNMENTS ma
JOIN MSP_WEB_PROJECTS mp ON ma.WPROJ_ID = mp.WPROJ_ID
JOIN MSP_WEB_RESOURCES mr ON ma.WRES_ID = mr.WRES_ID where
ma.WASSN_DELETED_IN_PROJ <>0
Order by mp.Proj_Name

No comments: