Audit Log Report

[Bill Busby]

I'm trying to find a clear example of how to extract the audit log from
Project Server 2007. I've learned it's not in the reporting db (that I can
find) and we don't have the schema published for the rest of the environment.
At one point I think I saw a code example of how to extract the log data via
PSI but I can't find the example any more.

How are the rest of you pulling timesheet audit log data for reporting?

 

[NZ Projects]

Search for Timesheet Audit in the SDK !

 

[Bill Busby]

Now we get back to 'clear example'. I'm not a developer but I play one on TV.
The entry for 'Audit Time Report' in the SDK shows a report in SRS that is
just a regurgitation of the current timesheet history. There is a reference
to a method Admin.ReadTimesheetAuditLog which returns
TimesheetAuditExportDataSet. I can likely figure out how to make the soap
call to the method and get the data set but I'm lost in bridging the gap from
the dataset to a readable output. I'm not asking for anyone to do my homework
for me but if anyone has already done this or knows where the reference was
to the blog entry that held an example some love would be appreciated. My
background is primarily as a UNIX Perl developer and I'm struggling to make
the transition to C#.

 

[Rob]

Bill, have you explored the "SQL Server Reporting Services Report Pack for
Project Server 2007"?
It specifically has a Timesheet Audit Report which may help you out.

http://msdn2.microsoft.com/en-us/library/bb428822.aspx

Hope this helps,
-RS

 

[Bill Busby]

Rob, thanks for the response. Yes, I've reviewed the Timesheet Audit Report
in SRS but the name is a bit misleading. It's actually just an extract of
timesheet data, not an audit trail of the actions (updates, deletes, etc.)
that represent how the data was entered and maintained. I imagine the intent
was to provide a way to 'audit' the completeness of a resource's time but I'm
looking for the true audit log that shows each update and modification of
timesheets that can be used to track user actions. We've had frequent
questions in the past of "what happened?" when complains are made about time
missing, etc. I would like to be able to clearly show that, if an entry is
missing, that user 'A' deleted the line or removed the time entry instead of
having people blame the system for dropping the data... an all too frequent
response I get now.