Page History
...
| Info |
|---|
Decommissioned instances do not count against your license. For more information about decommissioning, see Decommissioned instances. |
Available
...
options
On the SQL Licensing view there are two options available on the action items bar:
- Add SQL Server instances. Click this option to go to the respective wizard and add new SQL Server instances.
- Export. You can choose any of the following formats: PDF, XLS, or XML for exporting the information displayed on the SQL Licensing view.
| Tip |
|---|
You can type on the bottom section of this view the number of instances you want SQL Inventory Manager to display per page. Click Refresh to apply the changes. |
...
Options available when you select instances
...
On the SQL licensing view SQL Inventory Manager allows you to perform several actions on a single instance as well as bulk actions on several selected instances.
If you select one instance you can perform the following actions:
- View details
- Refresh data
- Edit instance properties (Owner, Location, Comments and Credentials)
- Edit Tags
- More actions: Decommission, Disable Monitoring, Remove, Add SQL Server instance.
| 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. |
Viewing instance details
You can access an instance details view by selecting the instance and clicking View Details 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 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.
Edit instance properties
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 More Actions you can find additional options: Decommission, Disable Monitoring, Remove, and Add SQL Server instance.
Decommission
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
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.
...
- Edit Owner
- Edit Location
- Edit Credentials
- Edit Tags
- More Actions (Decommission, Disable Monitoring, Enable Monitoring, Remove, Add SQL Server instances)
...
- Click the option you want to perform on the action items bar: Edit Owner, Edit Location, Edit Credentials, Edit Tags, Disable Monitoring, Decommission, and Remove.
- 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.
How do you export information available on
Exporting from the SQL Licensing view
...
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 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.
...
...