none
Cannot Find a New Project Site Field Created created under the Risk List. Project Server 2010 RRS feed

  • Question

  • We have created a new field /Column under the Risks List. We are trying to find on what database this is stored as we are trying to create a sql report with the data. Can someone please assist

    Thanks

    Willem


    Willem

    Thursday, September 5, 2013 5:52 AM

Answers

  • Hi Willem, new custom columns will be only be available in the content database where the Projects sites are stored. Default columns in the risks and issues lists are synchronised to the Project Server reporting database. It is not supported to directly query the content database, you need to use the web services. With SSRS 2008 R2 or later you have a SharePoint List data source, you could use this to get all of the issues or risks data. Paul

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

    Friday, September 6, 2013 8:32 PM
    Moderator

All replies

  • Issues and Risks items are stored in Project Sites, which uses content database associated with PWA web application.


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Friday, September 6, 2013 4:09 PM
    Moderator
  • Hi Willem, new custom columns will be only be available in the content database where the Projects sites are stored. Default columns in the risks and issues lists are synchronised to the Project Server reporting database. It is not supported to directly query the content database, you need to use the web services. With SSRS 2008 R2 or later you have a SharePoint List data source, you could use this to get all of the issues or risks data. Paul

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

    Friday, September 6, 2013 8:32 PM
    Moderator