Page History

I

IDERA SQL Inventory Manager continuously searches your network to find new SQL Server instances. To see newly discovered instances, go to the Discovered view on the Instances tab. IDERA SQL Inventory Manager shows you a list of those instances not yet monitored in your environment. From this view you can add or ignore instances.

...

• Discover Instances Browser Service - lets you discover instances by using "System.Data.Sql.SqlDataSourceEnumerator" which enumerates all available SQL Server instances within the local network.
• Discover Instances Odbc - lets you discover instances using "odbc32.dll" which gets the instances list from the system's registry data.

...

Login to SQL Instance

Log into SQL Instances to collect additional information such as version and edition. For this, mark the checkbox next to the instance you want to log into and click Log Into Instances on the action items bar. In the Log in Dialog enter a valid User Name and Password for the selected SQL Instance. 

Export reports

If you want to export the information displayed on the Discovered Instances view, go to the Export option, located on the action items bar, and select your preferred format (PDF, XLS, or XML) for exporting.

Image Removed Image Added

Available options on the Discovered Instances view

On the left side of the Discovered Instances view you have the option for filtering instances by by Minor Version or  or Major Version. If you want to filter by specific versions, select them from this section.

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. IDERA SQL Inventory Manager now allows you to save filters for use in the Explorer and Instances views. Simply create the filter, and then click click Save as Explorer favorite or click  or click Save as Instances favorite, depending on which view you are in when creating the filter. To use that filter, click click Load Explorer favorite or click  or click Load Instances favorite.

Enable or disable the option option Apply filter as it changes depending  depending if you want to see the changes as you apply the filters, or if you prefer to select your filters first and see the results when you finish.

...