Page History

...

To view all the managed instances on host, click on next to the host name. The following information is available for instances: Instance Name, SQL Server Version, Edition, #Of DB, Owner, Location, and Tags.

Available individual instance actions

When you select one instance, you can perform any of the following actions on the actions items bar:

• View Details
• Edit Instance Properties
• Edit Tags
• Export
• Refresh Data
• Decommission
• Remove
• Add SQL Server Instance

Viewing instance details

You can access an instance details view by selecting the instance and clicking View Details on the action items bar. For more information about what information is available on the instance details view, refer to Viewing instance details. 

Refresh Data

If you want to refresh the collected data for an instance, select the instance and click   Refresh Data on the action items bar.  You can only perform this action for one instance at a time. 

Edit instance properties

Select an instance and click Edit Properties on the action items bar. On the properties dialog window you can change the owner, location, comments, and credentials. For more information go to Editing instances properties.

Edit Tags

By selecting an instance and clicking Edit Tags on the action items bar, SQL Inventory Manager opens a new dialog window where you can add new tags or change the currently assigned tags of the selected instance. For more information about editing tags for a specific instance, go to Manage tags for a single instance.

More Actions

Click the More Actions button  on the action items bar to find additional options: Decommission, Remove, and Add SQL Server instance.

Decommission

Using More Actions, select an instance and click Decommission on the action items bar to stop monitoring and alerting on that instance. For more information about decommissioning an instance or database, see Decommissioned instances.

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

Exporting Instances view information

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.

...