Last week average and max latency:
Get-VM | ? {$_.PowerState -eq "PoweredOn"} | Select Name, @{n="AVG Max Latency (ms)";e={(get-stat -Entity $_ -Stat Disk.MaxTotalLatency.Latest -Start (Get-Date).AddDays(-7) | Measure Value -Average ).Average }},@{n="Max Latency (ms)";e={(get-stat -Entity $_ -Stat Disk.MaxTotalLatency.Latest -Start (Get-Date).AddDays(-7) | Measure Value -Maximum ).Maximum }}
Name AVG Max Latency (ms) Max Latency (ms)
---- -------------------- ----------------
vm-avamar-vproxy-72 6.82934131736527 207
vm-avamar-vproxy-71 5.46706586826347 246
vm-dpa-datastore-71 6.31437125748503 218
vm-backupvm-71 3.16766467065868 180
vm-dpa-applicati... 6.3622754491018 512
vm-dps-71 10.1137724550898 318
vm-avamar-71 7.0688622754491 259
vm-dpc-71 7.70958083832335 250
vm-ddve-71 26.6467065868263 593
vm-power-72 5.62275449101796 226
vm-ei-72 9.84131736526946 329
vm-cloudiq-73 47.4251497005988 4449
vm-sql-72 6.1377245508982 201
vm-vis-71 7.21556886227545 255
vm-cloudiq-72 20.0718562874251 2407
vm-ddm-72 5.68263473053892 238
vm-interop-72 6.61377245508982 266
vm-cloudiq-74 12.8293413173653 577
vm-edb-71 7.32335329341317 251
vm-edb-73 5.5688622754491 271
vm-interop-73 5.05688622754491 266
vm-ddm-71 6.52395209580838 225
vm-cloudiq-71 25.1916167664671 3162
vm-idm-72 5.47005988023952 254
vm-ei-71 9.04191616766467 287
vm-cloudiq-77 34.0149700598802 5310
vm-sql-71 6.10179640718563 214
vm-idm-71 5.5059880239521 187
vm-interop-71 5.88622754491018 222
vm-cloudiq-76 45.7844311377246 8561
vm-vis-72 7.15868263473054 245
vm-power-71 5.30838323353293 189
vm-test-71 0.646706586826347 101
vm-cloudiq-78 37.3353293413174 3451
vm-cloudiq-75 106.491017964072 19020
vm-edb-72 10.4041916167665 300
vm-ftp-71 3.45209580838323 240
vm-interop-74 4.2125748502994 276
vm-dns-a01 5.90718562874252 218
vm-vc-71 9.38023952095808 283
vm-ntp-71 2.76946107784431 175
vm-jump-71 4.52395209580838 360
vm-cisco-fmc 12.9191616766467 600
vm-mgmt-ldap 6.32335329341317 355
vCLS (3) 8.1377245508982 282
vCLS (5) 6.03293413173653 255
vCLS (4) 5.73353293413174 239
vCLS (6) 7.4940119760479 271
vCLS (2) 8.31137724550898 248
vCLS (1) 6.58682634730539 354
vm-ppt-77 20.4790419161677 757
vm-ppt-76 13.1497005988024 550
vm-ppt-75 76.9730538922156 10673
vm-ppt-71 28.3682634730539 1877
vm-ppt-72 19.0419161676647 871
vm-ppt-73 23.7125748502994 1215
vm-ppt-74 54.6467065868263 5611
vm-interop-32 6.53293413173653 234
vm-cloudiq-31 47.6946107784431 7698
vm-power-31 6.97904191616766 283
vm-cloudiq-33 16.4910179640719 719
vm-ppt-32 14.2125748502994 455
vm-ldap-71 5.73652694610778 381
vm-sdc-31 6.09281437125748 223
vm-edb-32 9.33532934131737 276
vm-nfs-a01 6.88323353293413 257
vm-cloudiq-32 17.3952095808383 592
vm-ppt-31 18.3233532934132 939
vm-idm-31 7.70359281437126 589
vm-interop-31 6.19161676646707 270
vm-av-71 7.70359281437126 213
vm-av-72 6.20958083832335 191
vm-av-73 7.38023952095808 242
