Solved: Re: Cluster Statistics

pmeqix · ‎08-16-2011

Hello,

I have the attached cluster report script where I am trying to report following data and need some help in getting the information through the right functions and commands.

This Category names match the overall info represented in VC Client interface

Summary Tab
- General
  - Total CPU Resources
  - Total Memory
  - Number of Hosts
  - Total Processors
    - Number of Sockets --???
    - Number of Cores --???
- VMware HA
  - Current CPU Failover Capacity
  - Current Memory Failvoer Capacity
  - Configured Failover Capacity
- VMware DRS
  - Migration Automation Level
  - DRS Recommendations
  - DRS Faults
  - Migration Threshold
  - target hosts load standard deviation
  - Current host load standard deviation
Resource Allocation Tab
- CPU
  - Total Capacity
  - Reserved Capacity
  - Available Capacity
- Memory
  - Total Capacity
  - Reserved Capacity
  - Available Capacity
Performance Tab
- Hosts View - Per Host
  - "n' Days summary - CPU %
  - "n' Days summary - Memory MB
  - "n' Days summary - Disk ms
  - Top 10 - CPU Usage
  - Top 10 - Memory Consumed
  - Top 10 - Disk (KBps)
  - Top 10 - Network (Mbps)

Any help on getting this additional functionality is highly appreciated.

LucD · ‎08-16-2011

Start with this

$report = @()
# $clusterName = "MyCluster"  $clusterName = "*"
$report = foreach($cluster in Get-Cluster -Name $clusterName){
    $esx = $cluster | Get-VMHost 
    $ds = Get-Datastore -VMHost $esx | where {$_.Type -eq "VMFS" -and $_.Extensiondata.Summary.MultipleHostAccess}

    New-Object PSObject -Property @{
        VCname = $cluster.Uid.Split(':@')[1]
        DCname = (Get-Datacenter -Cluster $cluster).Name
        Clustername = $cluster.Name
        "Number of hosts" = $esx.Count
        "Total Processors" = ($esx | measure -InputObject {$_.Extensiondata.Summary.Hardware.NumCpuPkgs} -Sum).Sum
        "Total Cores" = ($esx | measure -InputObject {$_.Extensiondata.Summary.Hardware.NumCpuCores} -Sum).Sum
        "Current CPU Failover Capacity" = $cluster.Extensiondata.Summary.AdmissionControlInfo.CurrentCpuFailoverResourcesPercent
        "Current Memory Failover Capacity" = $cluster.Extensiondata.Summary.AdmissionControlInfo.CurrentMemoryFailoverResourcesPercent
        "Configured Failover Capacity" = $cluster.Extensiondata.ConfigurationEx.DasConfig.FailoverLevel
        "Migration Automation Level" = $cluster.Extensiondata.ConfigurationEx.DrsConfig.DefaultVmBehavior
        "DRS Recommendations" = &{$result = $cluster.Extensiondata.Recommendation | %{$_.Reason};if($result){[string]::Join(',',$result)}}
        "DRS Faults" = &{$result = $cluster.Extensiondata.drsFault | %{$_.Reason};if($result){[string]::Join(',',$result)}}
        "Migration Threshold" = $cluster.Extensiondata.ConfigurationEx.DrsConfig.VmotionRate
        "target hosts load standard deviation" = "NA"
        "Current host load standard deviation" = "NA"        
        "Total Physical Memory (MB)" = ($esx | Measure-Object -Property MemoryTotalMB -Sum).Sum
        "Configured Memory MB" = ($esx | Measure-Object -Property MemoryUsageMB -Sum).Sum
        "Available Memroy (MB)" = ($esx | Measure-Object -InputObject {$_.MemoryTotalMB - $_.MemoryUsageMB} -Sum).Sum
        "Total CPU (Mhz)" = ($esx | Measure-Object -Property CpuTotalMhz -Sum).Sum
        "Configured CPU (Mhz)" = ($esx | Measure-Object -Property CpuUsageMhz -Sum).Sum
        "Available CPU (Mhz)" = ($esx | Measure-Object -InputObject {$_.CpuTotalMhz - $_.CpuUsageMhz} -Sum).Sum
        "Total Disk Space (MB)" = ($ds | where {$_.Type -eq "VMFS"} | Measure-Object -Property CapacityMB -Sum).Sum
        "Configured Disk Space (MB)" = ($ds | Measure-Object -InputObject {$_.CapacityMB - $_.FreeSpaceMB} -Sum).Sum
        "Available Disk Space (MB)" = ($ds | Measure-Object -Property FreeSpaceMB -Sum).Sum
    }
}

