Versions Compared

Key

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

...

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 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 

...

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. 

...