...
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 |
YesYesNo| Unavailable |
| ColumnPermissions |
YesNoYesYesYesNoYesYesYesYesYesYesYesNoYesYesYesYesYesYesYesYesYesYesNoYesYesYesNoYesYesNo| Unavailable |
| LinkedServerName |
YesNoNoYesYesYesYesYesYesYesNoYesYesNoYesYesNoYesYesNoNoYesNoNoYesNoYesYesNoNoYesNoNoYesYesNoYesYesYes| Available |
| SessionLoginName |
YesYesYesYesYesYesYesYesYesYesNoYesYesNoYesYesNoYesYesYesYes
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 | YesAvailableYes | Available | YesAvailable |
| appNameId | YesAvailableYes | AvailableNo | Unavailable |
| details | YesAvailableNo | Unavailable | YesAvailable |
| endSequence | YesAvailableYes | Available | YesAvailable |
| endTime | YesAvailableYes | Available | YesAvailable |
| eventCategory | YesAvailableYes | Available | YesAvailable |
| hash | YesAvailableYes | Available | YesAvailable |
| hostId | YesAvailableYes | AvailableNo | Unavailable |
| loginId | YesAvailableYes | Available | YesAvailable |
| privilegedUser | YesAvailableYes | Available | YesAvailable |
| startSequence | YesAvailableYes | Available | YesAvailable |
| targetObject | YesAvailableNo | Unavailable | YesAvailable |
...