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
at one or more of the following levels:
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 |
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal