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 | Search Name in Log Explorer | Query |
|---|---|---|
| Data Center Clusters | 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 | VMWare Host Count | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Data Center' | stats latest('Host Count') as ESXiHosts |
| Virtual Machines | VMWare VM Count | 'Log Source' = 'VMWare vSphere Metrics' and 'Entity Type' = 'VMware vSphere Data Center' | stats latest('Virtual Machine Count') as VMs |
| Data Stores | 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 | 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 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 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 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 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 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 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 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 | 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 | - | - |