PowerShell hashtable filtering values in array

Question

File : https://drive.google.com/file/d/10GAlcA9PI-mFHUmACvC5CPbzjl3QLrwJ/view?usp=sharing

$data = import-csv .\vDisk.csv |where 'raw lun id' -NotLike ''|Group-Object -Property VM -ashashtable

I have vdisk extracted from rvtools and trying to group shared RDM by VM name, the output of the code is:

Name                           Value
----                           -----
MGTMKS1112M                    {@{VM=MGTMKS1112M; Powerstate=poweredOff; Template=False; Disk=Hard disk 7; Capacity MB=150; Raw=True; Disk Mode=independent_persistent; Thin=; Eagerly Scrub=; Split=; Wri...
PRDSKM1111M                    {@{VM=PRDSKM1111M; Powerstate=poweredOff; Template=False; Disk=Hard disk 5; Capacity MB=1,024; Raw=True; Disk Mode=independent_persistent; Thin=; Eagerly Scrub=; Split=; W...
MGTMKS1111M                    {@{VM=MGTMKS1111M; Powerstate=poweredOff; Template=False; Disk=Hard disk 11; Capacity MB=150; Raw=True; Disk Mode=independent_persistent; Thin=; Eagerly Scrub=; Split=; Wr...
PRDSKM1112M                    {@{VM=PRDSKM1112M; Powerstate=poweredOff; Template=False; Disk=Hard disk 5; Capacity MB=1,024; Raw=True; Disk Mode=independent_persistent; Thin=; Eagerly Scrub=; Split=; W...

I want the the output like below ashashtable or grouped object. because two nodes share the same raw lun ids. if this approach cant work. any alternate methods? please advice.


Name                      Value
----                      -----
MGTMKS1112M,MGTMKS1111M   {@{VM=MGTMKS1112M; Powerstate=poweredOff; Template=False; Disk=Hard disk 7; Capacity MB=150; Raw=True; Disk Mode=independent_persistent; Thin=; Eagerly Scrub=; Split=; Wri...
PRDSKM1112M,PRDSKM1112M   {@{VM=PRDSKM1112M; Powerstate=poweredOff; Template=False; Disk=Hard disk 5; Capacity MB=1,024; Raw=True; Disk Mode=independent_persistent; Thin=; Eagerly Scrub=; Split=; W...

Daniel · Accepted Answer · 2021-02-15 09:39:58Z

1

You may provide a custom property to Group-Object in which to group on

$data = import-csv .\vDisk.csv |where 'raw lun id' -NotLike ''
$data | Group-Object -Property { $sub = $_.vm.substring(0,9); ($data.vm -match $sub |  Select-Object -Unique | Sort-Object) -join ", "} -ashashtable

Output something like this

    Name                     Value
----                     -----
MGTMKS1111M, MGTMKS1112M {@{VM=MGTMKS1111M; Powerstate=poweredOff; Template=False; Disk=Hard disk 11; Capacity MB=150; Raw=True; Disk Mode=independent_persistent; Thin=; Eagerly Scrub=; Split=; Write Through=; Level=normal; Shares=1,000; Reservation=0; L...
PRDSKM1111M, PRDSKM1112M {@{VM=PRDSKM1111M; Powerstate=poweredOff; Template=False; Disk=Hard disk 5; Capacity MB=1,024; Raw=True; Disk Mode=independent_persistent; Thin=; Eagerly Scrub=; Split=; Write Through=; Level=normal; Shares=1,000; Reservation=0; ...

edited Feb 15, 2021 at 9:39

answered Feb 15, 2021 at 7:30

Daniel

5,1422 gold badges9 silver badges25 bronze badges

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

9 Comments

shaik abdul Over a year ago

The name got trimmed because of substring (0..9). any other way i can have the duplicate reference name? Ex: MGTMKS1112M as duplicate ref for MGTMKS1111M. otherwise both in comma separated as single string. also i will need to enumerate the values later in function.

shaik abdul Over a year ago

any other way, i can filter by VM and compare its values? main key is Raw lun mapping matching to VM name.

Daniel Over a year ago

Updated my answer. Try that.

shaik abdul Over a year ago

the above code output is different than your output is shown. can help to check.

Daniel Over a year ago

Sorry, didn't have access to your csv file before. Updated once more to remove the duplicates by adding Select-Object -Unique

|

Collectives™ on Stack Overflow

PowerShell hashtable filtering values in array

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related