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?
 
Top