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.

...

Instance status

Next to the instance name, you can find the following icons that represent the instance status:

Image ModifiedInstance

...

up Image ModifiedInstance

...

down Image ModifiedDisabled

...

instance Image ModifiedInstance not

...

available Image ModifiedAuthentication

...

failure Image ModifiedSlow

...

...

Tip

You can set the number of instances you want SQL Inventory Manager to show per page. Go to

...

the Display

...

 option at the bottom of the page, type the number you require, and then

...

click Refresh.

Available individual instance actions

...

• View Details
• Refresh Data
• Edit Instance Properties
• Edit Tags
• Export
• Decommission
• Disable Monitoring
• Remove
• Add SQL Server Instance
• Edit MS SQL License Info

Image Removed Image Added

Viewing instance details

You can access an instance details view by selecting the instance and clicking View Details on  on the action items bar or by clicking directly on the instance name. 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 click  Image Added Refresh Data on the action items bar. You can also find this option by clicking the gear icon next to the respective instance. You can only perform this action for one instance at a time. 

...

Select an instance and click Edit Properties on the action items bar. You can also find this option by clicking the gear icon next to the respective instance. 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. 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.

More Actions

Under Click the More Actions you can  button Image Added on the action items bar to find additional options: Decommission, Disable Monitoring, Remove, and Add SQL Server instance.

Decommission

Using Using More Actions, select an instance and click click Decommission on  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 see Decommissioned instances.

...

If you want to disable the monitoring of an instance, select the instance, go to More Actions, and select Disable Monitoring.  You  You can also find this option by clicking the gear icon next to the respective instance. For  For more information about disabling instances, click 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. 

...

You can also perform the following actions under the More Actions option:

• Decommission
• Disable monitoring
• Enable monitoring
• Remove 
• Add SQL Server 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 and More Actions including  including Decommission,    Enable/Disable Monitoring, Remove, and and Add SQL Server Instance.
• 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.

Image Removed Image Added

...

Take into account

...

that Enable Monitoring

...

 will only be available if you have disabled instances.

Exporting Instances view information

...

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

Image Modified

...