Versions Compared

Key

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

...

  • Add. Click this option to go to the respective wizard and add new SQL Server instances.
  • Export Image Added. You can choose any of the following formats: PDF, XLS, or XML for exporting the information displayed on the Decommissioned view.
  • Advanced Filter. Apply advanced filters.

  • Clear Filters. Clears any applied advanced filters.

Tip

You can type on the bottom section of this view the number of instances you want IDERA SQL Inventory Manager to display per page. Click Refresh to apply the changes.

...

If you want to access the Add SQL Server instance wizard, click Add SQL Server instance. 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.

Exporting from the Decommissioned view

On the action items bar of the Decommissioned view, you can find the Export option  Image Added option 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.

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

On the left section of this view you can find options for filtering your instances by Instance Tags, Owner, Location, Minor Version, and Major Version. Use these filters to quickly access specific instances that you want IDERA SQL Inventory Manager to display on this view. For example, you can choose to display the list of decommissioned instances that have a specific tag in your environment. 

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 favorite, depending on which view you are in when creating the filter. To use that filter, click Load 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.

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.

...