Translate

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:

SharePoint Designer- Unable to open a workflow - WWF .NET 3.0, must be installed to use the feature

Every day is a learning day and If we don’t learn a new thing today, the day is wasted. I don’t think much of a man who is not wise...