Hi
Can anyone please advice the search query to find out overall health status of VMware using metric log.
index - vmware_metric
SPL - | mstats avg("vsphere.usage") prestats=true WHERE "index"="vmware-metrics" AND "host"="system1.local" AND ("host"="system2" OR "uuid"="12457896) span=10s
| timechart avg("vsphere.vm.cpu.usage") AS Avg span=10s
| fields - _span*
Not quite sure what you are looking for? VMware has different components - but you will find a range of pre configured KPI's you can adapt to your requirements for ESX, Virtual Machines, Storage etc in the ITSI Content pack for Vmware