Retrieve Project's owner value from SQL Server tables

[Ami Einav]

Hi,
How do I retrieve the project's owner value from the organizational tables
in SQL Server,
and also other Project's custom value fields.
a T-SQL sample code would be appreciated.

Thanks
Ami

 

[Bob Segrest]

Hi Ami,

After selecting your project server database, try using the following lines
in the SQL Query Analyzer:

select
proj_name,
res_name,
ProjectEnterpriseText1
from
MSP_WEB_PROJECTS
join MSP_WEB_RESOURCES on MSP_WEB_PROJECTS.wres_id =
MSP_WEB_RESOURCES.wres_id
join MSP_VIEW_PROJ_PROJECTS_ENT on MSP_WEB_PROJECTS.wproj_id =
MSP_VIEW_PROJ_PROJECTS_ENT.wproj_id

Bob Segrest
BSegE LLC