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. |
| Note |
|---|
To capture row count information, update the SQL Compliance Manager Agent to version 5.5 or above. |
IDERA SQL Compliance Manager audits and reports on the frequency that users access sensitive data, alerting about suspicious behavior.
...
| Note |
|---|
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 viewView.
...
For select statements with sensitive columns, event properties contains contain a Sensitive Columns tab which shows the row count value for each audited sensitive column.
When you expand the audit events, the Audit Events tab shows the row count information in the event details.
| Info |
|---|
If you use select SQL statements with joined queries, SQL Compliance Manager displays two row count multiple (equivalent to the number of distinct queries joined) events, however, row count information is available only with the primary statement and not applicable with any sub other statements. |
Row count Alerts
IDERA SQL Compliance Manager allows you to set alerts on row count and data access. Alerts can be set by row count alone or adding a specific time interval.
For more information, see Alert on Audit Data and Status.
| Info |
|---|
For select If you use SQL statements with joined queries, only the primary statement triggers any configured alert set for row count alert. |
Row count Reports
IDERA SQL Compliance Manager allows you to generate reports on data access, including the new row count feature. You can generate reports with the SQL Compliance Manager console and with Reporting Services.
For more information, see Report on Audit Data.
| Scroll pdf ignore |
|---|
SQL Compliance Manager audits all activity on your server. Learn more > > IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |
...