Loading...
Quick Links

Reply To: Project Server 2010-accessing project site URLs programmatically

Home Forums Discussion Project Server 2010-accessing project site URLs programmatically Reply To: Project Server 2010-accessing project site URLs programmatically

#28256
Bastian Emondts
Guest

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]