Project Owner name

[Newbie]

Hello experts,

Where the hell is hidden the "Project Owner" name in the Project Server Data
Base?
I checked all the Project Server tables without any success !
Thanks in advance!

 

[Gary L. Chefetz [MVP]]

MSP_WEB_PROJECTS

 

[Newbie]

Hi Gary,
;-(

I don't see anything which looks like a "Owner name" in this
MSP_WEB_PROJECTS table ?
Where is it?

Newbie

 

[Gary L. Chefetz [MVP]]

Sorry Newbie, I meant MSP_PROJECTS

proj_prop_author field

 

[Newbie]

Hi Gary,
;-(
It seems that the proj_prop_author field contains the "Author"'s name
specified in File / Properties. Not the "Owner" specified in PWA.

Newbie

 

[Gary L. Chefetz [MVP]]

WRES_ID in MSP_WEB_PROJECTS

You need to resolve this against WRES_ID in the MSP_WEB_RESOURCES to get the
EUID in the resource pool.

 

[Newbie]

Thanks Gary,

I'll work on that!

WRES_ID in MSP_WEB_PROJECTS

You need to resolve this against WRES_ID in the MSP_WEB_RESOURCES to get the
EUID in the resource pool.