Question

audit trail logging time

Audit Trail Version 9

Updated April 19, 2016

asked on July 9, 2014 • Show version history

It appears that when events are logged to the audit_event table in audit trail, the event_time is being logged five hours into the future.

I deleted a document at 10:05 am today. After refreshing my query, the document shows in the audit_event table as being deleted 3:05 pm today. The system time on the machine where the repository and audit trail are installed is current. Any ideas what could be causing this? As I write this question, it's 10:30 am, so even if I am looking at the wrong entry (which I don't think is the case, since only 1 entry was deleted today), events are still being logged with future times.

The audit trail tables were created in the same database as the repository that is being audited. Could this be part of the issue?

0 0

Answer

SELECTED ANSWER

replied on July 9, 2014 • Show version history

The times stored in the database are UTC. When you run a report in the Audit Trail Web Reporter, the times will be converted by default to the browser time zone.

2 0

Replies

replied on April 18, 2016

We ran into a similar issue with one of our customers, where Audit Trail time seems to be an hour off from the documents themselves. (E.g. the document says it was created at 10:17AM and the Audit Trail says it was created at 11:17AM.)

The time settings in the Audit Trail says it is Pacific Time, and the servers say they are Pacific time as well.

Is there anywhere else we would need to check to make sure the time is set up correctly and accurately?

0 0

replied on April 18, 2016

We've fixed some display issues related to time zones in the 10.1 release. Specifically, the current daylight savings adjustment was being applied to all times, which causes times in the other half of the year to be off by an hour.

0 0

replied on April 19, 2016

Also, this should only be an issue if Audit Trail tries to automatically detect the browser time zone. If you choose a time zone from the picker, it should have all of the correct DST rules.

0 0

You are not allowed to follow up in this post.

Question

Question

audit trail logging time

Answer

Replies

Sign in to reply to this post.