Dashboard with virtual machines running on ESXi host

[matthias_dillie]

Hi all

Is there a way to show a table in a dashboard with all virtual machines running on a VMware ESXi host or better on all hosts in a zone? I would like to have an overview to see on which ESXi hosts the virtual machines are running.

Thanks

[dannemca · Accepted solution]

Yep, there is.

You can use any host metric you need, example builtin:host.availability, and then , set the split by host, and use the filter to select the ESXi Host you need to see the VMs of.

Example:

This is from demo.live.dynatrace.com, so I see no issues in showing hostnames here.

That's the current formula:

builtin:host.availability:filter(and(or(in("dt.entity.host",entitySelector("type(host),fromRelationship.runsOn(type(HYPERVISOR),entityName.equals(~"pl1l-vh90.lab.dynatrace.org~"))"))))):splitBy("dt.entity.host"):sort(value(auto,descending)):limit(20)

Try and let us know.

[matthias_dillie]

Thank you. This works, as the ESXi-hosts are rather static. I can produce a tabel for every ESXi-host with all the hosts running on this ESXi-host.

[dannemca]

Just noticed that the first metric I sent will bring only the hosts where OneAgent are running.

If you need all VMs , despite the OneAgent, please use any of these metrics from builtin:cloud.vmware.vm.*

Example:

Formula:

builtin:cloud.vmware.vm.cpu.readyPerc:filter(and(or(in("dt.entity.virtualmachine",entitySelector("type(virtualmachine),fromRelationship.runsOn(type(HYPERVISOR),entityName.equals(~"pl1l-vh90.lab.dynatrace.org~"))"))))):splitBy("dt.entity.virtualmachine"):sort(value(auto,descending)):limit(20)

Observe that this time, it is showing one more VM, which was not listed before, since OneAgent not running.

from ESXi Host details page: