|
|
| |
|
Project Owners
The following query displays the list of the project owners and their email addresses.
How to Run: Run the following query on SQL Query Analyzer, by selecting Project Server database.
Script:
SELECT DISTINCT MSP_WEB_PROJECTS.PROJ_NAME AS Project,
MSP_WEB_RESOURCES.RES_NAME AS Owner, MSP_WEB_RESOURCES.WRES_EMAIL AS Email
FROM MSP_WEB_ASSIGNMENTS INNER JOIN MSP_WEB_PROJECTS ON MSP_WEB_ASSIGNMENTS.WPROJ_ID =
MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
MSP_WEB_RESOURCES ON MSP_WEB_ASSIGNMENTS.WRES_ID_MGR = MSP_WEB_RESOURCES.WRES_ID
ORDER BY MSP_WEB_PROJECTS.PROJ_NAME
Sample Output:
|
| |
|
