I'm looking to generate an excel spreadsheet with various information about each one of my company's ~140 VMs residing on 7 ESX 3.5 servers - specifically, the VM's:
- Allocated Memory, Processors, Hard Drive
- Average Memory, Processor utilization for a given time period
- Maximum Memory, Processor utilization for a given time period
I know I can manually fill in a spread sheet, but I'm looking for a script (perhaps powershell) that I can run on a scheduled basis to keep an eye on things.