List of ProjectNames from Project Server RRS feed

  • Question

  • Hi,

    i want to retrive list of Project Names from Project server and show in a webpart,how to retrive Project Names from Project server ?


    Thursday, June 16, 2011 5:15 AM


All replies

  • Hello Pranay, 

    You can use the Project Web service - PSI of project server which returns you the project dataset which has all project Names in the dataset.

    For your ref:

    Thanks, Amit Khare |EPM Consultant| Blog:
    Thursday, June 16, 2011 5:42 AM
  • Hi Pranay,

    What version of project server are you using?

    While Amite Khare's answer will work, it might be easier to retreive the project names from the project server reporting database (if you are using 2007 or 2010).

    A simple quer on the ProjestServer_Reporting database like the one below will return the name of all published projects.

    SELECT ProjectName FROM MSP_EpmProject

    The reporting database schema is documented in the SDK. Depending on your needs you might need to extend the query with a where clause to filter out base on e.g. ProjectType, ...

    I hope this helps,

    My EPM blog: Projectopolis
    Thursday, June 16, 2011 5:48 PM