Removing Deleted Tasks from View Resource Assignments View

[Richard.Natividad]

Hi,

I have created a view in View Resource Assignments to list all my
resources with task assignments on server. In it I pull the Start and
Finish. This view is an excellent way of showing the Start and Finish
dates of resources on the project as you can use the Summary level of
each resource.

However, there is a problem I have noted, If a resource has deleted
tasks on a date greater than actually specified in the workplan. The
roll off date shows the Deleted Task Finish date instead as it is the
greater value.

My question is:
Is there a way in PWA to filter out Deleted Tasks so that do not
factor in the Start and Finish Dates for a resource? I cannot see an
option to filter out deleted tasks?

Regards,

Richard Natividad

 

[Richard.Natividad]

Hi,

I have created a view in View Resource Assignments to list all my
resources with task assignments on server. In it I pull the Start and
Finish. This view is an excellent way of showing the Start and Finish
dates of resources on the project as you can use the Summary level of
each resource.

However, there is a problem I have noted, If a resource has deleted
tasks on a date greater than actually specified in the workplan. The
roll off date shows the Deleted Task Finish date instead as it is the
greater value.

My question is:
Is there a way in PWA to filter out Deleted Tasks so that do not
factor in the Start and Finish Dates for a resource? I cannot see an
option to filter out deleted tasks?

Regards,

Richard Natividad

Hi, I found through some research the solution below to permanently
remove deleted tasks is to run the script below.

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
)

If the Project Server administrator wants to view a list of cancelled
tasks before deleting them, he/she can run the following SQL Server
query:

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

However, I am working on an externally hosted server and I was
wondering how can I run this script?

Regards,

Richard