none
Project Server audit log RRS feed

  • Question

  • HI,

    I am working on EPM 2010 and would like to know whether there is any way to get the audit report (i.e. modified, modified by etc..) within project server. I had gone through each and every table and i do not see any columns (other than version table which does not has any relation to the Project GUID field) that i need to capture. Any suggestions???

    Wednesday, January 11, 2012 9:33 PM

Answers

All replies

  • A couple ways that I can think of, but nothing out of the box:
     
    1) Take a SQL snapshot of your Reporting DB on a timed interval capturing
    the Last Modified, Last Published, and other data that you wish to track.
    2) Write a macro to write entries into a database every time something is
    changed in Project.
     
    I typically see the first option used.
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Thursday, January 12, 2012 1:04 AM
    Moderator
  • A couple ways that I can think of, but nothing out of the box:
     
    1) Take a SQL snapshot of your Reporting DB on a timed interval capturing
    the Last Modified, Last Published, and other data that you wish to track.
    2) Write a macro to write entries into a database every time something is
    changed in Project.
     
    I typically see the first option used.
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Thursday, January 12, 2012 1:07 AM
    Moderator
  • The other approach would be to write custom event handlers to log information into a database, or a list within SharePoint. The custom code would need to be associated with the various events that you would wish to logon, like Project Published etc.

     

     


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Thursday, January 12, 2012 1:29 AM
    Moderator
  • Agreed with Andrew & Alex, I have created a project, task, & resource level custom field "Audit required" & based on the project publish/resource account create/update, event handler connects to custom database which updates the project, task & resource level information in Audit dataabase.

    Also, for one of the customer, created a PDP which keeps all the project level fields & on click on Save/publish option, It connects to custom database & updates the data.

    Hope that helps.
    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Thursday, January 12, 2012 6:59 AM
  • Yeah... Thanks for your response and I do agree with all of you. If possible, may I have that code sample or complete code by any chance? Or any website?
    Friday, January 13, 2012 3:21 PM
  • Yes, there is a sample code written by Christophe for Delegation event handler, Similar way, You can use the project on Save/publish event & store the desired fields in Custom databaase. This will give you a good start to enhance the code.
    http://blogs.msdn.com/b/chrisfie/archive/2010/06/03/project-server-2010-delegation-audit-event-handler.aspx

    Hope that helps.
    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Monday, January 16, 2012 8:34 AM