Skip to content

Instantly share code, notes, and snippets.

@vexx32

vexx32/VMCsv_GroupObject.ps1 Secret

Created September 6, 2019 16:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vexx32/699d31f61fcc640cfef1b6e65ce22303 to your computer and use it in GitHub Desktop.
Save vexx32/699d31f61fcc640cfef1b6e65ce22303 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
VMCsv_GroupObject.ps1
Import-Csv -Path '.\Collect-IOPS – 1 hour-5-6pm.csv' |
Group-Object -Property VM |
ForEach-Object {
$Results = $_.Group | Measure-Object -Property "WriteIOPS" -Average -Sum -Maximum -Minimum
[PSCustomObject]@{
VMName = $_.VM
AverageIOPS = $Results.Average
TotalIOPS = $Results.Sum
MaxIOPS = $Results.Maximum
MinIOPS = $Results.Minimum
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment