VMware Cloud Community
hisureshd1
Contributor
Contributor

ESXi host CPU/RAM available % vs utilized %, LUN (Datastore)/Network (uplinks) available I/O % and utilized I/O % - Single Cluster

Hi Team,

I am in a position to send a weekly report of a specific cluster per ESXi host CPU/RAM available % vs utilized % (including how many host failure supported (e.g) N-1, N-2 etc)) and each LUN (Datastore)/Network (uplinks) available I/O % and utilized I/O %. Could you please help me to generate the Excel report with chart (may be using export-xlsx function) covering the below information for a single cluster (or specific cluster name is the Input). Could you please help me?

Report with Chart option for a specific cluster

  1. specific cluster per ESXi host CPU/RAM available % vs utilized %
  2. specific cluster overall ESXi host CPU/RAM available % vs utilized %
  3. How many host failure supported (e.g. N-1, N-2 etc) for a specific cluster Overall
  4. Each LUN (Datastore)/Network (uplinks) available I/O % and utilized I/O % per ESXi
  5. Overall LUN (Datastore)/Network (uplinks) available I/O % and utilized I/O % for a specific cluster

Regards,

Suresh Dhanaraj


Hi Team,

Any update to the above query_

0 Kudos
5 Replies
LucD
Leadership
Leadership

This is a quite extensive request.

What do you have already, and where are you stuck ?


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

0 Kudos
hisureshd1
Contributor
Contributor

Hi LucD,

I am currently left with only these two scripts,,

https://communities.vmware.com/thread/496410 --- cluster stats in last X days for CPU & memory

https://communities.vmware.com/thread/498592 ---- Cluster IOPS

Please help.

Regards,

Suresh Dhanaraj

0 Kudos
hisureshd1
Contributor
Contributor

Hi LucD,

VMWare Capacity & Performance Report -- # Ref https://onedrive.live.com/?cid=3a96121cddd80775&id=3A96121CDDD80775!6765

The above one gives lots of information including the information which I don’t need it in this scenario but cluster IOPS and network I/O not available.


Regards,

Suresh Dhanaraj

0 Kudos
AlbertWT
Virtuoso
Virtuoso

Try this script from Master LucD 🙂

the script can only be executed against one DRS cluster so change it accordingly to your need:

$clusterName = 'Production-Cluster01'

$stat = 'datastore.numberReadAveraged.average','datastore.numberWriteAveraged.average'

$esx =  Get-Cluster -Name $clusterName | Get-VMHost

$dsTab = @{}

Get-Datastore -RelatedObject $esx | where {$_.Type -eq 'VMFS' -and $_.ExtensionData.Summary.MultipleHostAccess} | Sort-Object -Property Name -Unique | %{

    $dsTab.Add($_.ExtensionData.Info.Vmfs.Uuid,$_.Name)

}

Get-Stat -Entity $esx -Stat $stat -Realtime -MaxSamples 1 |

Group-Object -Property Instance | %{

    if($dsTab.ContainsKey($_.Name)){

        New-Object PSObject -Property @{

            Datastore = $dsTab[$_.Name]

            ReadIOPS = $_.Group | where {$_.metricId -match 'read'} | Measure-Object -Property Value -Sum | Select -ExpandProperty Sum

            WriteIOPS = $_.Group | where {$_.metricId -match 'write'} | Measure-Object -Property Value -Sum | Select -ExpandProperty Sum

        }

    }

} | ft -AutoSize

hope this helps.

/* Please feel free to provide any comments or input you may have. */
0 Kudos
hisureshd1
Contributor
Contributor

Thanks Team. I will try and let you know. But does this script include uplink stat for used vs available %?

Regards,

Suresh Dhanaraj

0 Kudos