Project Server 2010-accessing project site URLs programmatically

Home Forums Discussion Forum Project Server 2010-accessing project site URLs programmatically

Viewing 3 reply threads
  • Author
    Posts
    • #27654
      Michele Heine
      Participant

      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?

       

    • #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]

    • #28370
      Phil Dumitru
      Guest

      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.

    • #398966
      manish
      Guest
Viewing 3 reply threads
  • You must be logged in to reply to this topic.