Check for Unaccepted Task Updates

[Angie R]

Hello,

I manage the Project Server for my company, but we have several Project
Managers that can accept tasks updates for their projects. I have a couple
of projects that need to be renamed that I am not the PM for. I need to make
sure the updates are all processed before doing so. Is there anyway to check
for unaccepted task updates for someone else's projects. One of the people
is out of town and my boss needs the project name changed ASAP.

Thank you,

 

[Reid McTaggart]

One way would be to have the Project Server Administrator temporarily change
the PM who is our of town to Server Authentication, then log in as that
person and check for Updates.

 

[Angie R]

Thank you Reid! That worked great!

 

[Doug]

Angie:

In case you need it in the furture, here is a query to help!

select A.task_name, P.PROJ_NAME, R.RES_NAME ,A.ASSN_START_DATE,
a.WASSN_DELETED_IN_PROJ
from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P, MSP_WEB_RESOURCES R
where A.WASSN_ACTUALS_PENDING =1 -- flag to indicate task is pending manager
approval
and A.wproj_id = P.WPROJ_ID
AND R.WRES_ID = A.WRES_ID