Script to report number of Windows VM's per host

[mattbondie]

I'm try to get a report of only the number of Windows VM's per esx host. The report needs to show the host names and the number of windows VM's on each. Can anyone help?

Regards

[LucD · Accepted solution]

Try like this.

The script assumes that the VMware Tools are installed on all VMs.

Get-VMHost |

Select Name,@{N='WinVM';E={(Get-VM -Location $_ | where{$_.Guest.OSFullName -match "Windows"}).Count}}

[mattbondie]

Perfect thanks!