EPM Central Project Server Tutorials
Home Deployment    MS Project PWA SharePoint Articles Administrators FAQs Consulting Search Site Map
  Error Messages

Project Server 2003

PWA Login DropDown

Inactive vs. Delete

Actual Work Protected

  2003 SQL Queries

  Enterprise Fields
    Project Fields
    Resource Fields
    Sample Queries

Admin Tools

Re-associate Site

Project Archival

  VBA

 
 
 
Administration -> MS Project Server 2003 -> SQL Queries
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:





Copyright 2013. EPM Central. All rights reserved.