CPU, Cores per CPU and Total cores in standalone Host

[vmk2014]

Hello Experts,

we have a stand alone ESXi hosts 600 spread across globally, but we want to fetch CPU for Host/cores per CPU and Total cores in the below format. Is it possible to fetch this value from power Cli for Stand alone host ?

Note :- ESXi Host list we have. E.g. C:\temp\lists

   

Hostname	# CPU	Cores per CPU	# Total Cores
Host1	4	15	60
Host2	4	15	60
Host3	4	15	60
Host4	4	15	60
Host5	4	15	60
Host6	4	15	60
Host7	4	15	60
Host8	4	15	60

Thanks

Vk

[LucD]

Do you have the credentials for all these ESXi nodes?

I assume they are in $user and $pswd

Get-Content -Path 'C:\temp\lists' -PipelineVariable esxName |

ForEach-Object -Process {

    Connect-VIServer -Server $esxName -User $user -Password $pswd

    Get-VMHost |

    Select Name,

        @{N='NumberCPU';E={$_.ExtensionData.Summary.Hardware.numCpuPkgs}},

        @{N='CorePerCPU';E={$_.ExtensionData.Summary.Hardware.numCpuCores}},

        @{N='CoreTotal';E={$_.ExtensionData.Summary.Hardware.numCpuPkgs*$_.ExtensionData.Summary.Hardware.numCpuCores}}

    Disconnect-VIServer -Server $esxName -Confirm:$false

} | Export-Csv -Path .\report.csv -NoTypeInformation -UseCulture