none
Need information about extra columns for risks located in database RRS feed

  • Question

  • Hi Everyone

    Our developers have created few extra risks columns to store relative data in the risks table. However these columns do not appear in the dbo.MSP_WssRisk table. Still SP does show proper data when someone opens a project site and then risks list. Can you pls advise how does SP/Project server stores extra columns. The need of the hour is that developers need to fetch this data for Reporting purposes in another BI application.

    Any suggestions are welcome.


    Thanks Mohit


    • Edited by mohit.goyal Monday, February 15, 2016 1:11 PM
    Monday, February 15, 2016 1:11 PM

Answers

  • Mohit,

    By default they are not synced to the reporting tables, as you have already discovered. Since querying the content database is directly not supported, your options are as below:

    1) twrite a program, that calls all the sharepoint lists using REST API, and report on that data.

    2) Use a webpart like Content Serach Webpart, so that you can aggregate all the sharepoint data based on content type or another property

    3) Use a technique like this: https://pwmather.wordpress.com/2016/01/05/want-to-query-cross-project-site-sharepoint-lists-in-projectonline-projectserver-powerbi-powerquery-bi-office365-excel-ppm/


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    • Marked as answer by mohit.goyal Thursday, February 18, 2016 3:05 PM
    Monday, February 15, 2016 3:01 PM
    Moderator

All replies

  • Mohit,

    By default they are not synced to the reporting tables, as you have already discovered. Since querying the content database is directly not supported, your options are as below:

    1) twrite a program, that calls all the sharepoint lists using REST API, and report on that data.

    2) Use a webpart like Content Serach Webpart, so that you can aggregate all the sharepoint data based on content type or another property

    3) Use a technique like this: https://pwmather.wordpress.com/2016/01/05/want-to-query-cross-project-site-sharepoint-lists-in-projectonline-projectserver-powerbi-powerquery-bi-office365-excel-ppm/


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    • Marked as answer by mohit.goyal Thursday, February 18, 2016 3:05 PM
    Monday, February 15, 2016 3:01 PM
    Moderator
  • Thanks Adavi. The another BI application is Microstrategy and it can operate at database level only. Developers could write a webpart etc to do this, but that won't be useful for Microstrategy. Is there any solutions available at database level?

    Thanks Mohit

    Monday, February 15, 2016 3:24 PM
  • Hi Mohit,

    I've implemented a solution called "SharePoint List Extractor", which adds the custom columns and  new lists etc into the reporting database.  If you are interested please contact separately.


    Ben Howard [MVP] | web | blog | book | P2O

    Monday, February 15, 2016 4:49 PM
    Moderator
  • Hi Ben

    Thanks much. Can you please share your contact email address? Sorry, I'm not able to identify it.


    Thanks Mohit

    Tuesday, February 16, 2016 8:25 AM
  • You can get if off my website...

    Ben Howard [MVP] | web | blog | book | P2O

    Tuesday, February 16, 2016 9:08 AM
    Moderator