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?
Cool, this sounds like exactly what I’m looking for
PowerCLI is the way to go! You could also take a look at RVTools.