search

jorgedlcruz / vmware-grafana

A simple way to retrieve vCenter information and send it to InfluxDB, to present it later with Grafana
MIT License
185 stars 49 forks source link

vSphere - Hosts cpu usage #23

Closed lasse-kristensen closed 3 years ago

lasse-kristensen commented 4 years ago

I use your VMware Vsphere - Hosts grafana dashboard, but when I looked at the CPU Usage, it didn't reflect what i was seeing in the vSphere client. I found that the query didn't use the instance-total cpu WHERE clause After adding this it reflected what I saw i vSphere.

SELECT mean("usage_average") FROM "vsphere_host_cpu" WHERE ("esxhostname" =~ /^$esxi$/ AND "cpu" = 'instance-total') AND $timeFilter GROUP BY time($__interval) fill(null)

Thanks a lot for creating great dashboards.

jorgedlcruz commented 3 years ago

Thank you, should be okay now, just used the same query. Cheers!