Which table/view to pull list of projects that have an associated project workspace (PS 2007)? RRS feed

  • Question

  • I can't seem to find a table/view that allows me to generate a report that lists all projects that have an associated project workspace.  Would also like to be able to report the owner of the project as well.

    Many thanks,
    Andy Novak, PMP, MBA
    University of North Texas

    Wednesday, April 6, 2011 5:03 PM


  • Hi ANdy,

    not sure if the following does what you are asking for. Please check with your data:

    SELECT    dbo.MSP_EpmProject_UserView.ProjectName, dbo.MSP_EpmResource_UserView.ResourceName
    FROM         dbo.MSP_EpmProject_UserView INNER JOIN
                          dbo.MSP_WssInternalListChangeTokens ON
                          dbo.MSP_EpmProject_UserView.ProjectUID = dbo.MSP_WssInternalListChangeTokens.ProjectUID INNER JOIN
                          dbo.MSP_EpmResource_UserView ON
                          dbo.MSP_EpmProject_UserView.ProjectOwnerResourceUID = dbo.MSP_EpmResource_UserView.ResourceUID
    GROUP BY dbo.MSP_EpmProject_UserView.ProjectName, dbo.MSP_EpmResource_UserView.ResourceName
    ORDER BY dbo.MSP_EpmProject_UserView.ProjectName


    Wednesday, April 6, 2011 6:50 PM