Tracking MSPS Timesheet save/update activities

All replies

• 

  

  0

  Sign in to vote

  Hi Kumar,

  See Christophe's blog post here:

  http://blogs.msdn.com/b/chrisfie/archive/2007/10/10/how-to-extract-and-view-timesheet-audit-data.aspx

  Thanks

  Paul

  ---

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

  Wednesday, January 16, 2013 11:31 PM
• 

  

  0

  Sign in to vote

  Hi Paul,

  Thanks for the reply.

  In our case, we have access only to Reporting DB, we are not given even read access to Published DB.

  Hence Christophe's approach will not work in this case.

  Is there any other approach involving only the Reporting DB ?

  Regards,

  Kumar

  Thursday, January 17, 2013 2:13 PM
• 

  

  0

  Sign in to vote

  Hi there,

  Glad to hear you don't have read access to the Published DB for direct SQL queries - even though the link I posted queries the Published DB, officially it is only supported to query the Reporting database directly with T-SQL :)

  How about you write a PSI app to get this data:

  http://msdn.microsoft.com/en-us/library/office/gg179068(v=office.14).aspx

  Thanks

  Paul

  ---

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

  • Proposed as answer by Amit Khare - Project Management Consultant Friday, January 18, 2013 11:27 AM

  Thursday, January 17, 2013 2:24 PM
• 

  

  0

  Sign in to vote

  We shouldn't need to use PSI or try and use Published Database.

  There is a field in the Reporting Database and it is not properly populated. Isn't that a simple bug to be fixed.

  What we do see (on PS2007)  is mostly a timestamp same as create date. But with time as 00:00

  Then sometimes it is a later date but again time as 00:00

  But then somethime it is a full date/time.

  Quite peculiar. I don't think our users are changing timesheets at midnight

  Mike

  ---

  MikeCro

  Wednesday, November 27, 2013 12:18 PM