Luc i found your very good post
$esxName = "192.168.1.20"
$tgtAdapters = "vmhba33","vmhba34"
$metrics = "disk.deviceLatency.average","disk.kernelLatency.average",
"disk.queueLatency.average","disk.commandsAborted.summation",
"disk.busResets.summation"
$esxImpl = Get-VMHost -Name $esxName
$esx = $esxImpl | Get-View
$endDate = Get-Date
$startDate = $endDate.AddHours(-1)
# # Find active instances per selected adapter
$instances = @{}
$instancesFilter = @()
foreach($adapter in $tgtAdapters){
$adapterInstances = @()
$adapterKey = ($esx.Config.StorageDevice.HostBusAdapter | where {$adapter -eq $_.Device}).Key
foreach($lun in $esx.Config.StorageDevice.MultipathInfo.Lun){
foreach($path in $lun.Path){
if($path.Adapter -eq $adapterKey -and $path.PathState -eq "active"){
foreach($scsiLun in $esx.Config.StorageDevice.ScsiLun){
if($scsiLun.Key -eq $lun.lun){
$adapterInstances += $scsiLun.CanonicalName
$instancesFilter += $scsiLun.CanonicalName
}
}
}
}
}
$instances[$adapter] = $adapterInstances
}
# Get statistics for instances
$stats = Get-Stat -Entity $esxImpl -Stat $metrics -Start $startDate -Finish $endDate | `
where {$instancesFilter -contains $_.Instance}
# Create the reporting array
$hbaTab = @{}
$stats | %{
# Determine HBA-name based on instance
$instance = $_.Instance
$instances.GetEnumerator() | %{
if($_.Value -contains $instance){$currentHba = $_.Name}
}
# Gethash table for adapter
if($hbaTab.ContainsKey($currentHba)){
$timeTab = $hbaTab[$currentHba]
}
else{
$timeTab = @{}
}
# Check if there is a row for this timestamp
if($timeTab.ContainsKey($_.Timestamp)){
$row = $timeTab[$_.Timestamp]
}
else{
$row = New-Object PSObject -Property @{
Time = $_.Timestamp
Interval = 0
GAVG = 0
DAVG = 0
KAVG = 0
QUED = 0
ABRT = 0
RESET = 0
}
}
$row.Interval = $_.IntervalSecs
$value = $_.Value
switch($_.MetricId){
"disk.deviceLatency.average"{$row.DAVG += $Value}
"disk.kernelLatency.average"{$row.KAVG += $Value}
"disk.queueLatency.average"{$row.QUED += $Value}
"disk.commandsAborted.summation"{$row.ABRT += $Value}
"disk.busResets.summation"{$row.RESET += $Value}
}
$timeTab[$_.Timestamp] = $row
$hbaTab[$currentHba] = $timeTab
}
$hbaTab.GetEnumerator() | %{
$_.Value.GetEnumerator() | %{
$_.Value.GAVG = $_.Value.DAVG + $_.Value.KAVG
$_.Value.ABRT /= $_.Value.Interval
$_.Value.RESET /= $_.Value.Interval
}
$_.Value.Values | Sort-Object -Property Time | `
Export-Csv ("C:\IO-stat-" + $esxName.Split(".")[0] + "-" + $_.Name + ".csv") -NoTypeInformation -UseCulture
}
it's the same that my other script, i try something to integer works days but i don't found how. can you help me please ?