SQL Sentry Inventory View

Introduction

The Inventory view allows you to see the watched status of any target within your environment. Access the Inventory view by double-clicking the Inventory node in the Navigator pane (Navigator > Configuration > Inventory).

Select Inventory in the Navigator pane

In the Inventory view, you can drag the column header to the top to group by that column. Other options are available in the context menu for the column headers for grouping, sorting, filtering etc.

Inventory View Sort Ascending context menu option

Note:  Once applied, the filter is shown at the bottom of the pane.

SQL Sentry Inventory View Watch status

Available Columns

ColumnDescription
SiteThe management site is maintained through the Site Configuration screen, or through the Navigator pane drag and drop functionality. Sites represent a logical grouping of targets, instances, and monitoring services within your SQL Sentry environment.
Monitoring ServiceA specific SQL Sentry monitoring service by machine name.
NameThe name of a specific target.
Type

Targets may be: 

  • SQL Server 
  • Analysis services 
  • Windows APS appliance
  • VMware Hosts
  • AWS RDS
  • Azure SQL DB  
  • SQL DW
  • Hyper-V Hosts
Watched
  • The flags indicate whether the target is currently being watched by SQL Sentry. 
  • A check mark indicates that the target is currently being watched. 
Inventory View Watched instance
Watched instance example
  • An empty check box indicates that the target is not being watched.
Inventory View Unwatched instance
Unwatched instance example

Note:  This is a read-only view of the targets. See the Stop Watching Targets article for information on how to stop monitoring a target.

Idea: 

Use the Inventory view to quickly see how the licenses within your environment are distributed.