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
My blog contains information on Microsoft PPM Solution 2016/2013/2010/2007/2003 and Project Online. It covers Microsoft Project, Project Server, Project Portfolio Server, SharePoint, SQL Server, SQL Reporting Services, Analysis Services and OLAP for use in the MS EPM Solution.
Translate
Subscribe to:
Post Comments (Atom)
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...
-
August 2011 CU for Microsoft Project and Project Server 2010 Server Rollup Package(Recommended): Description of the SharePoint Server 20...
-
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...
-
Hello EPM Guys, Got the Information from MS Support abou the August 2011 CU for Project Server 2010. Please visist the below link for Proj...
No comments:
Post a Comment