Project Ownership/Resources in Database

[J]

Hello,

I need help locating either the resources assigned to each task or the
project manager or owner of each project inside the database of project
server. We are trying to run reports that show status of each project but we
can not figure out where the ownership or project manager is hiding in the
database of server.

Can anyone help us.

J

 

[Chak]

J,

A) Task Info from Web Tables:

Look the table dbo.MSP_WEB_ASSIGNMENTS

Look for the fields :
WPROJ_ID
WRES_ID
WRES_ID_MGR
TASK_NAME

WRES_ID is the resourceid of the resource and WRES_ID_MGR is the
resourceid of manager from dbo.MSP_WEB_RESOURCES table.

Note: To see the task info of the plan, first you need to publish the
plan.

OR

B) Task info from MSP tables:

table: MSP_Assignments, MSP_Resources, MSP_Projects

Thanks
Chak

 

[Chak]

J,

A) Task Info from Web Tables:

Look the table dbo.MSP_WEB_ASSIGNMENTS

Look for the fields :
WPROJ_ID
WRES_ID
WRES_ID_MGR
TASK_NAME

WRES_ID is the resourceid of the resource and WRES_ID_MGR is the
resourceid of manager from dbo.MSP_WEB_RESOURCES table.

Note: To see the task info of the plan, first you need to publish the
plan.

OR

B) Task info from MSP tables:

table: MSP_Assignments, MSP_Resources, MSP_Projects

Thanks
Chak

 

[J]

Thank you very much.