Cluster cpu info

[antoniogemelli]

Hello,

I have this script where I can get some CPU/Memory info:

Get-VMHost -Name tec-vm-ki* , tec-vm-* |
Select Name,
    @{N='CPU GHz Capacity';E={[math]::Round($_.CpuTotalMhz/1000,2)}},
    @{N='CPU GHz Used';E={[math]::Round($_.CpuUsageMhz/1000,2)}},
    @{N='CPU GHz Free';E={[math]::Round(($_.CpuTotalMhz - $_.CpuUsageMhz)/1000,2)}},
    @{N='Memory Capacity GB';E={[math]::Round($_.MemoryTotalGB,2)}},
    @{N='Memory Used GB';E={[math]::Round($_.MemoryUsageGB,2)}},
    @{N='Memory Free GB';E={[math]::Round(($_.MemoryTotalGB - $_.MemoryUsageGB),2)}} | Export-Csv -Path C:\Users\gemela\cpu_mem_Hardware_info.csv -NoTypeInformation -UseCulture

I would like to add some columns;

Number of CPU for Cluster

Cpu (number) usage for each host

Memory (Gb) usage for each host

Thanks

[LucD]

Try like this

Get-VMHost -Name tec-vm-ki* , tec-vm-* | 

Select Name,

    @{N='CPUCoreCluster';E={(Get-Cluster -VMHost $_).ExtensionData.Summary.NumCpuCores}},

    @{N='CPUCoreESXi';E={$_.NumCpu}},

    @{N='MemGBEsxi';E={$_.MemoryTotalGB}},

  @{N='CPU GHz Capacity';E={[math]::Round($_.CpuTotalMhz/1000,2)}}, 

  @{N='CPU GHz Used';E={[math]::Round($_.CpuUsageMhz/1000,2)}}, 

  @{N='CPU GHz Free';E={[math]::Round(($_.CpuTotalMhz - $_.CpuUsageMhz)/1000,2)}}, 

  @{N='Memory Capacity GB';E={[math]::Round($_.MemoryTotalGB,2)}}, 

  @{N='Memory Used GB';E={[math]::Round($_.MemoryUsageGB,2)}}, 

  @{N='Memory Free GB';E={[math]::Round(($_.MemoryTotalGB - $_.MemoryUsageGB),2)}} |

Export-Csv -Path C:\Users\gemela\cpu_mem_Hardware_info.csv -NoTypeInformation -UseCulture 

[antoniogemelli]

Great! This is what I wanted, thanks a lot LucD :-)

[antoniogemelli]

One more info,  can include "hyperthreading" if is enabled or not?

[LucD]

Sure, try like this

Get-VMHost -Name tec-vm-ki* , tec-vm-* |

Select Name,

  @{N='CPUCoreCluster';E={(Get-Cluster -VMHost $_).ExtensionData.Summary.NumCpuCores}},

  @{N='CPUCoreESXi';E={$_.NumCpu}},

  @{N='MemGBEsxi';E={$_.MemoryTotalGB}},

  HyperthreadingActive,

  @{N='CPU GHz Capacity';E={[math]::Round($_.CpuTotalMhz/1000,2)}},

  @{N='CPU GHz Used';E={[math]::Round($_.CpuUsageMhz/1000,2)}},

  @{N='CPU GHz Free';E={[math]::Round(($_.CpuTotalMhz - $_.CpuUsageMhz)/1000,2)}},

  @{N='Memory Capacity GB';E={[math]::Round($_.MemoryTotalGB,2)}},

  @{N='Memory Used GB';E={[math]::Round($_.MemoryUsageGB,2)}},

  @{N='Memory Free GB';E={[math]::Round(($_.MemoryTotalGB - $_.MemoryUsageGB),2)}} |

Export-Csv -Path C:\Users\gemela\cpu_mem_Hardware_info.csv -NoTypeInformation -UseCulture

[antoniogemelli]

Perfect! many thanks