Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This tab allows you to sort and analyze SQL events collected from the SQL Server instances and databases you are auditing.

Available actions

View Before-After data

Allows you to view before and after data for DML events, according to the affected table or column. You can also change the display from a multi-level grid to a flat grid by clicking Flatten Data.

...

Allows you to view details about the selected event.

Default columns

Icon

Provides a visual indication of the event category associated with the event so you can quickly scan the listed events for a specific type, such as a security event.

...

Provides the text description of the event.

Before-After audit columns

Action

Provides the type of DML event that caused the table column to change (UPDATE, INSERT, or DELETE).

...

Provides the name of the SQL login that applied the change, using the format DomainName\LogonName.

Sensitive Column audit columns

Action

Displays the SELECT event that read the table column.

...

Provides the name of the computer where the event was initiated.

Additional columns

You can add any of these columns to this tab using the Select Column action. After you add a new column, you can save the tab as a custom view to reference later.

...

Provides the name of the database user targeted by the T-SQL statement associated with this event.

 

SQL Compliance Manager audits all activity on your server. Learn more > >