Page History
| Note | ||
|---|---|---|
| ||
Because of the addition of roles, all user accounts in a previous version of the product versions 2.2 and previous are added to the IDERA Dashboard but are not assigned a role and cannot access IDERA SQL Inventory Manager until the administrator changes the account permissions. Note that the administrator is the account specified during the IDERA Dashboard installation. To change user account permissions, go to IDERA Dashboard > Administration > Manage Users. Edit a user account. Select the IDERA SQL Inventory Manager product, and then assign a role of Product Administrator, Product User, or Product Guest. Click Save, and then repeat these steps for each user account. Now grant the user accounts access to the instances in your environment. Go to SQL Inventory Manager > Administration > Manage Users. Click the link for the name of the user account. In the Access to SQL Server Instances section of the Edit Users window, select whether you want to grant the user account access to all instances or a selection of instances. If you want to grant access to only selected instances, choose those instances using wither either the tag or instance name. Click Save. For more information about user accounts and roles, see Managing users in the IDERA Dashboard. |
2.
...
4 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 Fixed issues
...
Reporting
SQL Inventory Manager provides customized SSRS reports that provide various information from inventory, health check to SQL licensing and chargeback.
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.
Less privileges required for discovery
Discovery scans require less elevated privileges.
Improved performance
Improved performance and scalibility.
2.4 Fixed issues
The Decommissioned Instances view lists # of DBs and Size of DBs (MB) for decommissioned instances.Anchor SQLEMEN-14053 SQLEMEN-14053
The Server Details view shows volume names for mount points.Anchor SQELEM-14105 SQELEM-14105
Fixed utilization at 100% due to SQLInventoryManagerCollectorService .Anchor SQLELEM-14130 SQLELEM-14130
Users can not download build list behind a proxy.Anchor SQLELEM-14284 SQLELEM-14284
Using SQL Server Alias Reporting 2 default Instances.Anchor SQLEMEM-14396 SQLEMEM-14396
...
| Excerpt |
|---|
IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |