Page History

IDERA SQL Inventory Manager continuously searches your network to find new SQL Server instances. To see newly - discovered instances, go to the to the Discovered option  view on the the Instances tab tab. IDERA SQL Inventory Manager shows you a list of those instances not yet monitored in your environment yet. From this view you can add , or ignore instances, access the auto registration options, launch the discovery job, and export reports.

Available actions

Auto Registration Options

.

Actions available on the Discovered instances view

Ignoring instances

You can choose to ignore any of these discovered instances. For this purpose, mark the checkbox next to the instance you want to ignore, and click Ignore on the action items bar.

IDERA SQL Inventory Manager no longer shows the ignored instances on the Discovered view but adds them to the Ignored view.

Auto registration options

Use these options to automatically register SQL Server instances as they are discovered. On this dialog window you can choose Use this option to enable the automatic registration of newly-discovered SQL Server instances. By clicking this option, IDERA SQL Inventory Manager opens a dialog window that allows you to specify which SQL Server editions you want to exclude from auto registration.

Auto registration only applies to newly-discovered instances and does not affect instances discovered before the option is enabled. IDERA SQL Inventory Manager does not register more instances than you have available licenses.

Discover instances

...

Use this option to start the discovering database instances job. Options allow you to select whether you want to include a browser scan and/or ODBC scan. Note a job to discover instances. Take into account that this process may take a long some time to complete. When you select to discover instances, IDERA SQL Inventory Manager displays two options:

• 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.

Adding instances

If you want to monitor register some of these instances, click select the respective checkboxes next to of the instances you want to add, and then click click Add SQL Server Instance Instance on the actions action items bar options.

IDERA SQL Inventory Manager opens the wizard for adding new SQL Server instances, and automatically adds the names of the instances you selected before. For  For more information on how to register SQL Server instances, go toto Adding SQL Server instances.

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 the Export option option, located on the on the action items bar, and select your preferred format (PDF, XLS or , or XML) for exporting.

Ignoring instances

The Ignore option appears in the action items bar once you select one or more instances in the list. You can choose to ignore any of the discovered instances. Select the instance(s) you want to ignore, and then click Ignore located on the action items bar of this window.

IDERA SQL Inventory Manager no longer shows the ignored instances on the Discovered view but adds them to the Ignored view.

Image Removed

Available filters

On the left side of the Discovered Instances view, you have a number of filtering options.

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 Minor Version 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 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.

Enable or disable the option Apply filter as it changes depending Click the down arrow to expand your options, and then check the box(es) you want to use as a filter. Use Apply filter as it changes if you want to see the list changes based on your selected criteria.

Other available filtering options include:

• Load Instances favorite. Use a saved "favorite" filter set to view the Discovered Instances list.
• Save as Instances favorite. Save the current filter set as a "favorite" to use again.

as you apply the filters, or if you prefer to select your filters first and see the results when you finish.

Image Added 

...

Manage your discovery options

If you want to configure the discovery job, go to the Administration tab and click click Manage Discovery Center Options on  on the Discovery section. For more information about configuring discovery options, see How to manage Discovery Center options. On this dialog window you can specify not only those IP address ranges and domains where you want IDERA SQL Inventory Manager to perform the discovery job, but also you can choose which methods you want to use to search in each computer. You can schedule your discovery jobs, add IP address ranges and those domains that IDERA SQL Inventory Manager will use in discovery.

For more information on how to configure your manage discovery options, click here.