Time in an Audit log is displayed in UTC

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Time in an Audit log is displayed in UTC

Author

Topic

ozSQLServer
Starting Member

32 Posts

Posted - 2011-09-22 : 21:47:42

Hi,

I've successfully created a Server Audit as follows:

USE [master]

CREATE SERVER AUDIT [Audit-SecurityLog]
TO FILE 
( FILEPATH = N'D:\temp\AuditFiles\'
,MAXSIZE = 2048 MB
,MAX_ROLLOVER_FILES = 2147483647
,RESERVE_DISK_SPACE = OFF
)
WITH( QUEUE_DELAY = 0 ,ON_FAILURE = CONTINUE)

Then I successfully created an Audit Specficiations to audit operations on a single table.

Then the Auditing works just fine.

When I viewed the Auditing logs (instance> Security> Audits> right-Click created audit and select View Audit Logs), I've seen the logs and noticed that the Event Time is filled with exactly 10 hours difference from the actual operation times.
Windows Server hosting the SQL Server is set to Sydney time zone which is currently +10 GMT.

So, does that mean SQL Server always registers the log entries in UTC?

Cheers,
ozSQL

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources