Page History
...
Row count information is captured as part of an audit event and gathers information from both, traces and extended events.
| Note |
|---|
When enabling the ‘Capture DML and SELECT activities using SQL Server Audit specifications’, row count information does not show. This happens because the auditing is being processed through audit logs. Row Count information does not show when capturing DML and SELECT activities using SQL Server audit specifications. |
See row count information
The row count information is available in the General tab of any event properties, as well as the Audit Events tab in the Explore Activity view.
For select statements with sensitive columns
In the Event Properties Dialog under the general tab, add row count next to the
SQL Statement. (Figure 5.3.2.4)
● For the select statement with sensitive columns ( Figure 5.3.2.5 ), there is an extratab on the event properties dialog named sensitive columns. Insert a new column
labeled row count to the right of the existing column and make the new column
value right aligned. Both column and row count columns on the sensitive column
tab should be sortable
● On the Audit Event Tab ( Figure 5.3.2.6 ) the row count information should be
displayed on the expanded event details in the audit events - for Select Events.
● Events with a join statement should have one row count result. The row count
should reflect the entirety of the statement and the UI should have one
consolidated total for row count. The UI should show the entire join statement as
has a Sensitive Columns tab which shows the row count value for each audited sensitive column.
When you expand the audit events, the Audit Event tab shows the row count information in the event details. one statement (and not the components of the join statement).