PWA 2007: Where is the Timesheet Audit Log

[Paul Goldmann]

Hi,

in the timesheet options I can Enable Timesheet Auditing. Where do I see
this log?

Thanks
Paul

--
Paul Goldmann

[Vassil Velichkov]

That's a really good question. I've spent like one hour trying to find how
can you actually show the audit-log contents or run some reports on it. I
have a customer that desparetly needs such audit-log with some reports on it.

If we have to develop custom report that digs for data directly into the SQL
server database, OK, but there should be something out of the box...

Best regards,
Vassil Velichkov @ Gramma Systems
--
Gramma Systems - MCP & MCBSP

[Gary L. Chefetz [MVP]]

There is nothing "out of the box" except the logging itself. You need to dig
into the database.

--

Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project

"Vassil Velichkov" <VassilV...@discussions.microsoft.com> wrote in
message news:FEB494FF-E54D-47A6...@microsoft.com...

[Vassil Velichkov]

OK, that became obvious after the first 10 minutes. The other 50 minutes I've
spent "digging" into the DB. I couldn't find the appropriate table, or at
least a table that looks like a real log. The documentation for MS Project
2007 Server is awfull.

Any idea about which tables are used to store the log data?

P.S. After each new version of a Microsoft product the documentation becomes
less detailed and shorter....

--
Gramma Systems - MCP & MCBSP

[Gary L. Chefetz [MVP]]

Vassil:

Every table has a shadow table for auditing. Have you downloaded the SDK?

--

Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project

"Vassil Velichkov" <VassilV...@discussions.microsoft.com> wrote in

message news:AF89E19A-DD9E-4318...@microsoft.com...

[Vassil Velichkov]

Nop, but I will ;-). I hoped that there is some kind of high-level event
logging with time stamps, so we could keep track on certain user actions or
lack of such. "Shadow tables" is a nitty feature, but I suspect using it in
practice would require lots of digging. You just get updates in too many
tables for each high-level user action. Anyway, thank you for the
clarifications and the hints ;-)