How to query Vsphere/ESXI guest information?

At work I have been volunteered to create a spreadsheet of all of the guest operating systems with some basic info like OS, storage and CPU utilization for the bean counters to look at. Unfortunately there are ~150 guests and I was hoping there could be some way to query the vsphere api or get it to output a xml/json/csv/whatever or something and save myself the headache. Anyone know if this is possible and can point me in the right direction or am I completely fucked?

Have you had a look at VMware PowerCLI?

1 Like

Cool, this sounds like exactly what Iā€™m looking for :thinking:

PowerCLI is the way to go! You could also take a look at RVTools.