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.7.1 New Features
Supports SQL Server 2019
IDERA SQL Compliance Manager 5.7 now supports installation of the Database Repository for Collection Server, deployment of the SQL Compliance Manager Agent, and auditing events for SQL Server 2019. For more information, see Software requirements.
Supports Windows Server 2019
The user can install IDERA SQL Compliance Manager 5.7 and deploy the SQL Compliance Manager Agent in Windows Server 2019. For more information, see Software requirements.
SQL Compliance Manager version 5.7 includes the Server Activity Report which allows users to view the SQL Server activity at the enterprise and at the individual instance levels. With this report, users can quickly check activity in each event category audited, and view statistics of the SQL Server activity. For more information, see Server Activity Report Card.
SQL Compliance Manager version 5.7 includes the Privileged/Trusted Users Report for users to list the trusted and privileged user roles set per a specific Server or Database. Users can run this report on Privileged and Trusted users to know what these were set to during a snapshot in time. For more information, see Privileged and Trusted Users Report.
SQL Compliance Manager version 5.7 includes the Sensitive Column/BAD Users Report which lists Sensitive Columns and Before-After data audit settings applied to the servers and databases in your environment. Users can run this report on Sensitive Columns and BAD auditing to know what these were set to during a snapshot in time. For more information, see Sensitive Columns and BAD Report.
Limit Report Access to specific users
SQL Compliance Manager version 5.7 introduces the ability to restrict user access to certain SQL CM reports. As an administrator you can grant users permissions to specific reports. This way you can tightly control permissions settings for report access for every user in your environment. For more information, see Login properties - Report Access.
Report Filter improvements
SQL Compliance Manager version 5.7 brings updates and improvements to reports by making reports more consistent and adding new filters options, such as the ability to filter reports based on a specific schema, event type, login, or multiple logins at a time. Users can also use the time range filters to report on the exact high activity time-frames or to filter out low activity time-frames.
5.7 Fixed Issues
No new features in this version.
5.7.1 Fixed Issues
Resolved the issue where SQL Compliance Manager did not recognize a GMSA account as a Trusted users when adding the account as part of a group.
Anchor SQLCM-5989 SQLCM-5989
Resolved the issue which caused the cluster setup installation to perform a fresh installation instead of asking users to upgrade the agent service .
Anchor SQLCM-6058 SQLCM-6058
Resolved the issue where SQL Compliance Manager could not establish a connection with the AG databases on the Secondary nodes. SQL Compliance Manager automatically registers databases on the Secondary nodes.
Anchor SQLCM-6128 SQLCM-6128
Resolved the issue where configuring Sensitive Column auditing caused the SQLcompliance Agent to have problems creating the sp_SQLcompliance_Audit stored procedure.
Anchor SQLCM-6027 SQLCM-6027
Resolved the issue with the Daily Audit Activity Statistics Report which displayed an error message due to a missing component. The Daily Audit Activity Statistics Report runs successfully.
Anchor SQLCM-6057 SQLCM-6057
For more information about new features and fixed issues in versions 5.67.x, see Previous new features and fixed issues.