Not too long ago, I wrote a script for Script-O-Mania, the idea of the script was to gather CPU Ready times from VMs across one or more ESX hosts and display their values on a nice graph. I felt like this would be a useful tool because the only way to see the CPU Ready Time information in vCenter is on a VM by VM basis, there is no way to select a single host and see the CPU Ready Time for several VMs on a single graph. Since that particular counter can be useful in identifying sluggish VMs, I felt like it would be really useful to be able to see several VMs together as well as to compare VMs on one ESX host to another. The original script can be found on the
Script-O-Mania contest page.
After writing that script, I thought it could be even more useful if it could be used for other performance counters besides just CPU Ready and also if instead of grouping the VMs just by the ESX host, if I could group them by any object that is visible in vCenter such as a cluster, folder, resource pool etc. In vCenter the graphs you see for these objects contain specific counters pertinent to those objects, the performance tab does not allow you to graph VMs that contained in the specified group object.
I used PrimalForms 2009 to make it more user friendly with a GUI front end. To use this little app, please make sure you have the following prerequisites installed.
Prerequisites:
- Powershell 2.0
-
PowerCli
- Microsoft Excel 2007
- The underlying Powershell script is not signed, so set your Powershell settings accordingly
Feel free to leave your comments and suggestions.
Download
here