IDERA SQL Compliance Manager offers different auditing options, each option allows you to audit specific types of SQL Server event data.
Depending on your auditing selection SQL Compliance Manager allows you to capture the following types of event data.
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
Depending on your auditing selection SQL Compliance Manager allows you to capture the following calculated columns event data type.
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