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

 

[Dale Howard [MVP]]

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.

 

[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

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 Howard [MVP]]

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.

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

 

[Ed]

Excellent news, thanks for the insight Dale!

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.