Page History
...
You can click the headers of these columns to order your information; for example, click # of DBs to order all your instances according to the number of databases.
Info |
---|
SQL Inventory Manager now supports Azure DB (Single, Managed Instances, and Elastic Pool) and Amazon RDS as monitored databases. |
Instance status
Next to the instance name, you can find the following icons that represent the instance status:
...
- View Details
- Refresh Data
- Edit Instance Properties
- Edit Tags
- Export
- Decommission
- Disable Monitoring
- Remove
- Add SQL Server Instance
- Edit MS SQL License Info
- Apply advanced filters
- Clear filters
Viewing instance details
...
Click the More Actions button Decommission, Disable Monitoring, Remove, and Add SQL Server instance.
on the action items bar to find additional options:Decommission
Using More Actions, select an instance and click Decommission on the action items bar to stop monitoring and alerting on that instance. You can also find this option by clicking the gear icon next to the respective instance. For more information about decommissioning an instance or database, see Decommissioned instances.
Disable Monitoring
If you want to disable the monitoring of an instance, select the instance, go to More Actions, and select Disable Monitoring. You can also find this option by clicking the gear icon next to the respective instance. For more information about disabling instances, click here.
Remove instance
If you no longer want to manage an instance, you can remove it by selecting the respective instance, going to More Actions on the action items bar, and selecting Remove. You can also find this option by clicking the gear icon next to the instance. SQL Inventory Manager displays all removed instances on the Ignored instances view. For more information about removing instances click here.
Add SQL Server instance
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
...
- Click the option you want to perform on the action items bar: Refresh Data, Edit Owner, Edit Location, Edit Credentials, Edit Tags, Export, and More Actions including Decommission, Enable/Disable Monitoring, Remove, and Add SQL Server Instance. You can also apply Advanced Filters or Clear Filters.
- Or click the gear icon next to one of the selected instances. SQL Inventory Manager opens a dialog window that shows you on how many instances you are performing the changes.
...
On the action items bar of the Managed Instances 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.
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 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.
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
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. | ||
Info | ||
| ||
You can also access the Managed instances section by clicking Instances on the right sidebar of the overview. For more information, go to Viewing information on the SQL Inventory Manager Overview. |