Compare 2 arrays with powershell

Question

I have 2 Arrays $UsersGroup and $UsersActive, i need to find where in $UsersActive i have a line with SamAccountName and the ObjectGUID .

$UsersGroup =

SamAccountName ObjectGUID
-------------- ----------
XXXX00XX       0031e949-9120-4df1-bddb-98067a141448
XXXX01XX       0031e949-9120-4df1-bdgb-99067a141448
XXXX02XX       0031e949-9120-4df1-bdab-97067a141448

and without headers

$UsersActive =

fcb483fa146b
fcb515739a2f
fcb82f1ef74c
fcc5ee8b8722
fcd3f1f471c2
fceb26a598a3
fd0b14cecd0e
98067a141448

I need to have the match user from $UsersActive to $UserGroup.Object like that

$UsersGroup | ForEach-Object {if($_.ObjectGUID -contains $UsersActive) {$_}}

But i don't get the result like that :

XXXX00XX 0031e949-9120-4df1-bddb-98067a141448

Can some one help me , thanks !

$UsersGroup.Where{ $UserActive -Match $_.ObjectGUID.ToString() }? — iRon
– iRon, Commented Aug 31, 2022 at 13:06
Misunderstanding of -contains vs .contains() is common, aside from $UsersActive being an array. — js2010
– js2010, Commented Jan 28, 2023 at 17:24

Mathias R. Jessen · Accepted Answer · 2022-08-31 13:06:08Z

1

-contains is a collection containment operator, testing for the exact occurrence of the right-hand side argument in the left-hand side argument.

To test for the presence of a substring in a string, use the -like wildcard string comparison operator:

$UsersGroup | Where-Object {
    $guid = $_.ObjectGUID
    $UsersActive.Where({$guid -like "*$_*"}, 'First')
}

Each group entry will now be tested against every $UsersActive value until a match is found (causing Where-Object to pass the object through) or no match is found (causing Where-Object to filter out the object)

answered Aug 31, 2022 at 13:06

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

3 Comments

Raphael Guillaume Over a year ago

Super thank you very much !!!! If i want a notlike , tried : $UsersGroup | Where-Object { $guid = $_.ObjectGUID $UsersActive.Where({$guid -notlike "*$_*"}) but i have all content of $UserGroup :'( }

Mathias R. Jessen Over a year ago

@RaphaelGuillaume You mean the inverse? All objects where no match was found for the GUID in $UsersActive? Just prefix the $UsersActive.Where({...}) expression with -not: -not $UsersActive.Where({$guid -like "*$_*"}, 'First')

Mathias R. Jessen Over a year ago

@RaphaelGuillaume You're most welcome! If my answer solves your problem, please consider marking it "accepted" by clicking the checkmark on the left :)

js2010 · Accepted Answer · 2022-08-31 17:26:16Z

0

If I understand you correctly, using compare-object... This has only one match. Compare-object can be slow for large lists.

$usersgroup = 
'SamAccountName,ObjectGUID
XXXX00XX,0031e949-9120-4df1-bddb-98067a141448
XXXX01XX,0031e949-9120-4df1-bdgb-99067a141448
XXXX02XX,0031e949-9120-4df1-bdab-97067a141448' | convertfrom-csv

$usersactive = -split
'fcb483fa146b
fcb515739a2f
fcb82f1ef74c
fcc5ee8b8722
fcd3f1f471c2
fceb26a598a3
fd0b14cecd0e
98067a141448'

compare ($usersgroup.objectguid -replace '.*-') $usersactive -IncludeEqual |
  ? sideindicator -eq '=='  # order doesn't matter


InputObject  SideIndicator
-----------  -------------
98067a141448 ==

edited Aug 31, 2022 at 17:26

answered Aug 31, 2022 at 16:42

js2010

28.4k6 gold badges82 silver badges88 bronze badges

Comments

mklement0 · Accepted Answer · 2023-01-28 17:06:57Z

To offer an alternative solution:

As Mathias states in his answer, the -contains operator and its operands-reversed counterpart, -in, only perform equality comparison of a single comparison value against the elements of a collection (array).

As an aside: Given that $_.ObjectGUID is the scalar (single object) and $UsersActive the collection (array) to search in, you would have needed to use -in, not -contains ($_.ObjectGUID -in $UsersActive)

Unfortunately, as of version 7.3.2, PowerShell's pattern-matching operators, -like (with wildcard expressions) and -match (with regexes), do not support matching against multiple (an array of) patterns.

However, since you're looking to match a literal substring of each .ObjectGUID value, you can use -in if you extract that relevant substring first and use it as the comparison value:

# -> Object whose GUID is '0031e949-9120-4df1-bddb-98067a141448'
$usersGroup | Where-Object { ($_.ObjectGUID -split '-')[-1] -in $usersActive }

Note how the -split operator is used to split the GUID into tokens by -, with [-1] returning the last token, which -in then looks for by equality comparison in the $UsersActive array.

As an aside:

Allowing multiple patterns as the RHS of -like and -match - so as to return $true if any of them match - would be a helpful future improvement.
GitHub issue #2132 asks for just that.

Collectives™ on Stack Overflow

Compare 2 arrays with powershell

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related