Get WWN and WWP

[antoniogemelli]

Hello,

I check this discussion

I use this one:

$cluster = get-cluster

$hosti = get-Cluster $cluster | Get-VMHost

$report333 = @()

foreach ($esxi in $hosti) {

    $report333 +=Get-VMHosthba -VMHost $esxi -type FibreChannel |

    Select  @{N="Host";E={$esxi.Name}},

        @{N="HBA Node WWN";E={"{0:x}" -f $_.NodeWorldWideName}},

        @{N="HBA Port WWP";E={"{0:x}" -f $_.PortWorldWideName}}

}

$report333 | Export-csv  -Path C:\Users\gemela\Desktop\WWNTECO.csv –NoTypeInformation

And I get this format: "200024827aaf84f2","1000289et53f84f2"

Is possible to get format like: 20:00:28:22:4a:af:84:f3 10:10:28:02:4a:af:84:f2

Thanks

[LucD]

Try like this

$wwn = "200024827aaf84f2"

(0..7 | %{$wwn.Substring($_*2,2)}) -join ':'

[antoniogemelli]

Hi LucD,

Is possible to include in the script to get directly in csv file with this format?

[LucD]

Try like this

$cluster = Get-Cluster

$hosti = $cluster | Get-VMHost

$report333 = foreach ($esxi in $hosti) {

    Get-VMHosthba -VMHost $esxi -type FibreChannel |

    Select  @{N="Host";E={$esxi.Name}},

        @{N='HBA Node WWN';E={$wwn = "{0:X}" -f $_.NodeWorldWideName; (0..7 | %{$wwn.Substring($_*2,2)}) -join ':'}},

        @{N='HBA Node WWP';E={$wwp = "{0:X}" -f $_.PortWorldWideName; (0..7 | %{$wwp.Substring($_*2,2)}) -join ':'}}

}

$report333 | Export-csv  -Path C:\Users\gemela\Desktop\WWNTECO.csv –NoTypeInformation

[antoniogemelli]

Script looks like works, but I got wrong WWN/WWP.

[LucD]

Oops, I forgot the conversion to hex.

The code above is updated

[antoniogemelli]

Perfect, it work

Thanks a lot LucD.

[falconbuban]

Thank you Luc. script worked perfectly!

[Muchemi]

This is a great Script. Is it possible to filter for HBAs that are online?

[LucD]

Try like this

$cluster = Get-Cluster

$hosti = $cluster | Get-VMHost

$report333 = foreach ($esxi in $hosti) {

    Get-VMHosthba -VMHost $esxi -type FibreChannel | where{$_.STatus -eq 'online'} |

    Select  @{N="Host";E={$esxi.Name}},

        @{N='HBA Node WWN';E={$wwn = "{0:X}" -f $_.NodeWorldWideName; (0..7 | %{$wwn.Substring($_*2,2)}) -join ':'}},

        @{N='HBA Node WWP';E={$wwp = "{0:X}" -f $_.PortWorldWideName; (0..7 | %{$wwp.Substring($_*2,2)}) -join ':'}}

}

$report333 | Export-csv  -Path C:\Users\gemela\Desktop\WWNTECO.csv –NoTypeInformation

[Muchemi]

Thanks LucD,

Works like Charm!

[Ankushsethi]

Could you please suggest what does -f mean and when we use this 

[LucD]

That is the format operator, it is used to format string output

[Ankushsethi]

thank you Luc

[nikhilbabu]

I tried the script it worked, but it didn't give me the hba name, it just gave me the wwpn, could you please help me here

[LucD]

Just add the Name on the Select-Object

$cluster = Get-Cluster
$hosti = $cluster | Get-VMHost
$report333 = foreach ($esxi in $hosti) {
    Get-VMHosthba -VMHost $esxi -type FibreChannel | where{$_.Status -eq 'online'} |
    Select  @{N="Host";E={$esxi.Name}},
        Name,
        @{N='HBA Node WWN';E={$wwn = "{0:X}" -f $_.NodeWorldWideName; (0..7 | %{$wwn.Substring($_*2,2)}) -join ':'}},
        @{N='HBA Node WWP';E={$wwp = "{0:X}" -f $_.PortWorldWideName; (0..7 | %{$wwp.Substring($_*2,2)}) -join ':'}}
}

$report333 | Export-csv  -Path C:\Users\gemela\Desktop\WWNTECO.csv –NoTypeInformation