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. |
Introduces custom inventory fields
SQL Inventory Manager allows users to create custom inventory fields that you can attach to servers, instances, and databases in your environment. Server inventory fields appear in the Computer Details window while database inventory fields appear in the Database Details window. Instance inventory fields appear in the Instance Summary panel of the Instance Details view. For more information about using these fields, see How to manage custom inventory fields.
Displays a list of applications connecting to your instances
During monitoring of each SQL Server instance, SQL Inventory Manager periodically samples the applications connecting to the instance and displays this list in the Instance Details view. For more information about managing the Applications list, see Manage instance applications.
Supports user role-based security
As a result of the integration with the IDERA Dashboard, SQL Inventory Manager now supports user roles for additional security. These accounts can be Administrator, User, or Guest (read-only) account types, each with a specific set of abilities and permissions. As an administrator, you can limit user access to instances through tags or individual instances in the SQL Inventory Manager Administration tab. For more information about managing user accounts, see Managing users in the IDERA Dashboard.
| Warning |
|---|
Accounts that upgrade from a previous version of SQL Inventory Manager are granted the Administrator role in SQL Inventory Manager 2.0 and later. This user role includes all permissions. |
Allows you to decommission instances and databases
SQL Inventory Manager users now can mark instances and databases as "decommissioned" within the product, thereby preventing erroneous alerting yet retaining the data for historical purposes. Decommissioned items are not monitored, do not trigger alerts or recommendations, and do not count against your SQL Inventory Manager license. The data stored before an item is decommissioned remains in the repository database, but is not included in any views or totals except for the Decommissioned tab in the Instances view. For more information about decommissioning an instance, see Decommissioned instances. For more information about decommissioning a database, see Information available on Instance Details.
Includes improved searching and filtering of instances and databases
Finding a specific instance or database is easy with the new search field in the SQL Inventory Manager menu bar. Simply type all or part of an instance or database within the product, and then click Go. SQL Inventory Manager displays a list of items matching your search criteria. For more information on using the search feature, see Searching SQL Inventory Manager.
Creating a useful filter to "weed out" unnecessary information takes time but is important when managing large environments. As a result, you may want to save that filter for future use. SQL Inventory Manager now allows you to save filters for use in the Explorer and Instances views. Simply create the filter, and then click Save as Explorer favorite or click Save as Instances favorite, depending on which view you are in when creating the filter. To use that filter, click Load Explorer favorite or click Load Instances favorite. For more information about saving filters on the Explorer view, see Exploring your instances. for more information about saving filters on the Instances view, see the appropriate tab under the Viewing all instances topic.
Supports Amazon Web Services and Azure hosted servers
SQL Inventory Manager 2.0 and later support instances hosted on Amazon Web Services or Azure with the following exceptions:
- WMI calls do not work with these instances.Therefore, SQL Inventory Manager does not display the WMI health check for cloud instances.
- SQL Inventory Manager does not discover instances hosted on AWS or Azure. You must manually add these instances.
Moved to the Windows .NET 4.5 framework
SQL Inventory Manager 2.0 and later support Microsoft Windows operating systems using .NET 4.5. For more information about requirements, see Software requirements.
Added integration with the IDERA Dashboard
SQL Inventory Manager 2.0 and later integrate with the IDERA Dashboard, a common platform designed to support the IDERA product suite. Users are able to obtain an overview of the status of their SQL Servers and hosted databases all in a consolidated view and navigate to individual product dashboards for details. The IDERA Dashboard provides a central set of services for managing users, instances, and IDERA products. For more information about the IDERA Dashboard, see Navigate the IDERA Dashboard web console.
Improved server discovery
- New SQL Server instances are discovered quickly using the improved server discovery methods included in this release. SQL Inventory Manager can continuously search your network to find new SQL Server instances, which then are available for viewing through the Instances view. Now, the Managed and Discovered views also include a Discovery Methods column that displays how the instance was discovered by SQL Inventory Manager. Imported instances display Imported in this column. For more information about managing discovery options, see How to manage discovery options.
- SQL Inventory Manager allows you to specify alternate credentials to use during the discovery process in case the original credentials are not valid. Manage Discovery Credentials lets you enter multiple discovery credentials and specify the order in which you want SQL Inventory Manager to attempt to use when connecting to a server.For more information about managing discovery credentials, see How to manage discovery credentials.
- A new Discovery Status window displays a log of all the actions and events involved in discovering instances within your environment. For more information about using this window, see Viewing discovery status.
Expansion of tagging functionality to include databases
Tags help you group or organize instances for better management. For example, add the tag "2012 Servers" to all the registered SQL Server instances that fit the description, and you can quickly access and view details from this group of instances with one click. SQL Inventory Manager 2.0 and later allow you to include databases in your tags to help you group and manage similar databases distinctly from the instances upon which they reside. A single tag can contain both instances and databases, and instances and databases can be tagged by multiple different tags or none at all. For more information about tagging, see Managing Tags.
Need more help? Search the IDERA Customer Support Portal.
...
2.6.5 New Features
Support for SQL Server 2022
- IDERA SQL Inventory Manager and SIM Repository now support SQL Server 2022.
Idera Dashboard upgrade
- IDERA SQL Inventory Manager now comes bundled with IDERA Dashboard 4.8.1.
2.6.4 New Features
Search box
- The Search box can now search by Tag.
2.6.3 New Features
There are no New Features for IDERA SQL Inventory Manager 2.6.3.
2.6.2 New Features
There are no New Features for IDERA SQL Inventory Manager 2.6.2.
2.6.1 New Features
There are no New Features for IDERA SQL Inventory Manager 2.6.1.
2.6 New Features
Cloud discovery
- IDERA SQL Inventory Manager 2.6 now allows you to discover cloud instances whether on Azure VM, Amazon EC2, Azure Database or Amazon RDS.
Advanced filters
- Users can create advanced filters on Instances views.
Exclude drives from Volume at Risk threshold
- Users can now exclude drives from alerts on the Volume at Risk health check.
Support For SQL Server 2019
- IDERA SQL Inventory Manager 2.6 now supports SQL Server 2019 for monitored instances.
2.6.5 Fixed Issues
- Databases under the DB on Availability Group by Database view are now showing as expected.
- Fixed bug related to the automatic update of the SQL Server build list.
- Passwords stored in SQLInventoryManagerService and SQLInventoryManagerCollectorService log files are now correctly encrypted.
- Fixed bug related to the grooming process.
2.6.4 Fixed Issues
- The response time for the Login, Explorer, and Instance tabs is improved.
- The Log4J library was updated to version 2.17.1 for SIM and also for CWF 4.8, which ships with SIM 2.6.4.
- When the user is uninstalling SIM, the application name displays correctly.
- When running the IderaReportUtility.exe, the User Account Control wizard shows IDERA as the publisher.
- The Server details for Linux Azure VM are now visible on the Instance Details grid.
- You can properly edit in Domain when using the Discovery Center option in the Administration tab.
- The Explore and Instances tabs now work correctly while selecting Filters.
- SIM 2.6.4 now uses CWF 4.8.
- Apache Tomcat is upgraded to version 9.
- The JDK version has been upgraded to AdoptOpenJDK version 8.0.
- The SQL Inventory Manager redirect links now work properly.
- The Idera SIM certificate and the user-defined self-signed certificate now work correctly after a service restart. This feature now also supports HTTP2 enabled browsers.
2.6.3 Fixed Issues
- The IDERA Dashboard no longer generates AD warnings for authentication failures, therefore, the CWF Service account does not lock anymore.
- When a server alias is registered with a name matching another actual physical server’s name, both servers are properly registered and functional.
- The Server details screen displays the data properly for Clustered instances.
- Alert messages are generated correctly when selecting non supported drives for instances.
- Case-sensitive instances are getting connected properly.
2.6.2 Fixed Issues
- User Account Control window displays SQLInventoryManager properly when installing SIM 2.6.2.
- SIM 2.6.2 adds any unreachable instance correctly, and displays the proper informational message.
- User Account Control window displays IDERA as the SQL Inventory Manager publisher.
- SIM 2.6.2 registers successfully SQL Server instances, and cloud instances with SQL credentials only.
- SIM 2.6.2 gets registered successfully, and all the navigation screens work properly after being installed to CWF 4.6.0.40 with FIPS compliant for hashing, and signing, enabled.
- The Web Application logs do not show the password details in plain text anymore.
- SIM 2.6.2 discovers SQL Instances hosted in other domains properly.
- The SQL Server is Down alert is properly described in Manage Health Checks.
- In the Explorer view, the data now displays correctly, ordered by size, sorted in descending order, and with proper values till two decimal places.
- The Instance is Down email alerts work as expected after upgrading SIM.
- The Repository is installed/upgraded correctly, even when the database name is changed from the default settings.
- After entering the vCenter information in the Manage VM Configuration , the settings for VM configuration are saved and work properly.
- When reports to SSRS are deployed, these reports share data source configured with appropriate value and custom data source as empty.
- SIM 2.6.2 is successfully installed on Windows Server 2012 with SQL Server 2014 Standard.
- Databases on the secondary node of an Availability Group do not raise Databases Without a Backup health checks anymore.
- Dropped databases do not show up in the Databases list displayed under the Instance Details page.
- Custom field value from the Instance Summary view, now fully displays.
- The comments added to the Database Details screen for a monitored database are properly displayed when the p_InsertUpdateDatabase stored procedure runs as part of a data refresh.
- The Data Space at Risk alert works properly when Autogrowth is either disabled, enabled with limited file size, and enabled with unlimited file size.
2.6.1 Fixed Issues
SIM Charge Back Reports now runs properly.
When the user is modified, SQL Inventory Manager 2.6.1 restarts collector Service after completing the save operation.
SQL Inventory Manager 2.6.1 displays correct time stamp for database backups (full, differential, and log) in database details.
Users can set a range for ports input in Manage Discovery options.
SQL Inventory Manager 2.6.1 displays the appropriate core factor for each SQL Server version under SQL Licensing by Instances view.
Users can add a New Virtualization Host Servers in the Manage VM Configuration window.
E-mail shows alert with Alert Level, Instance Name, and the explanation of the alert.
All passwords are encrypted when stored and when transmitted.
The Administrator tab visibility is now invisible for Product User.
SQL Inventory Manager 2.6.1 disables the Display Name text field while upgrading SIM.
The Explorer tab displays only the tags associated with instances under Instance Tags section, and tags associated with databases under Database Tags section.
The Dashboard > Administration Tab > Manage Tags window shows all the tags to edit or view their properties correctly.
Loading and refreshing pages run faster than older versions.
- SQL Inventory Manager 2.6.1 imports instances configured with custom instance tags that already exist, without duplication issues.
User Account configured for monitoring and discovering instances from a different domain, now authenticates properly on the server hosting SIM.
The console does not display dropped databases, and they are not shown Online.
SQL Inventory Manager 2.6.1 performs Health Checks for databases on secondary nodes of Availability Groups properly.
The SSIS version displays correctly.
The User Account Control window displays IDERA as the SQL Inventory Manager 2.6.1 Verified Publisher in the installation folder.
After installing SQL Inventory Manager 2.6.1 using the default ports, the launch page now links to the correct URL.
2.6 Fixed Issues
- IDERA SQL Inventory Manager locks the service account.
- SQL Inventory Manager 2.6 sends automatic email alerts properly.
...