none
Project Server 2013 Audit Trial RRS feed

  • Question

  • Hi All,

    We are using project server 2013. Is it possible to get audit trials like who and when the users/resources are created. Who and when the users or projects are deleted etc.


    Thanks in advance, Arun

    Thursday, June 12, 2014 3:10 PM

Answers

  • Hi Arun,

    For your first question, in the Reporting table, you'll find the "ResourceCreatedDate" in dbo.MSP_EpmResource view.

    For the project/user deletion, then it is more tricky since the object will not be anymore in the reporting DB to query it. You'll probably need to do some custom code catching events with the event handler.

    Note also that Fluent Pro releases an audit tool for PS2013: 

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


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    • Marked as answer by arun_2014 Wednesday, June 18, 2014 8:24 AM
    Thursday, June 12, 2014 3:25 PM
    Moderator
  • Arun,

    There is no default way to do this. You have few options:

    1) If you know programming, you can write something using the events available in Project Server

    2) You can use a third party product like FluentPro Audit Pro (my personal preference)

    3) You can use Nintex workflow, if you have that product. Here is how: (http://www.prasannaadavi.com/2014/05/build-audit-log-for-project-server.html)

    4) You could use Powershell to some extent (http://pwmather.wordpress.com/2012/03/05/projectserver-2010-2007-high-level-audit-export-via-powershell-msproject-ps2010-epm/)


    Prasanna Adavi,PMP,MCTS,MCITP,MCT TWitter: @prasannaadavi Blog: http://www.prasannaadavi.com

    • Marked as answer by arun_2014 Wednesday, June 18, 2014 8:24 AM
    Thursday, June 12, 2014 3:26 PM
    Moderator

All replies

  • Hi Arun,

    For your first question, in the Reporting table, you'll find the "ResourceCreatedDate" in dbo.MSP_EpmResource view.

    For the project/user deletion, then it is more tricky since the object will not be anymore in the reporting DB to query it. You'll probably need to do some custom code catching events with the event handler.

    Note also that Fluent Pro releases an audit tool for PS2013: 

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


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    • Marked as answer by arun_2014 Wednesday, June 18, 2014 8:24 AM
    Thursday, June 12, 2014 3:25 PM
    Moderator
  • Arun,

    There is no default way to do this. You have few options:

    1) If you know programming, you can write something using the events available in Project Server

    2) You can use a third party product like FluentPro Audit Pro (my personal preference)

    3) You can use Nintex workflow, if you have that product. Here is how: (http://www.prasannaadavi.com/2014/05/build-audit-log-for-project-server.html)

    4) You could use Powershell to some extent (http://pwmather.wordpress.com/2012/03/05/projectserver-2010-2007-high-level-audit-export-via-powershell-msproject-ps2010-epm/)


    Prasanna Adavi,PMP,MCTS,MCITP,MCT TWitter: @prasannaadavi Blog: http://www.prasannaadavi.com

    • Marked as answer by arun_2014 Wednesday, June 18, 2014 8:24 AM
    Thursday, June 12, 2014 3:26 PM
    Moderator