Get resource utilization from all VMs in a cluster

Hi,

I've developed a customized capacity management report that collects all the resource utilization of the virtual machines in a datacenter. The function that collects this looks like this:

def hostMemoryConsumed = []

def memoryConsumed = 0.0f

def memoryGranted = 0.0f

VMs.each() {

  vm ->

  try {

    memoryConsumed += vm.host.memory.consumed.current.average / 1024.0f <----- HOW TO DO THIS TO GET FROM CLUSTERS

    memoryGranted += vm.host.memory.capacity.current.average / 1024.0f

  

  }

  catch(NullPointerException e) { }

}

VMs is a function parameter of type VMW Virtual Machines

The above works for datacenter Virtual machines, but I need it to be after cluster. I can find a clusters virtual machines but I'm having troubles with referencing the specific values to get e.g memory consumed and capacity.

If I change the parameter to type: VMW Cluster how would the metrics reference look like (see the try{})?

I don't think a Query will help me.

Thanks in advance

Erik Alm