Queries Used in VMware Solution
The following queries are used in the VMware monitoring solution dashboard widgets to extract metrics or alarms related information from your vCenter:
| Widget | Description | Search Name in Log Explorer | Query |
|---|---|---|---|
| Data Center Clusters | Total number of vSphere clusters discovered in the selected vCenter scope. | VMWare Data Center Cluster Count | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Data Center' | stats latest('Cluster Count') as 'Data Center Clusters' |
| ESXi Hosts | Number of ESXi hosts currently being monitored. | VMWare Host Count | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Data Center' | stats latest('Host Count') as ESXiHosts |
| Virtual Machines | Total number of VMs that Log Analytics has discovered for this vCenter. | VMWare VM Count | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Data Center' | stats latest('Virtual Machine Count') as VMs |
| Data Stores | Number of data stores detected in the environment. | VMWare Data Store Count | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Data Center' | stats latest('Data Store Count') as 'Data Stores' |
| Networks | Number of networks (for example, port groups) discovered under vCenter. | VMWare Networks Count | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Data Center' | stats latest('Network Count') as Networks |
| Average Cluster CPU Usage | Average CPU usage across clusters for the selected time range. | Average VMWare Cluster CPU Usage | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Cluster' | stats avg('CPU Usage (%)') as 'Average CPU Usage', trend(avg('CPU Usage (%)'), 1hour) | compare timeshift = auto |
| Average VM CPU Usage | Average CPU usage across VMs in the selected time range. | Average VMWare VM CPU Usage | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere VM' | stats avg('CPU Usage (%)') as 'Average CPU Usage', trend(avg('CPU Usage (%)'), 1hour) | compare timeshift = auto |
| Average Cluster Memory Usage | Average memory usage across clusters for the selected time range. | Average VMWare Cluster Memory Usage | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Cluster' | stats avg('Memory Used (%)') as 'Average Memory Usage', trend(avg('Memory Used (%)'), 1hour) | compare timeshift = auto |
| Average Storage Usage | Average data store/storage usage across the environment for the selected time range. | Average VMWare Storage Usage | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Data Store' | stats avg('Storage Used (%)') as 'Average Storage Usage', trend(avg('Storage Used (%)'), 1hour) | compare timeshift = auto |
| Average Host CPU Usage | Average CPU usage across ESXi hosts. | Average VMWare Host CPU Usage | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere ESXi Host' | stats avg('CPU Usage (%)') as 'Average Host CPU Usage', trend(avg('CPU Usage (%)'), 1hour) | compare timeshift = auto |
| Average Host Memory Usage | Average memory usage across ESXi hosts. | Average VMWare Host Memory Usage | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere ESXi Host' | stats avg('Memory Used (%)') as 'Average Memory Usage', trend(avg('Memory Used (%)'), 1hour) | compare timeshift = auto |
| Average VM Memory Usage | Average memory usage across VMs in the selected time range. | Average VMWare VM Memory Usage | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere VM' | stats avg('Memory Used (%)') as 'Average Memory Usage', trend(avg('Memory Used (%)'), 1hour) | compare timeshift = auto |
| Alarms | Triggered vSphere alarms with details such as time, entity, entity type, status, alarm name, and message. | VMWare Alarms | 'Log Source' = 'VMWare vSphere Alarms' | fields -'Log Source', -Label, -'Problem Priority', -'Host Name (Server)', Entity, 'Entity Type', Status, 'Alarm Name', Message |
| VMWare Topology | Discovered VMware topology so you can understand relationships across vCenter, data centers, clusters, hosts, VMs, networks, and data stores. | - | - |