Page History

This view displays a hierarchical view for all the physical or virtual host servers with instances registered on SQL Inventory Manager. The following information is available for host servers: Physical Server name, Type, O/S, Model, CPU Name,  # Of Sockets, #Of Logical Processors, #Of Cores,  Disk Capacity, Free Space, and  whether they are clustered or not. 

You can click the headers of these columns to order your information; for example, click # Of Sockets to order all your instances according to the number of sockets.

Instance status

...

The IDERA SQL Inventory Manager list of managed instances displays all your environment's registered instances together with their status, SQL Server versions, editions, number and size of their databases, owners, locations and whether the instances are clustered. 

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 RemovedInstance up Image RemovedInstance down Image RemovedDisabled instance Image RemovedInstance not available Image RemovedAuthentication failure Image RemovedSlow

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

Available individual instance actions

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

• View DetailsRefresh Data
• Edit Instance Properties
• Edit Tags
• Export
• Refresh Data
• DecommissionDisable Monitoring
• Remove
• Add SQL Server InstanceEdit MS SQL License Info
  
  

Viewing instance details

...

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. 

Available bulk actions for multiple instances

Edit bulk properties

You can select several instances and change:

• Owner
• Location
• Credentials
• Tags

For example, if you have a new DBA, you can select all instances on this tab and click Edit Owner to change all instances owner at once.

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

...

SQL Server

...

To bulk edit several instances, select the instances you want to change and follow any of these paths:

...

.

...

 Image RemovedTake into account that Enable Monitoring will only be available if you have disabled instances.

Exporting Instances view information

...