How we can read one month ago data in project server 2010 ? RRS feed

  • General discussion

  • I wanna read one month ago data from timesheet for a user how can I do that ?

    I hope some one help me?for answer question no other things .

    Saturday, October 23, 2010 11:34 AM

All replies

  • Hi alipashaei,

    You can query the Reporting database to get the information you need.

    All timesheet hours are in the 'MSP_TimesheetActual' table. You can link it to the MSP_Timesheet and other tables to retreive the timesheet status, etc.

    For a complete reference of the Reporting Database, see the Project 2010 SDK.

    I hope this helps,

    My EPM blog: Projectopolis
    Monday, October 25, 2010 2:44 PM