Below is a list of features added and fixed issues in previous versions.

2.4 Previous new features

Reporting

SQL Inventory Manager provides customized SSRS reports that provide various information from inventory, health check to SQL licensing and chargeback. For more information refer to IDERA Reports Utility and Custom Reports

Deploy on an Availability Group

Install and failover on an Availability Group and secondary node.

List users and privileges

View a list of users and security profiles for a database or instance. For more information refer to Viewing Security Profiles

Less privileges required for discovery

Discovery scans require less elevated privileges. For more information refer to Permissions and Discovery

Improved performance

Improved performance and scalibility.


2.4 Previous fixed issues


  • The Decommissioned Instances view lists # of DBs and Size of DBs (MB) for decommissioned instances.
  • The Server Details view shows volume names for mount points.
  • Fixed utilization at 100% due to SQLInventoryManagerCollectorService .
  • Users can not download build list behind a proxy.
  • Using SQL Server Alias Reporting 2 default Instances.


2.3 Previous new features

Includes new patch list view

The new IDERA SQL Inventory Manager Patches view helps you manage SQL Server patches and keep your environment properly patched. The Patches view displays a list of your managed SQL Server instances including whether they are running a supported version of SQL Server. In addition, you can get information about the patches running on your SQL Server and whether additional hotfixes are available for your SQL Server level. For more information about the patches list view, see Reviewing SQL Server patches.

Supports the SQL Server AlwaysOn Availability Groups feature

IDERA SQL Inventory Manager 2.3 now allows DBAs to monitor their availability databases, nodes, and listeners through AlwaysOn Availability Clusters in SQL Server 2012 and newer. AlwaysOn automatically switches auditing from the primary to the secondary replica in the event of failure as well as failback to primary when it comes back online. This advantage prevents a loss of the audit data trail in the event of failure. IDERA SQL Inventory Manager allows you to view this information in the Explorer view.

For additional information about IDERA SQL Inventory Manager and the AlwaysOn Availability Groups feature, see Exploring your instances.

Introduces configurable health checks

New configurable health checks allow you to customize certain health checks to better suit your environment. These configurable checks include:

Enhanced Discovery

Enhancing the SQL Server instance discovery features is an important aspect of IDERA SQL Inventory Manager. These updates include:

  • New BI and reporting service discovery shows users where BI services are running in their environment, helping you keep track of the infrastructure external to the database servers themselves that they may need to bring under management.
  • Discovery at the organizational unit (OU) level allows you to specify narrower slices of your domain for discovery, which is valuable in large,complex, or highly secured environments where broader discovery may cause issues.
  • Exclude filters on domains allow you to prevent IDERA SQL Inventory Manager from running discovery on domains which are known not to be relevant or appropriate for discovery scans.

Improved IDERA SQL Inventory Manager user interface

IDERA SQL Inventory Manager features a new look and feel. Some changes include:

  • Colors. New colors reflect updated IDERA branding rolled out across all IDERA products
  • Navigation. The primary navigation moves away from product-specific tabs to a dropdown selection in the header adjacent to the IDERA logo. If you have multiple IDERA products installed in your environment, be sure to select the appropriate product before using any features.
  • Administration menu. Common tasks previously accessed only on the Administration tab now are available from a new Administration menu on the right side of the menu bar.

Increased functionality offered in IDERA Dashboard

IDERA Dashboard functionality and offerings are expanded. IDERA Dashboard now includes:

  • Global tags. Using IDERA Dashboard 3.0.x or later, users can create global tags that are available across all IDERA products using IDERA Dashboard. Local or product-specific tags still are available but cannot be used outside of their parent product. For more information about tags within IDERA SQL Inventory Manager, see Managing tags.
  • Increased instance management. The IDERA Dashboard tracks instances discovered and managed by individual IDERA product. For more information about instances within IDERA SQL Inventory Manager, see Managing instances.

2.3 Previous fixed issues

  • IDERA SQL Inventory Manager 2.3 includes code improvements that resolve a Java heap space error experienced by some users upgrading from previous versions of IDERA SQL Inventory Manager.
  • Users who upgrade from a previous version of IDERA SQL Inventory Manager (previously named SQL Elements) no longer see a ServiceUser account with MONITORING GROUP type in the database. This was a legacy account that now is deleted.
  • IDERA SQL Inventory Manager now allows users to log in using integrated security through their Windows login credentials.
  • Users now can successfully log in with user names containing special characters as well as use special characters when updating the name or location of their SQL Server instances.
  • Resolves an issue that caused IDERA SQL Inventory Manager to run scans on domains other than those selected.



SQL Inventory Manager Discover and visualize your SQL Server environment.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels