Starting IDERA SQL Compliance Manager 6.0 and above, the SQL Compliance Manager default Event Collection method is SQL Server Audit Specifications. Use the SQL Server Audit Logs feature to track specific events occurring in your monitored environment. SQL Server Audit Logs is an event-handling system that helps you reduce the size of data gathered and deliver performance gains over the default SQL trace method. In SQL Compliance Manager 5.5 and later, only SELECT and DML events for SQL Server 2017 and later versions are supported by this feature.

Upon version upgrade or new installation, the SQL Compliance Manager Event Collection method setting changes to "SQL Server Audit Specifications" by default. Users can manually change the collection method.  

Before and After Data is not supported on the RDS instance due to the limitation of creating trusted assemblies using SQL script. BAD operations are removed from the properties, reports, alerts, and summary tabs.

To manually change the capturing events method, go to:

Prerequisites and conditions for enabling auditing using Audit Logs

IDERA SQL Compliance Manager supports Audit Logs based auditing for SQL Server 2017 and above. The following prerequisites and conditions are required to switch auditing based on Audit Logs. 

 When using SQL Server Audit, due to a technical limitation, it's recommended to limit the number of Trusted and Privileged users included in audit configurations. Exceeding certain thresholds may prevent audit rules from being applied as expected.

Enable Audit Logs mode using the Windows Management Console

Users wanting to take advantage of SQL Server Audit Logs auditing capabilities can do so by completing the following steps:

  1. Right-click the instance you want to audit and select Properties. 
  2. In the Registered SQL Server Properties window, select the Audited Activities tab. 
  3. Under the Capture DML and Select activities options, select the Via SQL Server Audit Specifications option.
  4. Click OK. 

For more information about enabling this feature using the Windows Management Console, see Registered SQL Server Properties window - Audited Activities tab. 



 |   |  |  |   |   |   |