Task list becoming unusable

G

Gary M

We have been using Project server for awhile now. Several of the developers
have had tasks assigned to them which were subsequently reassigned to other
developers. Unfortunately their task list are getting longer and longer.
Is there anyway (delete from SQL Server?) to remove these. From what I read
there is not but this is getting out of control. If I copy all of the
projects to .MPPs and then delete them from Project, will it remove them
from their Task list?

Thanks,

Gary
 
G

Gary M

A quick followup. It was recommended (back in December of 2003) to use the
"Hide" button but you can only do one task at a time. With 30+ staff and
several projects later the "Hide a single item at a time" won't work.

Gary
 
D

Dale Howard [MVP]

Gary M --

Following is a SQL Server script and query that your DBA's can use to view
and then delete the cancelled tasks from the timesheets of all users:

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
)


Hope this helps.
 
D

Dale Howard [MVP]

Gary --

Thanks! Since I don't drink alcohol, a free root beer sounds good to me!
:)
 
Top