Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note

The Managed by Host Server view only shows the highest SQL Server version and edition for all the SQL instances registered and linked to the host. If a host server has additional SQL Server instances with higher version and edition that have not been registered to SQL Inventory Manager, then the higher version and edition will not be displayed on the Server/Host Server view.

To access the Managed by Host Server view To access the SQL Inventory Manager  go to the Instances tab and select Managed by Host Server from the View By drop down menu.  This view provides a hierarchical structure  of the instances and host servers managed by SQL Inventory Manager together together with relevant information about their characteristics. This view contains three different levels of information: host servers, virtual host servers, and instances.

...

If you want to access the Add SQL Server instance wizard, go to More actions and select this option. The wizard opens and allows you to browse and register SQL Server instances.

Advanced Filter

Apply advanced filters to your instances view, for more information refer to Filtering and Sorting.

Clear Filters

Clears any applied advanced filters.

Available bulk actions for multiple instances

...

On the action items bar of the Managed Instances view, you can find the Export option Image Added which allows you to choose your preferred format for exporting the information available on this view. You can export as a PDFXLS, or XML file. The filters you choose on this view will be taken into account for your exported reports.

Available filtering options

On the left side of the Instances view,  you have options for filtering the instances that you want SQL Inventory Manager to display on your managed instances view. You can filter these instances by Tags, Owner, Location, and Version. These options will help you get a quick view of your required instances; for example, if you want to see your managed instances filtered by a specific Owner, just choose the respective option from the Owner filter.

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.

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

Filtering and Sorting

SQL Inventory Manager offers different ways of sorting and filtering the listed instances/servers, for further information refer to Filtering and Sorting.Image Removed

Tip
titleTip
IDERA SQL Inventory Manager displays the filters you select on the top section of your managed instances view under Filtered by. You can remove filters from this section too.

...