Page History
IDERA SQL Compliance Manager offers different auditing options, each option allows you to audit specific types of SQL Server event data.
Info |
---|
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.
Event | Trace Events (.trc) | Extended Events (.xel) | Audit Logs (.audit) |
---|---|---|---|
ApplicationName | Available | Available | Unavailable |
ColumnPermissions | Available | Unavailable | Available |
BeforeAfter | Available | Available | Unavailable |
DatabaseID | Available | Available | Available |
DatabaseName | Available | Available | Available |
DBUserName | Available | Unavailable | Available |
EventClass | Available | Available | Available |
EventSequence | Available | - | Available |
EventSubClass | Available | Available | Available |
FileName | Available | Unavailable | Available |
HostName | Available | Available | Unavailable |
IsSystem | Available | Available | Unavailable |
LinkedServerName | Available | Unavailable | Unavailable |
LoginName | Available | Available | Available |
NestLevel | Available | Available | Available |
ObjectID | Available | Unavailable | Available |
ObjectName | Available | Unavailable | Available |
ObjectType | Available | Unavailable | Available |
OwnerName | Available | Unavailable | Unavailable |
ParentName | Available | Unavailable | Unavailable |
Permissions | Available | Unavailable | Available |
ProviderName | Available | Unavailable | Unavailable |
RoleName | Available | Unavailable | Unavailable |
RowCounts | Available | Available | Unavailable |
ServerName | Available | Available | Available |
SessionLoginName | Available | Available | Available |
SPID | Available | Available | Available |
StartTime | Available | Available | Available |
Success | Available | Unavailable | Available |
TargetLoginName | Available | Unavailable | Available |
TargetUserName | Available | Unavailable | Available |
TextData | Available | Available | Available |
Note | ||
---|---|---|
| ||
|
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 Events (.trc) | Extended Events (.xel) | Audit Logs (.audit) |
---|---|---|---|
alertLevel | Available | Available | Available |
appNameId | Available | Available | Unavailable |
details | Available | Unavailable | Available |
endSequence | Available | Available | Available |
endTime | Available | Available | Available |
eventCategory | Available | Available | Available |
hash | Available | Available | Available |
hostId | Available | Available | Unavailable |
loginId | Available | Available | Available |
privilegedUser | Available | Available | Available |
startSequence | Available | Available | Available |
targetObject | Available | Unavailable | Available |
Scroll pdf ignore |
---|
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |