Page History
...
Warning |
---|
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.
...
4 New
...
features
Warning |
---|
IDERA SQL Compliance Manager 5. |
...
4 depends on certain Microsoft components that did not ship with SQL Server versions prior to SQL Server 2012 SP1. If you are installing SQL Compliance Manager's Collection Service on a Repository running on SQL Server 2012 or below, you must install these components manually. For more information about |
...
this process, see |
...
...
4. |
...
There are no fixed issues in this release.
5.3 New features
...
Improves archiving through the availability of SQL Server Extended Events
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 alerts, allowing a user to set up an alert 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
...
Installation
...
Licensing
...
Services
...
4 includes support for event handling with SQL Server Extended Events. This optional feature is available for use in auditing instead of using SQL Trace. Running Extended Events offers a performance improvement over the default SQL Trace audit event gathering system and is available for instances running SQL Server 2012 and later. For more information about using the Extended Events option, see Using SQL Server Extended Events.
Allows Administrators to provide easy user access
This release includes an improved Web console that allows Administrator to give users access to IDERA SQL Compliance Manager through the browser rather than having to manually install the Windows console on each user's computer. For more information about this feature, see .
Includes new Sensitive Column Search
Included in this release is integration with a free tool from IDERA called SQL Column Search. Available from the IDERA SQL Compliance Manager Instance Details view, this feature allows you to search tables and columns on a targeted database to discover the location of sensitive data needing to be audited. For more information about using the Sensitive Column Search, see Sensitive Column Search window.
Offers SQL Compliance Manager Windows Console functionality in the Web Console
The following features previously available only through the IDERA SQL Compliance Manager Windows Console now are available in the Web Console as well:
- Importing sensitive columns
- Importing audit settings including instance and database templates
- Exporting audit settings including instance and database templates
Includes updated regulatory guideline templates
IDERA SQL Compliance Manager includes a number of regulatory guideline templates for customer use. IDERA SQL Compliance Manager 5.4 includes updates for these templates. For more information about this feature, see Comply with specific regulations.
5.4 Fixed issues
Installation and upgrade issues
Enabled Capture Transaction Status for DML Activity no longer replaces SQL statement values with variables.Anchor SQLCM-2163 SQLCM-2163
This release resolves an issue that prevented auditing when two tables has the same name but different schemaAnchor SQLCM-2171 SQLCM-2171
An error no longer occurs while updating the audit configuration file due to duplicate database IDs.Anchor SQLCM-2174 SQLCM-2174
Improves Collection Server performance while processing trace files.Anchor SQLCM-2175 SQLCM-2175
Corrects an issue preventing the Collection Trace directory from being created when the user chooses a non-default installation path.Anchor SQLCM-2351 SQLCM-2351
IDERA SQL Compliance Manager 5.3 now supports SQLcomplianceAgent silent installation.Anchor SQLCM-3211 SQLCM-3211
Resolves an issue causing heartbeat alerts for instances after they are archived.Anchor SQLCM-3332 SQLCM-3332
Resolves an error that appeared when a user added privileged users while applying a custom Audit Collection Level.Anchor SQLCM-3637 SQLCM-3637
Fixed an error causing the collection of non-audited database data when Capture SQL statements for DML and SELECT activity is enabled.Anchor SQLCM-3638 SQLCM-3638
Before-After data now works during an update when auditing selected columns.Anchor SQLCM-3639 SQLCM-3639
Non-AlwaysOn Availability Group databases can no longer be added to an AG server for auditing.Anchor SQLCM-3640 SQLCM-3640
Resolves an issue causing an invalid object name error with 'sys.dm_os_window_info' for SQL Server 2005 agents.Anchor SQLCM-4496 SQLCM-4496
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal
Auditing
...
Excerpt |
---|
SQL Compliance Manager audits all activity on your server. Learn more > > |