Page History
...
- View details
- Refresh data
- Edit instance properties (Owner, Location, Comments and Credentials)
- Edit Tags
- Export
- More actions: Decommission, Disable Monitoring, Remove, Add SQL Server instance, Core Factor Table, and Edit MS SQL license info.
- Advanced Filters
- Clear Filters
Tip |
---|
You can also access most of these options from the gear icon next to the selected instance. To access the instance details view, you can click directly on the instance name. |
...
By selecting an instance and clicking Edit Tags on the action items bar, IDERA SQL Inventory Manager opens a new dialog window where you can add new tags or change the currently assigned tags of the selected instance. You can also find this option by clicking the gear icon next to the respective instance. For more information about editing tags for a specific instance, go to Manage tags for a single instance.
Export
You can The export option allows you to export the information displayed in this view as a PDF, XLS, or XML format.
...
For example, if you have a new DBA, you can select all instances on this tab and click Edit Owner to change all instances owner at once.
Advanced Filter
Apply advanced filters to your instances view, for more information refer to Filtering and Sorting.
Clear Filters
Clears any applied advanced filters.
Options available for multiple instances
...
On the action items bar of the SQL Licensing view, you can find the Export option which allows you to choose your preferred format for exporting the information available on this view. You can export as a PDF, XLS, or XML file. The filters you choose on this view will be taken into account for your exported reports.
Filtering on the SQL Licensing view
On the left section of this view you can find options for filtering your instances by Tags, Owner, Location, and 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 licensing information of 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 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.
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
Filtering and Sorting
SQL Inventory Manager offers different ways of sorting and filtering the listed instances/servers, for further information refer to Filtering and SortingYou 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 | ||
---|---|---|
| ||
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. |
...