For the next report I wanted to have a copy of the VM state.. so I wrote this script to dump out the details i required into excel

Its not the fastest script…. I know how to improve its performance but honestly its not something I run very often so a quick and dirty solution was fine with me…

So about the Report…

VM Tab

VM,UUID,DNSName,IPAddress,ConfiguredOS,RunningOS,VMVersion,PowerState,Template,vCPUS,vMEM,ProvisionedGB,UsedSpaceGB,VMCluster,CurrentESXHost,Datastore(s),ResourcePool,FolderPath,VMConfigFileVMToolsVersion,VMToolsStatus

VMDK Tab

VM,Datastore,VMDK,StorageFormat,Capacity

VMNetwork Tab

VM,Name,Id,NicID,Type,NetworkName,MacAddress,ConnectionState

to the script…