Skip to Content
0
Feb 15, 2011 at 09:11 PM

Auditing database records wrong time, CMS shows correct time

204 Views

Hello all,

We have recently upgraded to XI3.1. The auditing database is recording data where I have set areas to audit. I was following-up on some auditing data when I noticed the AUDIT_EVENT table Date_Timestamp field was not correct for a report that I had just run. The time showed 2011-02-15 20:14:10.000 which is 8:14 pm and I ran the report at 3:14pm. I checked the datetime setting on the web server and it is correct. Checked the CMS Preferences settings and they were set to server default so they should have been correct, but I reset them for Eastern time for US&Canada and tested again with same results. Checked the CMS metrics and they showed correct time. The SIA server runs under an AD domain service account and the web publishing service runs under the local system account. The server is Windows 2003 and I use IIS with IE8. Does anyone know what else I should check or what the problem may be?

Thank you in advance for any help,

Wendy