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
Regards,
Suresh Dhanaraj
Hi Team,
Any update to the above query_
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
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
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
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.
Thanks Team. I will try and let you know. But does this script include uplink stat for used vs available %?
Regards,
Suresh Dhanaraj