none
Query to get all Project Server Customisation. RRS feed

  • Question

  • Hello mate-

    I am trying to find sample queries which I can run in either published or reporting db in order to get all the front end level customization that I may have done in my PWA 2010 instance. Like,

    1. Users, Security. Groups, category.

    3. Views a& Setup.

    4. PDPs, workflows.

    5. project site and settings.

    6. time & task related settings and data

    etc,.,..

    I am planning to create a master data sheet for my customer.

    Thanks and looking forward to read from you guys.


    Dev EPM Consultant

    Sunday, February 23, 2014 9:27 AM

Answers

  • Hi,

    In addition to the excellent answer from Paul, I'd mention the PLAYBOOK that is a MS tool to backup and restore PS2010 server settings. It will be store in an XML file and is quite helpful to save server settings or copy/paste from an instance to another.

    Here are the links:

    • http://technet.microsoft.com/en-us/library/gg128952(v=office.14).aspx
    • http://www.microsoft.com/en-us/download/details.aspx?id=22810

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Sunday, February 23, 2014 3:33 PM
    Moderator

All replies

  • Hello,

    To data is stored in the Published DB, you shouldn't be querying this DB directly with T-SQL, you will need to use the PSI. The PDP's and workflows will be stored in the SP content database, again you shouldn't query this DB directly either, you will need to use the SP object model. If you are not familiar with the PSI, download the Project 2010 SDK:

    http://www.microsoft.com/en-gb/download/details.aspx?id=15511

    We have done something similar before that used the PSI to get all the Project Server config and wrote this to a word document - works very well but did take a lot of dev time.

    Alternatively look at a 3rd party product:

    http://www.fluentpro.com/productsfluentbooks.html

    Paul


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

    Sunday, February 23, 2014 10:56 AM
    Moderator
  • Hi,

    In addition to the excellent answer from Paul, I'd mention the PLAYBOOK that is a MS tool to backup and restore PS2010 server settings. It will be store in an XML file and is quite helpful to save server settings or copy/paste from an instance to another.

    Here are the links:

    • http://technet.microsoft.com/en-us/library/gg128952(v=office.14).aspx
    • http://www.microsoft.com/en-us/download/details.aspx?id=22810

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Sunday, February 23, 2014 3:33 PM
    Moderator