$report | Export-Csv "C:\Cluster-Report.csv" -NoTypeInformation -UseCulture

It will produce most properties, except for the Performance tab entries.

I didn't understand what you wanted there, the values that are presented in these graphs ?

Also note that both standard deviation properties are marked as "NA".

The exact calculation method for those 2 hasn't been published afaik.

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

View solution in original post

LucD · ‎08-16-2011

Start with this

$report = @()
# $clusterName = "MyCluster"  $clusterName = "*"
$report = foreach($cluster in Get-Cluster -Name $clusterName){
    $esx = $cluster | Get-VMHost 
    $ds = Get-Datastore -VMHost $esx | where {$_.Type -eq "VMFS" -and $_.Extensiondata.Summary.MultipleHostAccess}

    New-Object PSObject -Property @{
        VCname = $cluster.Uid.Split(':@')[1]
        DCname = (Get-Datacenter -Cluster $cluster).Name
        Clustername = $cluster.Name
        "Number of hosts" = $esx.Count
        "Total Processors" = ($esx | measure -InputObject {$_.Extensiondata.Summary.Hardware.NumCpuPkgs} -Sum).Sum
        "Total Cores" = ($esx | measure -InputObject {$_.Extensiondata.Summary.Hardware.NumCpuCores} -Sum).Sum
        "Current CPU Failover Capacity" = $cluster.Extensiondata.Summary.AdmissionControlInfo.CurrentCpuFailoverResourcesPercent
        "Current Memory Failover Capacity" = $cluster.Extensiondata.Summary.AdmissionControlInfo.CurrentMemoryFailoverResourcesPercent
        "Configured Failover Capacity" = $cluster.Extensiondata.ConfigurationEx.DasConfig.FailoverLevel
        "Migration Automation Level" = $cluster.Extensiondata.ConfigurationEx.DrsConfig.DefaultVmBehavior
        "DRS Recommendations" = &{$result = $cluster.Extensiondata.Recommendation | %{$_.Reason};if($result){[string]::Join(',',$result)}}
        "DRS Faults" = &{$result = $cluster.Extensiondata.drsFault | %{$_.Reason};if($result){[string]::Join(',',$result)}}
        "Migration Threshold" = $cluster.Extensiondata.ConfigurationEx.DrsConfig.VmotionRate
        "target hosts load standard deviation" = "NA"
        "Current host load standard deviation" = "NA"        
        "Total Physical Memory (MB)" = ($esx | Measure-Object -Property MemoryTotalMB -Sum).Sum
        "Configured Memory MB" = ($esx | Measure-Object -Property MemoryUsageMB -Sum).Sum
        "Available Memroy (MB)" = ($esx | Measure-Object -InputObject {$_.MemoryTotalMB - $_.MemoryUsageMB} -Sum).Sum
        "Total CPU (Mhz)" = ($esx | Measure-Object -Property CpuTotalMhz -Sum).Sum
        "Configured CPU (Mhz)" = ($esx | Measure-Object -Property CpuUsageMhz -Sum).Sum
        "Available CPU (Mhz)" = ($esx | Measure-Object -InputObject {$_.CpuTotalMhz - $_.CpuUsageMhz} -Sum).Sum
        "Total Disk Space (MB)" = ($ds | where {$_.Type -eq "VMFS"} | Measure-Object -Property CapacityMB -Sum).Sum
        "Configured Disk Space (MB)" = ($ds | Measure-Object -InputObject {$_.CapacityMB - $_.FreeSpaceMB} -Sum).Sum
        "Available Disk Space (MB)" = ($ds | Measure-Object -Property FreeSpaceMB -Sum).Sum
    }
}

$report | Export-Csv "C:\Cluster-Report.csv" -NoTypeInformation -UseCulture

It will produce most properties, except for the Performance tab entries.

I didn't understand what you wanted there, the values that are presented in these graphs ?

Also note that both standard deviation properties are marked as "NA".

The exact calculation method for those 2 hasn't been published afaik.

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

pmeqix · ‎08-16-2011

Hi Luc

That was really helpful. and yes for the performance I meant getting the chart numbers to represent them in a textual format in the report.

Also i got the following error's when running the script but it did complete successfully. so not sure what these errors mean and why they popped up?

