Thanks for the info!
LucD wrote:
Note the -Instance parameter on the Get-Stat cmdlet, this tells the Get-Stat cmdlet to take the aggregated value over all CPUs that are present on the ESX(i) host.
The -Instance "" parameter made all the difference! I couldn't figure out what was causing the cpu.usage to not populate!
If anyone's interested, here's where I've used this. The following spits out CSV files containing realtime stats for each host from your connected PowerCLI session (you need to do Connect-VIServer <host or vCenter> first ). We will be using this to import the realtime stats into our 3rd-party enterprise monitoring / cap planning tool.
# Arrary of metrics we're going to collect.
$metrics = "cpu.usagemhz.average","cpu.usage.average","mem.consumed.average","mem.usage.average","net.usage.average","disk.maxTotalLatency.latest","disk.usage.average","mem.swapinRate.average","mem.swapoutRate.average"
$allHosts = Get-VMHost
$start = (Get-Date).AddMinutes(-60) # Last X minutes
# -------------------------------------------------------------------
# BEGIN MAIN SCRIPT BODY
# -------------------------------------------------------------------
write-host "Running vSphere Stats Collector for all hosts in your connected session."
write-host "Total Hosts: "($allHosts | Measure-Object).count
# In the following line begining with "$report =", note the following:
# use [-Realtime] to collect the (near) realtime interval stats (every 20 seconds is the most granular it will get)
# Use [-intervalmins 5] to collect the 5-minute averaged interval stats
# Remember to use [-Instance ""], to allow selection of CPU % averaged over all CPU instances.
ForEach ($omgHost in $allHosts){
$report = Get-Stat -Entity $omgHost -Stat $metrics -Realtime -Start $start -Instance "" | Group-Object -Property EntityId,Timestamp | %{
New-Object PSObject -Property @{
HostName = $_.Group[0].Entity.Name
DateTime = $_.Group[0].Timestamp
CpuMhzAvg = ($_.Group | where {$_.MetricId -eq "cpu.usagemhz.average"}).Value
CpuAvgPct = ($_.Group | where {$_.MetricId -eq "cpu.usage.average"}).Value
MemConsumedAvgKb = ($_.Group | where {$_.MetricId -eq "mem.consumed.average"}).Value
MemUseAvgPct = ($_.Group | where {$_.MetricId -eq "mem.usage.average"}).Value
MemTotalMB = $omgHost.MemoryTotalMB
NetUseAvgKBps = ($_.Group | where {$_.MetricId -eq "net.usage.average"}).Value
DiskMaxLatencyMS = ($_.Group | where {$_.MetricId -eq "disk.maxTotalLatency.latest"}).Value
DiskUsageAvgKBps = ($_.Group | where {$_.MetricId -eq "disk.usage.average"}).Value
MemSwapInKBps = ($_.Group | where {$_.MetricId -eq "mem.swapinRate.average"}).Value
MemSwapOutKBps = ($_.Group | where {$_.MetricId -eq "mem.swapoutRate.average"}).Value
}
}
$fileName = $omgHost.Name + "_RealTime_Stats.csv"
write-host "Outputing file: " $filename
$report | select-object -property HostName,DateTime,CpuMhzAvg,CpuAvgPct,MemConsumedAvgKb,MemUseAvgPct,MemTotalMB,NetUseAvgKBps,DiskMaxLatencyMS,DiskUsageAvgKBps,MemSwapInKBps,MemSwapOutKBps | Export-Csv $fileName -NoTypeInformation -UseCulture
}
write-host "Script Complete"
There's probably a better way of doing this in PowerCLI but this seems to work.
