How to capture the user activities in Project Server 2010 RRS feed

  • Question

  • Hi

    I want  to capture the user activities from Project Server 2010 like when a user has saved and published etc.

    Is there any possibility that we can get the user activities data from sql server.

    Please throw some light on the same.


    Geeth If you feel that the answer which i gave you is Helpful please select it as Answer/helpful.

    Monday, March 24, 2014 12:21 PM

All replies

  • Hi Geetha,

    As far as I know, there is no such information stored in Project Server DB.

    You can have this kind of information by project, such as the ProjectModifiedDate in the Reporting DB (MSP_EPMProject_userView). I also know that there is a PROJ_LAST_SAVED date in the Draft DB. But be aware that querying in the Draft DB is not supported by MS.

    Another way would be doing some custom code, storing in a separate DB each save and publish operation per user.

    Hope this helps.

    Guillaume Rouyre - MBA, MCP, MCTS

    Monday, March 24, 2014 12:47 PM