Get-Datastore : Cannot validate argument on parameter 'VMHost'. The argument is

null or empty. Supply an argument that is not null or empty and then try the c

ommand again.

At C:\scripts\clusterstats.ps1:6 char:32

+ $ds = Get-Datastore -VMHost <<<< $esx | where {$_.Type -eq "VMFS" -and $

_.Extensiondata.Summary.MultipleHostAccess}

+ CategoryInfo : InvalidData: (:) [Get-Datastore], ParameterBindi

ngValidationException

+ FullyQualifiedErrorId : ParameterArgumentValidationError,VMware.VimAutom

ation.ViCore.Cmdlets.Commands.GetDatastore

Get-Datastore : Cannot validate argument on parameter 'VMHost'. The argument is

null or empty. Supply an argument that is not null or empty and then try the c

ommand again.

At C:\scripts\clusterstats.ps1:6 char:32

+ $ds = Get-Datastore -VMHost <<<< $esx | where {$_.Type -eq "VMFS" -and $

_.Extensiondata.Summary.MultipleHostAccess}

+ CategoryInfo : InvalidData: (:) [Get-Datastore], ParameterBindi

ngValidationException

+ FullyQualifiedErrorId : ParameterArgumentValidationError,VMware.VimAutom

ation.ViCore.Cmdlets.Commands.GetDatastore

LucD · ‎08-16-2011

That is strange, that would mean you have a cluster with no ESX(i) hosts in it somewhere ?

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

pmeqix · ‎08-16-2011

Luc

Yes currently we do not have any ESX(i) hosts in our environment. but that is changing by next week.

Any ideas on the performance tab info?

coolvirtual · ‎03-05-2012

Hi LucD

I need an HTML output for the cluster stastics script.

Can you help me with this?

thanks

LucD · ‎03-05-2012

Change the last line into

$report | ConvertTo-Html | Out-File .\report.html

This will produce a very basic HTML page.

You can get very fancy, Alan's vCheck script is a very good example.

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

coolvirtual · ‎03-05-2012

My datasore is divided into 3 tiers..

Is there anyways I can get report on it serperately?

FABSAN · ‎09-04-2012

Why are these crossed out? Is there a way of getting this info via powercli? I've been trying to figure it out

Resource Allocation Tab

CPU
- Total Capacity
- Reserved Capacity
- Available Capacity
Memory
- Total Capacity
- Reserved Capacity
- Available Capacity

LucD · ‎09-04-2012

The original author of the thread didn't seem to want these values.

But you retrieve them with PowerCLI, something like this

$cluster = Get-Cluster MyCluster 
$rp = Get-View $cluster.ExtensionData.ResourcePool
 Select -InputObject $cluster -Property Name,
 @{N="CPU Total Capacity";E={$rp.Runtime.Cpu.MaxUsage}},
@{N="CPU Reserved Capacity";E={$rp.Runtime.Cpu.ReservationUsed}},
@{N="CPU Available Capacity";E={$rp.Runtime.Cpu.MaxUsage - $rp.Runtime.Cpu.ReservationUsed}},
@{N="Memory Total Capacity";E={$rp.Runtime.Memory.MaxUsage}},
@{N="Memory Reserved Capacity";E={$rp.Runtime.Memory.ReservationUsed}},
@{N="Memory Available Capacity";E={$rp.Runtime.Memory.MaxUsage - $rp.Runtime.Memory.ReservationUsed}}

It shouldn't be too difficult to add these values to the report.

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

FABSAN · ‎09-05-2012

that worked, Thanks!

FABSAN · ‎09-11-2012

Hi LucD, I tried peicing together the two but getting errors. Seperately I was able to get it to work. I even went to a couple of book stores to find "VMware vSphere PowerCLI Reference" but it was unavailable. Any help putting together the two would be appreciated.

LucD · ‎09-11-2012

Try it like this

