Custom Report - All VMs by Host With Summary

Question

Hello all,

I'm trying to create a report to list all VM guests, grouped by the VM host they are currently on.

I've managed to do this by grouping the table by Virtual Host - Host Name.  So far each host it simply shows the Host Name.

What I would like to do is to have a header for each Host, so I can show the CPU Count, RAM etc in the host.  In a footer, I'd like to count the CPUs / RAM allocated to the guests.

Is this something that will need SWQL?

Thanks,

Chris.

storn · Answer

Did you ever get this working??

_chrisb_ · Answer

Header for each host would ideally show the name, hypervisor, CPU core count and RAM.  Then each guest VM running on that host - name, OS, vCPUs and RAM assigned, finishing with a summary footer to show the totals for vCPU and RAM.

dgsmith80 · Answer

What stats exactly do you want to see?