Powershell script to see paths

[ajohn24]

Hi,

Need a simple script to check how many paths are available from each vhba. Also need it to determine if there are any dead paths reported.

Output :

vmhba1 :

Targets :2

Devices:10

Paths:9

Dead Path :

vmhba1:c0:t0:l0 Target Lun Status

vmhba2:

Targets :2

Devices:10

Paths:10

Thx

[ajohn24]

Got something related from Luc script at http://communities.vmware.com/message/1766761 but what i want is:

Number of paths from the givern vmhba

Dead path and/or missing path with the details.

Any suggestions?

[LucD]

How would you determine dead paths ?

[ajohn24]

Hi Luc,

I meant something like we can see on the GUI or manually from the ESXi console. If that's not possible can we just determine the number of paths?

[LucD]

Would something like this do ?

foreach($esx in Get-VMHost){
  foreach($hba in (Get-VMHostHba -VMHost $esx -Type "FibreChannel")){
    $target = $hba.VMhost.ExtensionData.Config.StorageDevice.ScsiTopology.Adapter | 
      where {$_.Adapter -eq $hba.Key} | %{$_.Target}
    $luns = Get-ScsiLun -Hba $hba -LunType "disk" -ErrorAction SilentlyCOntinue | Measure-Object | Select -ExpandProperty Count
    $nrPaths = $target | %{$_.Lun.Count} | Measure-Object -Sum | select -ExpandProperty Sum
    $hba | Select @{N="VMHost";E={$esx.Name}},@{N="HBA";E={$hba.Name}},
    @{N="Target#";E={if($target -eq $null){0}else{@($target).Count}}},@{N="Device#";E={$luns}},@{N="Path#";E={$nrPaths}}
  }
}

[ajohn24]

Perfect.thanks!

[Mike265]

Hi

Just what I was looking for too, how could you export this to csv please?

[LucD]

A ForEach loop doesn't place objects on the pipeline, so you'll have to use a trick.

Place the complete script in a call block, and then you can do the export.

It would look something like this

& {

# The original script

} | ExExport-Csv C:\report.csv -NoTypeInformation -UseCulture

[Mike265]

Stunning, that has just saved me a huge amount of OAT testing time.

Many thanks