$report = @()
$clusterName = "*"
$report = foreach($cluster in Get-Cluster -Name $clusterName){
    $esx = $cluster | Get-VMHost 
    $ds = Get-Datastore -VMHost $esx | where {$_.Type -eq "VMFS" -and $_.Extensiondata.Summary.MultipleHostAccess}
    $rp = Get-View $cluster.ExtensionData.ResourcePool
    New-Object PSObject -Property @{
        VCname = $cluster.Uid.Split(':@')[1]
        DCname = (Get-Datacenter -Cluster $cluster).Name
        Clustername = $cluster.Name
        "Number of hosts" = $esx.Count
        "Total Processors" = ($esx | measure -InputObject {$_.Extensiondata.Summary.Hardware.NumCpuPkgs} -Sum).Sum
        "Total Cores" = ($esx | measure -InputObject {$_.Extensiondata.Summary.Hardware.NumCpuCores} -Sum).Sum
        "Current CPU Failover Capacity" = $cluster.Extensiondata.Summary.AdmissionControlInfo.CurrentCpuFailoverResourcesPercent
        "Current Memory Failover Capacity" = $cluster.Extensiondata.Summary.AdmissionControlInfo.CurrentMemoryFailoverResourcesPercent
        "Configured Failover Capacity" = $cluster.Extensiondata.ConfigurationEx.DasConfig.FailoverLevel
        "Migration Automation Level" = $cluster.Extensiondata.ConfigurationEx.DrsConfig.DefaultVmBehavior
        "DRS Recommendations" = &{$result = $cluster.Extensiondata.Recommendation | %{$_.Reason};if($result){[string]::Join(',',$result)}}
        "DRS Faults" = &{$result = $cluster.Extensiondata.drsFault | %{$_.Reason};if($result){[string]::Join(',',$result)}}
        "Migration Threshold" = $cluster.Extensiondata.ConfigurationEx.DrsConfig.VmotionRate
        "target hosts load standard deviation" = "NA"
        "Current host load standard deviation" = "NA"        
        "Total Physical Memory (MB)" = ($esx | Measure-Object -Property MemoryTotalMB -Sum).Sum
        "Configured Memory MB" = ($esx | Measure-Object -Property MemoryUsageMB -Sum).Sum
        "Available Memroy (MB)" = ($esx | Measure-Object -InputObject {$_.MemoryTotalMB - $_.MemoryUsageMB} -Sum).Sum
        "Total CPU (Mhz)" = ($esx | Measure-Object -Property CpuTotalMhz -Sum).Sum
        "Configured CPU (Mhz)" = ($esx | Measure-Object -Property CpuUsageMhz -Sum).Sum
        "Available CPU (Mhz)" = ($esx | Measure-Object -InputObject {$_.CpuTotalMhz - $_.CpuUsageMhz} -Sum).Sum
        "Total Disk Space (MB)" = ($ds | where {$_.Type -eq "VMFS"} | Measure-Object -Property CapacityMB -Sum).Sum
        "Configured Disk Space (MB)" = ($ds | Measure-Object -InputObject {$_.CapacityMB - $_.FreeSpaceMB} -Sum).Sum
        "Available Disk Space (MB)" = ($ds | Measure-Object -Property FreeSpaceMB -Sum).Sum
        "CPU Total Capacity" = $rp.Runtime.Cpu.MaxUsage
        "CPU Reserved Capacity" = $rp.Runtime.Cpu.ReservationUsed
        "CPU Available Capacity" = $rp.Runtime.Cpu.MaxUsage - $rp.Runtime.Cpu.ReservationUsed
        "Memory Total Capacity" = $rp.Runtime.Memory.MaxUsage
        "Memory Reserved Capacity" = $rp.Runtime.Memory.ReservationUsed
        "Memory Available Capacity" = $rp.Runtime.Memory.MaxUsage - $rp.Runtime.Memory.ReservationUsed
    }
}

$report | Export-Csv "C:\Cluster-Report.csv" -NoTypeInformation -UseCulture

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

AlbertWT · ‎09-11-2012

Thanks for sharing the script, however I got this error message:

Get-Cluster : You have modified the global:DefaultVIServer and global:DefaultVIServers system variables. This is not allowed. Please reset them to $null and reconnect to the vSphere server.

At C:\Users\Administrator\AppData\Local\Temp\37b5331b-c9c8-4190-b0af-d14ed3652fab.ps1:4 char:42

+ $report = foreach($cluster in Get-Cluster <<<< -Name $clusterName){

+ CategoryInfo : NotSpecified: (:) [Get-Cluster], InvalidState

+ FullyQualifiedErrorId : VMware.VimAutomation.ViCore.Types.V1.ErrorHandling.InvalidState,VMware.VimAutomation.ViCore.Cmdlets.Commands.GetCluster

what does that means ?

/* Any kind of comment or input would be greatly appreciated */

LucD · ‎09-11-2012

Does the following also return an error ?

Get-Cluster -Name *

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

FABSAN · ‎09-12-2012

it worked, thanks again!