What able/column to query for Status Manager in Reporting DB?

J

Jonathan Sofer [MVP]

Sorry but the Status Manager data is not stored in the Reporting DB.

Jonathan
 
J

Jonathan Sofer [MVP]

You would find it in the Published DB for example. Take a look at the field
WRES_UID_MANAGER in the MSP_ASSIGNMENTS table. You will need to join the
WRES_UID_MANAGER field with the RES_UID field in MSP_RESOURCES to get the
Status Manger name.

Jonathan

Sorry but the Status Manager data is not stored in the Reporting DB.

Jonathan
Click to expand...

Then where is it stored then?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why would the "Import Timesheet" button be greyed out in My Tasks fora user? 1
When an enterprise resource no longer works for the organization(retires, etc).... 1
Tasks in Project Workspace - changing values in the Status field 1
What are ProjectAuthorName and ProjectManagerName inmsp_epmproject_userview 3
Is it possible to pull the Sequence Number of the Issue or Risk fromthe reporting database? 1
Difference in behavior or ProjectPercentCompleted andProjectPercentWorkCompleted? 1
Can individual PMs force a checkin on their projects? 2
OLAP data dictionary? 2

Top