IDERA SQL Compliance Manager provides the following new features and fixed issues.
IDERA, Inc. customers have the sole responsibility to ensure their compliance with the laws and standards affecting their business. IDERA, Inc. does not represent that its products or services ensures that customer is in compliance with any law. It is the responsibility of the customer to obtain legal, accounting, or audit counsel as to the necessary business practices and actions to comply with such laws.
5.3 New features
Expanded the SQL Compliance Manager Web console to provide a richer set of capabilities online
IDERA SQL Compliance Manager 5.3 continues to build on the work developed by prior versions to bring a richer set of capabilities to the web console. New web capabilities include:
- an ability to set up notifications for auditing thresholds; allowing a user to set up a threshold and select the delivery method such as email, Windows event log, or SNMP traps.
- additional views such as the Enhanced Audited Database, Enhanced Alert, and New Logs views.
- the ability to export views to PDF, CSV, and XML formats.
- additional new widgets that show different activities and audited SQL Server instances.
Integration with IDERA Dashboard 2.2
IDERA Dashboard integration began with SQL Compliance Manager 5.0, which centralizes the common administration, tasks, and views across all IDERA SQL products. This release of SQL Compliance Manager expands this integration by supporting IDERA Dashboard 2.2, which includes the following widgets specific to SQL Compliance Manager:
- SQL Compliance Manager Audited Instances Widget. Displays a list of audited SQL Server instances.
- SQL Compliance Manager Enterprise Activity Report Card. Displays your SQL Compliance Manager enterprise activity in a line graph.
For more information about using SQL Compliance Manager widgets within the IDERA Dashboard, see Use SQL Compliance Manager widgets in the IDERA Dashboard.
5.3 Fixed issues
General
- Resolved an issue that did not properly update group permissions after modification and honored group settings over the individual user account in some situations.
- Improved Permissions Check functionality to prevent false or inconsistent results.
Installation
- Renamed the SQL Compliance Processing database from
SQLCompliance.ProcessingtoSQLComplianceProcessing. - Corrected an issue preventing the ... button from properly working in the Add SQLcompliance Agent Service window on Windows 2012/2012 R2 installations.
Licensing
- Resolved an issue causing users with AlwaysOn Availability Groups to receive a message that the maximum number of servers is reached while they actually had less than that limit.
Services
- Improved the Collection Service performance to be able to process a substantially large number of trace files.
Auditing
- SQL Compliance Manager now can log events that are accessed through a view.
- Sensitive column traces no longer include events from databases not configured for sensitive column auditing.
- Resolved an issue that prevented SQL Compliance Manager from discovering and auditing new users added to the list of Trusted Users / Privileged Users within a domain group without manually updating the audit settings.
- Exported audit settings now include database level privileged users.