IDERA SQL Compliance Manager offers different auditing options, each option allows you to audit specific types of SQL Server event data. 

If you choose to audit via Extended Events or Audit Logs, the unavailable information will be gathered from the Trace Events.


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

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

Extended Events captures extra Execute events

Due to differences in how Microsoft has implemented Extended Events compared to other auditing methods, when auditing via Extended Events the user will see extra Execute events as compared to the same data captured by other auditing methods.

NOTE

  • 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.

SQL Compliance Manager Calculated Columns

Depending on your auditing selection SQL Compliance Manager allows you to capture the following calculated columns event data type.

EventTrace Events (.trc)Extended Events (.xel)Audit Logs (.audit)
alertLevelAvailableAvailableAvailable
appNameIdAvailableAvailableUnavailable
detailsAvailableUnavailableAvailable
endSequenceAvailableAvailableAvailable
endTimeAvailableAvailableAvailable
eventCategoryAvailableAvailableAvailable
hashAvailableAvailableAvailable
hostIdAvailableAvailableUnavailable
loginIdAvailableAvailableAvailable
privilegedUserAvailableAvailableAvailable
startSequenceAvailableAvailableAvailable
targetObjectAvailableUnavailableAvailable



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels