November 30, 2010 at 4:32 pm
i have implemented the sql audit for the sql server 2008 sp1.When view the audit logs I am wondering why does it display the wrong date and time.....?
November 30, 2010 at 9:24 pm
Where is the SQL Server instance located?
August 19, 2011 at 1:46 pm
I'm having the same issue on multiple servers. All are in EST, and SQL logs, Agent logs, Database Mail logs, etc. ALL have correct date and time, but Server Audit logs display 4 hours into the future.
August 19, 2011 at 2:33 pm
Timothy Batts (8/19/2011)
I'm having the same issue on multiple servers. All are in EST, and SQL logs, Agent logs, Database Mail logs, etc. ALL have correct date and time, but Server Audit logs display 4 hours into the future.
It is probably recording the time in UTC time because four hours is the current offset from Eastern Daylight Time to UTC time.
Eastern Daylight Time = UTC -4
May 22, 2013 at 10:49 am
My Server shows 11 AM and the logs show 4AM. Damn whats the issue with this?
May 22, 2013 at 1:55 pm
June 9, 2014 at 10:28 am
Hello I have the same issue, i use this alternative way
SELECT DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), CURRENT_TIMESTAMP), event_time )
as corrected_time,
action_id ,
session_server_principal_name,
server_instance_name ,
database_name ,
schema_name ,
object_name ,
statement ,
file_name FROM sys.fn_get_audit_file( 'C:\*.sqlaudit' , DEFAULT , DEFAULT)
I hope it been usefull
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply