Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

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

  • 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

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

Click the More Actions button   on the action items bar to find additional options: Decommission, Disable Monitoring, 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. 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

Edit bulk properties

You can select several instances and change:

...

Take into account that Enable Monitoring will only be available if you have disabled 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 PDFXLS, or XML file. The filters you choose on this view will be taken into account for your exported reports.

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



Scroll Ignore

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse