Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Depending on your auditing selection SQL Compliance Manager allows you to capture the following types of event data.

Note
titleNOTE

...

  • The Extended Events auditing feature is only available with SQL Server 2012 and newer. 

...

  • The Audit Logs auditing feature is only available with SQL Server 2017 and newer. 
EventTrace Events (.trc)Extended Events (.xel)Audit Logs (.audit)
ApplicationName

Available

AvailableUnavailable
ColumnPermissionsAvailableUnavailableAvailable
BeforeAfterAvailableAvailableUnavailable
DatabaseIDAvailableAvailableAvailable
DatabaseNameAvailableAvailableAvailable
DBUserNameAvailableUnavailableAvailable
EventClassAvailableAvailableAvailable
EventSequenceAvailable-Available
EventSubClassAvailableAvailableAvailable
FileNameAvailableUnavailableAvailable
HostNameAvailableAvailableUnavailable
IsSystemAvailableAvailableUnavailable
LinkedServerNameAvailableUnavailableUnavailable
LoginNameAvailableAvailableAvailable
NestLevelAvailableAvailableAvailable
ObjectIDAvailableUnavailableAvailable
ObjectNameAvailableUnavailableAvailable
ObjectTypeAvailableUnavailableAvailable
OwnerNameAvailableUnavailableUnavailable
ParentNameAvailableUnavailableUnavailable
PermissionsAvailableUnavailableAvailable
ProviderNameAvailableUnavailableUnavailable
RoleNameAvailableUnavailableUnavailable
RowCountsAvailableAvailableUnavailable
ServerNameAvailableAvailableAvailable
SessionLoginNameAvailableAvailableAvailable
SPIDAvailableAvailableAvailable
StartTimeAvailableAvailableAvailable
SuccessAvailableUnavailableAvailable
TargetLoginNameAvailableUnavailableAvailable
TargetUserNameAvailableUnavailableAvailable
TextDataAvailableAvailableAvailable

...