Zeroing out work on tasks

[Moses Bunting]

Here is our scenario:

1) A PM adds a Resource to a Task with Work.
2) The PM publishes the Assignment, i.e. the Resource sees the Task on
their Timesheet.
3) The PM saves a Baseline.
4) A decision is made that the Resource will no longer be doing that Work.
5) In order to preserve the Baseline, the Work is zeroed out rather than
deleting the Resource from the Task.
6) The Task remains on the Resource's Timesheet because they are unable to
mark it as 100% complete.

Any suggestions how to purge these tasks from the timesheet? Thank you.

 

[Reid McTaggart]

Dale Howard posted this solution in May:

You can use the following SQL Server query and script to remove the deleted
tasks from your users' timesheets in PWA:

Query to see list of cancelled tasks:

select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME, 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 1


SQL Server script to delete cancelled task assignments from PWA timesheets:

delete from MSP_WEB_ASSIGNMENTS
where WASSN_ID IN (
select ma.WASSN_ID 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
--AND mp.PROJ_NAME like '25713%' --uncomment it for specific project
)

 

[Moses Bunting]

Thank you very much!

Dale Howard posted this solution in May:

You can use the following SQL Server query and script to remove the deleted
tasks from your users' timesheets in PWA:

Query to see list of cancelled tasks:

select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME, 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 1


SQL Server script to delete cancelled task assignments from PWA timesheets:

delete from MSP_WEB_ASSIGNMENTS
where WASSN_ID IN (
select ma.WASSN_ID 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
--AND mp.PROJ_NAME like '25713%' --uncomment it for specific project
)

--
Reid McTaggart
Alegient, Inc., Houston
Project Server Experts
Microsoft Certified Partner