Page History
| Note |
|---|
In SQL Compliance Manager version 5.6.1 the Row count functionality may show as “Not Applicable”. The issue occurs when you execute large query and during execution the start and the end of the SQL Statement get captured in different trace files. Since both events are located in different trace files, SQL CM is not able to map these events and therefore displays that Row count is “Not Applicable”. Users can increase the time of collection (default is set to 60 seconds) to capture Row count correctly |
| Note |
|---|
This feature is only available for SQL Server 2008 and above. |
...
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 viewView.
For select statements with sensitive columns, event properties contain a Sensitive Columns tab which shows the row count value for each audited sensitive column.
...
For more information, see Report on Audit Data.
...