Select specific values from an array within an array

Question

I am querying my storage array to gather properties for initiators. Here is the code:

$global:Xtrem_HBA_list = @()
$global:Xtrem_HBA_list += Get-XtremInitiators -Properties name,port-address,ig-id
$Write-Host $global:Xtrem_HBA_list

This returns

name                 port-address             ig-id
----                 ------------             -----
comp-esxi-01_vmhba2  10:00:00:90:fa:53:f4:60  {c832425d03f84644be37ae3d4e49186c, comp-esxi-01, 1}
comp-esxi-01_vmhba3  10:00:00:90:fa:53:f4:61  {c832425d03f84644be37ae3d4e49186c, comp-esxi-01, 2}

My problem is that I need $global:Xtrem_HBA_list to contain the value from name, port-address and the second value from ig-id (comp-esxi-01). I am having difficulty extracting the value from the array within the array.

Thanks to Matt! I updated my code and got the exact output I was looking for.

$global:Xtrem_HBA_list = @()
$global:arr_HBAs = @()
$global:Xtrem_HBA_list += (Get-XtremInitiators).name
foreach ($i in $global:Xtrem_HBA_list){
    $global:arr_HBAs += Get-XtremInitiator -InitiatorName $i | Select name,port-address,@{Name="ig-id";Expression={($_."ig-id")[1]}}
}

Will it always be the second value?

Matt
– Matt

2016-01-13 02:57:34 +00:00
Commented Jan 13, 2016 at 2:57 — Matt
– Matt, Commented Jan 13, 2016 at 2:57

Matt · Accepted Answer · 2016-01-13 05:22:33Z

2

Couple basic ways to get this.

A loop that extracts the value from the array at every pass.
A loop that uses Add-Member to create another property that 'extracts' the information and use Select to pull that column.
Using a calculated property that will output the ig-id column but with only the second value from your array. This one is also easier as it will let us use the same name.

I'm opting for the latter suggestion. I am not using write-host on purpose here as it will just go to the output stream by default whereas write-host will just go to console

$global:Xtrem_HBA_list |  Select name,port-address,@{Name="ig-id";Expression={($_."ig-id")[1]}}

Note that if there is less than two elements a null will be returned. In that same scenario it could generate an error depending on your strict mode. Your mileage will vary but you can easily harden that with some if statements if need be.

edited Jan 13, 2016 at 5:22

answered Jan 13, 2016 at 3:03

Matt

47k9 gold badges90 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

E.V.I.L. Over a year ago

Great idea using a calculated property! I forgot about those. $global:Xtrem_HBA_list | % {[PSCustomObject]@{Name=$_.Name;PortAddress=$_."port-address";IGID=$_."ig-id"[1]}}

Matt Over a year ago

@MadTomVane Only thing I have to say about that is it seems odd to make a whole new object when you only need to change/add the one property. Not sure if there a performance trade off at some point.

Collectives™ on Stack Overflow

Select specific values from an array within an array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related