Automatically delete old tasks from timesheet

[Andrew Smith]

Hi,

is there way how to automatically hide deleted and past tasks from the
timesheet view of Project Web Access?

TIA
Andrew

--
Andrew Smith

[Dale Howard [MVP] dot at dot]

Andrew --

Your Project Server administrator can easily delete completed tasks from
each team member's timesheet in PWA by completing the following steps:

1. Log into PWA with administrator permissions
2. Click the Admin menu
3. Click the Clean up Project Server database link
4. Select the Tasks option
5. Click the Delete drop-down list and select Only completed task
assignments from the list
6. Select the drop-down list on the right and select the desired deletion
option
7. At the bottom of the page, select whether to delete completed tasks for
all resources or a single resource
8. Click the Delete button

If you want to delete cancelled tasks (indicated by the big black X
indicator on each user's timesheet in PWA), a SQL Server DBA can use a query
and a script for this process. Following is a SQL Server 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

Following is the 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
)

Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
"We wrote the book on Project Server"

"Andrew Smith" <nos...@hotmail.com> wrote in message
news:OTL0b8lR...@TK2MSFTNGP10.phx.gbl...

[Ed]

This is a very handy tip, before I blast history can I just check that this
only cleans up the tasks lists, it will not affect or remove any actuals?

Thanks,

Ed

[Dale Howard [MVP] dot at dot]

Ed --

The procedures detailed in my last post delete the assignments from the PWA
database, but do not delete the actuals from the actual Microsoft Project
plan. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
"We wrote the book on Project Server"

"Ed" <E...@discussions.microsoft.com> wrote in message
news:71EB9E73-0DD1-456A...@microsoft.com...

[Ed]

Excellent news, thanks for the insight Dale!