Find the processor type for all hosts for VMs located in a certain folder its' subfolders

[dbutch1976]

Hello,

We have both Intel and AMD hosts. We have an application which runs across multiple clusters, some on AMD and some on Intel. I would like to provide a list of all the VMs and what type of processor the host that they run on is using. I found this which will give me a list of all the VMs in the folder and it's subfolders:

$folderName = 'MyApplication'
$folder = Get-View -ViewType Folder -Property Name -Filter @{'Name'=$folderName} | Select -ExpandProperty MoRefGet-View -
ViewType VirtualMachine -SearchRoot $folder |
Select Name

This gives the Name of the VMs, but how can I get the processor type of the host that the VM runs on ?

Thanks.

[LucD · Accepted solution]

Just add a calculated property on the Select-Object

Get-View -ViewType VirtualMachine -SearchRoot $folder |
Select Name,@{N='VMHostCPU';E={(Get-View -Id $_.Runtime.Host).Hardware.CpuPkg[0].Description}}

If you need more details on the CPU, check what is available in the HostCpuPackage object.

[dbutch1976]

Wow you make it look so easy, I have a lot to learn about views and calculated properties!  It's exactly what I need, but how can I add the folder name and the cluster name to the output?

[LucD]

Again with calculated properties.
The trick is to know/learn which object points to which other objects.

The schematic on the ServiceInstance page will get you started.

Get-View -ViewType VirtualMachine -SearchRoot $folder |
Select Name,
  @{N='CPUFamily';E={(Get-View -Id $_.Runtime.Host).Hardware.CpuPkg[0].Description}},
  @{N='Folder';E={(Get-View -Id $_.Parent).Name}},
  @{N='Cluster';E={(Get-View -Id (Get-View -Id $_.Runtime.Host).Parent).Name}}

[dbutch1976]

Thanks LucD!