Export VMware VM CPU Stats to CSV

The Powershell script (link below) is used to generate the CPU Ready, Wait and Used statistics for the VM’s within VMware Virtual Centre.

http://www.barlow.eu.com/content/downloads/vmware-stats.ps1

The statitics are gathered, exported to CSV and opened in Excel.

In the first line you will need to replace virtualcentreserver with the name of your Virtual Centre server.

If you have a large Virtual Centre environment, you can filter further by amended the following line:
ForEach ($VM in ($VMHost | Get-VM | Sort Name))

for example if you wanted all VM’s with the names begining ABC you would use the following

ForEach ($VM in ($VMHost | Get-VM ABC* | Sort Name))

(Please note depending on the size of your Virtual Centre environment, this script may take several minutes to complete).