5 Replies Latest reply on May 22, 2018 2:50 AM by antoniogemelli

    Cluster cpu info

    antoniogemelli Enthusiast

      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

        • 1. Re: Cluster cpu info
          LucD Guru
          Community WarriorsvExpertUser Moderators

          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 

          1 person found this helpful
          • 2. Re: Cluster cpu info
            antoniogemelli Enthusiast

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

            • 3. Re: Cluster cpu info
              antoniogemelli Enthusiast

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

              • 4. Re: Cluster cpu info
                LucD Guru
                vExpertCommunity WarriorsUser Moderators

                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

                1 person found this helpful
                • 5. Re: Cluster cpu info
                  antoniogemelli Enthusiast

                  Perfect! many thanks