none
Full List of Risks/Issues across all projects. RRS feed

  • Question

  • Hello,

    I am looking for a way of getting a full list of all the risks / Issues in all projects. Is this possible? And if so how can it be done?

    Thanks,

    Aaron.

    Tuesday, May 12, 2015 8:28 AM

Answers

All replies

  • Hello,

    I would look at doing this via reporting. What version of Project Server do you use? If Project Server 2007/2010 in the Reporting database you will see many tables, look for "MSP_WssIssue" and "MSP_WssRisk" or for Project Server 2013 in the Project Web App databases these tables will exist in the DBO schema. These tables will contain the Risks and Issues from the Project Sites.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, May 12, 2015 9:02 AM
    Moderator
  • Hello Paul,

    Thanks for the quick reply.

    I am using project server 2013. How do I access the DBO schema? 

    Thanks,

    Aaron

    Tuesday, May 12, 2015 9:21 AM
  • Hello,

    What reporting tool are you going to use? If Excel, you can either connect to the database and write your query or use one of the ODC file already created in the <pwa site>/ProjectBICenter/Data%20Connections/Forms/AllItems.aspx there are two ODCs file that might help: Project Server - Issue Data and Project Server - Risk Data. You will need access to the Reporting Schema for this to work. See: https://technet.microsoft.com/en-us/library/ee662106.aspx Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, May 12, 2015 9:54 AM
    Moderator
  • Hello,

    Thanks again for the help, I have used the OData data feed in excel to import the risks list into excel.

    The only issue I am having now is when I import the list the project ID and Risk ID are just appearing as a string of digits, for example (6b5a25a0-60f5-e411-80c7-00155d785815 is the project ID) Is there a way of getting this to show the real IDs??

    Regards,

    Aaron

    Tuesday, May 12, 2015 10:20 AM
  • Hello,

    Using OData this is not possible directly, using the SQL tables you will see columns for IssueID and RiskID - these are the IDs you see on the SharePoint lists. Using Odata you could infer the ID as it is included in the ItemRelativeUrlPath property.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, May 12, 2015 10:45 AM
    Moderator