Loading...
Quick Links

Project Server 2010-accessing project site URLs programmatically

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

  • This topic is empty.
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #27654 Reply
    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 Reply
    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 Reply
    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 Reply
    manish
    Guest
Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Project Server 2010-accessing project site URLs programmatically
Your information: