5.5 NEW Auditing Chart

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

Depending on the auditing option you enable, different events get captured,

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

Event	Trace (.trc)	Extended Events (.xel)	Audit Logs (.audit)
ApplicationName	Yes	Yes	No
ColumnPermissions	Yes	No	Yes
BeforeAfter	Yes	Yes	No
DatabaseID	Yes	Yes	Yes
DatabaseName	Yes	Yes	Yes
DBUserName	Yes	No	Yes
EventClass	Yes	Yes	Yes
EventSequence	Yes	-	Yes
EventSubClass	Yes	Yes	Yes
FileName	Yes	No	Yes
HostName	Yes	Yes	No
IsSystem	Yes	Yes	No
LinkedServerName	Yes	No	No
LoginName	Yes	Yes	Yes
NestLevel	Yes	Yes	Yes
ObjectID	Yes	No	Yes
ObjectName	Yes	No	Yes
ObjectType	Yes	No	Yes
OwnerName	Yes	No	No
ParentName	Yes	No	No
Permissions	Yes	No	Yes
ProviderName	Yes	No	No
RoleName	Yes	No	No
RowCounts	Yes	Yes	No
ServerName	Yes	Yes	Yes
SessionLoginName	Yes	Yes	Yes
SPID	Yes	Yes	Yes
StartTime	Yes	Yes	Yes
Success	Yes	No	Yes
TargetLoginName	Yes	No	Yes
TargetUserName	Yes	No	Yes
TextData	Yes	Yes	Yes

SQL Compliance Manager Calculated Columns
You can capture different event data by using the different auditing options

Event	Trace (.trc)	Extended Events (.xel)	Audit Logs (.audit)
alertLevel	Yes	Yes	Yes
appNameId	Yes	Yes	No
details	Yes	No	Yes
endSequence	Yes	Yes	Yes
endTime	Yes	Yes	Yes
eventCategory	Yes	Yes	Yes
hash	Yes	Yes	Yes
hostId	Yes	Yes	No
loginId	Yes	Yes	Yes
privilegedUser	Yes	Yes	Yes
startSequence	Yes	Yes	Yes
targetObject	Yes	No	Yes