Get-Stat ESXI and get average per day

[IKirill]

Hi for all!

Very simple script:

$entities = Get-VMHost esx-01
$stat = "cpu.usage.average"
$start = (Get-Date).AddDays(-4)
Get-Stat -Entity $entities -Stat $stat -Start $start  |
Select @{N='ESXi';E={$_.Entity.Name}},Timestamp,Value | 
Sort-Object -Property Timestamp

Works fine, but I get a lot of value.

What needs to be added to the script to get 4 lines, with average values per day?

[LucD]

Try something like this.
Btw I have done a post on the concept, see PowerCLI & VSphere Statistics – Part 2 – Come Together

$entities = Get-VMHost esx-01 

$stat = "cpu.usage.average"

$start = (Get-Date).AddDays(-4)

Get-Stat -Entity $entities -Stat $stat -Start $start -Instance '' |

   Sort-Object -Property Timestamp |

   Group-Object -Property { $_.Timestamp.DayOfYear } |

   ForEach-Object -Process {

   New-Object PSOBject -Property ([ordered]@{

   ESXi = $_.Group[0].Entity.Name

   Date = $_.Group[0].Timestamp.ToString('yyyyMMdd')

   CpuUsageAvg = [math]::Round(($_.Group | Measure-Object -Property Value -Average).Average, 1)

   })

}

[IKirill]

Thanks LUCD!

amazing!

thanks for the article, I read