Resource Manager

B

BTOjohn

by clicking editDear All,

Hope this hasn't been answered elsewhere, sorry for wasting time if it has.

I know that project owner can be shown in the project centre, which is easy
enough, and this is changed manually by selecting edit. I also know, that to
become "approver", someone needs to publish the project, and select "become
manager for these assignments". Now I assume that somewhere this information
is stored, because otherwise project wouldn't know who to send submissions
to. My question is, therefore, how do I find out and display who is the
approver. Ideally I would like it to show in the "task centre" (prob not the
right terminology, but the views when you click on a project title in project
centre). All help much appreciated.

Cheers,

John
 
D

Dale Howard [MVP]

BTOJohn --

You cannot display this information in the Project Center page or a detailed
Project page in PWA. Instead, you must use the View Resource Assignments
feature. Ask your Project Server administrator to add the Project Manager
column to the Summary assignments view in PWA and then you can see the
information you seek.

You can also use the follow SQL Query to extract the information you seek:

SELECT MSP_WEB_PROJECTS.PROJ_NAME, MSP_WEB_ASSIGNMENTS.TASK_NAME,
MSP_WEB_RESOURCES.RES_NAME AS Resource,

MSP_WEB_RESOURCES_1.RES_NAME AS Manager

FROM MSP_WEB_ASSIGNMENTS INNER JOIN

MSP_WEB_RESOURCES ON MSP_WEB_ASSIGNMENTS.WRES_ID =
MSP_WEB_RESOURCES.WRES_ID INNER JOIN

MSP_WEB_RESOURCES MSP_WEB_RESOURCES_1 ON

MSP_WEB_ASSIGNMENTS.WRES_ID_MGR = MSP_WEB_RESOURCES_1.WRES_ID INNER
JOIN

MSP_WEB_PROJECTS ON MSP_WEB_ASSIGNMENTS.WPROJ_ID =
MSP_WEB_PROJECTS.WPROJ_ID


Hope this helps.
 
Top