How can I generate a report that will list all virtual machines, with their respective drive letters, volumes or mount points that are > 75% Free Space and are larger then 20 GB in size?
Using the query vm.vol.freeSpacePercentage:[75 TO 100] and vm.vol.freeSpace:[21474836480 TO *] returns a list of VMs but does not list the drives, volumes or mount points. I would like a report that lists the Virtual Machine Name, Volume Name, Used MB, Free BM, Total MB, % Used, % Free.