topic Re: ESXi host table with virtual machines in Dashboarding

Dashboard with virtual machines running on ESXi host

matthias_dillie — Mon, 22 May 2023 14:15:32 GMT

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

Re: ESXi host table with virtual machines

dannemca — Wed, 08 Feb 2023 20:33:46 GMT

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.

Re: ESXi host table with virtual machines

dannemca — Wed, 08 Feb 2023 20:40:40 GMT

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:

Re: ESXi host table with virtual machines

matthias_dillie — Thu, 09 Feb 2023 17:09:16 GMT

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.