Home › Forums › Discussion Forum › Project Server 2010-accessing project site URLs programmatically
Tagged: Project Server 2010, project site
Where in the Project Server database is the project site URLstored for a project? I can see the URLs by looking at Server Settings / Operational Policies / Project Sites but I need to pull information from lists on each project site for a report, so I need to find the project site URLs programmatically (i.e using SQL). I am familiar with querying the reporting database but I haven’t been able to find a field or table where these URLs are stored, in either the reporting or the published databases. Has anyone figured this out?
The field you are search for is called ProjectWorkspaceInternalHRef it can for example be found in view
MSP_EpmProject_UserView.
The following query should provide you with project name and corresponding URL:
SELECT [ProjectUID], [ProjectName], [ProjectWorkspaceInternalHRef]
FROM [ProjectServer_Reporting].[dbo].[MSP_EpmProject_UserView]
Thanks very much for your help. It iwll be much easier for me to pull this information from the reporting database than by scanning for it in SP.