next »

[esarakaitis]

Code:

Get-VMHost | %{Get-View $_.ID} | %{
  $name = $_.name
  $esx = "" | select NumCpuPackages, NumCpuCores, Hz, Memory
  $esx.NumCpuPackages = $_.Hardware.CpuInfo.NumCpuPackages
  $esx.NumCpuCores = $_.Hardware.CpuInfo.NumCpuCores
  $esx | select-object @{Name = "Name"; Expression = {$name}}, @{Name = "Sockets"; Expression = {$esx.NumCpuPackages}}, @{Name = "Cores"; Expression = {$esx.NumCpuCores}}
  }

[X505]

Hi esarakaitis,
Thanks a lot for this little code sample 

In order to check vmotion Capabilities between my hosts, i do some changes from your script. It might help someone :

Code:

$Col = @()    # Prepare output collection
Get-VMHost | %{Get-View $_.ID} | %{
  $esx = "" | select name, NumCpuPackages, NumCpuCores, CpuMhz, CpuModel
  $esx.name = $_.name
  $esx.NumCpuPackages = $_.Hardware.CpuInfo.NumCpuPackages
  $esx.NumCpuCores = $_.Hardware.CpuInfo.NumCpuCores
  $esx.CpuMhz = $_.Summary.Hardware.CpuMhz
  $esx.CpuModel = $_.Summary.Hardware.CpuModel
  $esx | select-object (
  @{Name = "Name"; Expression = {$esx.name}},
  @{Name = "Sockets"; Expression = {$esx.NumCpuPackages}},
  @{Name = "Cores"; Expression = {$esx.NumCpuCores}},
  @{Name = "MHz"; Expression = {$esx.CpuMhz}},
  @{Name = "Model"; Expression = {$esx.CpuModel}}
  )
  $Col += $esx   # Add output to collection
  }
  $Col | Export-Csv ./cpuinfo.csv -NoTypeInformation   # Export output to csv

Edit : add csv export

[esarakaitis]

very nice! and welcome aboard!

[X505]

very nice! and welcome aboard!

Thanks

[dma0211]

Why not do it for all the hosts in VC. Here is just the socket count.

Code:

$vc = Read-Host "Enter VC server name"
Connect-VIServer "$VC"

$report = @()
get-vmhost | Sort Name -Descending | % {
  $vmh = Get-View $_.ID
    $vmhs = "" | Select-Object VMHName, Summary
    $vmhs.VMHName = $vmh.Name
$vmhs.Summary = $vmh.Summary.Hardware.NumCpuPkgs
$report += $vmhs
}
$report | Export-Csv "C:\vmh_hostsummary.csv" -NoTypeInformation

[esarakaitis]

what do you mean, the initial script gets the information for each host

[dma0211]

Sorry about that, I did not see a VC connection and thought you were connecting to a single host.

[esarakaitis]

i dont specify vc connection in any of my scripts, as I'm assuming that your either already connected or planning on connecting

[dma0211]

Seems like anytime I try that, it always backfires. Good to know. This is a great resource.

[esarakaitis]

no problem!

[PJ]

Hi Eric,
 
I am newbie in both vmware and scripting.
 
Please help me in your script below. I want to run your script to get an information of vmware socket in our environment.
 
1. Is your script in power shell?
2. how do i connect to vCenter and get the output to a excel.
3. Can you please provide me the complete code.
 
Thanks in advance for your help.
PJ

[esarakaitis]

yes its in powershell, this is the powershell section of the forum.
to connect to vCenter type: connect-viserver "vcenter name"

Code:

$myCol = @()
ForEach ($Cluster in Get-Cluster)
    {
        ForEach ($vmhost in ($cluster | Get-VMHost))
        {
            $VMView = $VMhost | Get-View
                        $VMSummary = ?? | Select HostName, ClusterName, MemorySizeGB, CPUSockets, CPUCores
                        $VMSummary.HostName = $VMhost.Name
                        $VMSummary.ClusterName = $Cluster.Name
                        $VMSummary.MemorySizeGB = $VMview.hardware.memorysize / 1024Mb
                        $VMSummary.CPUSockets = $VMview.hardware.cpuinfo.numCpuPackages
                        $VMSummary.CPUCores = $VMview.hardware.cpuinfo.numCpuCores
                        $myCol += $VMSummary
                    }
            }
$myCol #| export-csv c:\1.csv #| out-gridview

just comment out the export function you want.

[PJ]

thanks for your quick response.

can i run this script remotely from my machine or run it the vCenter.
if i can run it from my machine do I need to add some steps in the script to authenticate the vCenter.

[esarakaitis]

either way, i explained in the previous post on how to authenicate to the vcenter

have you read the readme that came with PowerCLI?

[PJ]

Thanks a lot! It worked.