Powershell Comparing two object properties

Question

Loaded two JSON files with Get-Content filename.JSON | ConvertFrom-Json

One object name $SubscriberEmail has the property name email

The second object name $ADEnabledUsersEmail has a property named Work Email

Trying to compare both objects and find the ones, not in the $ADEnabledUsersEmail object and Write-Out the name.

Here is the current foreach method but seems to output all the emails multiple times.

foreach($S in $SubscriberEmail ){
    foreach($A in $ADEnabledUsersEmail){
        if($A.'Work Email' -eq $S.email ){
            Write-Host "User is active"
        }else{
            Write-Host $s.email
        }
    }
}

Santiago Squarzon · Accepted Answer · 2021-11-01 05:29:48Z

2

If you want to filter an array you can use Where-Object or .Where() method or a loop with the right comparison operator. i.e.: -notin, -notcontains:

$SubscriberEmail.email.where({ $_ -notin $ADEnabledUsersEmail.'Work Email' })

$SubscriberEmail | Where-Object {
    $ADEnabledUsersEmail.'Work Email' -notcontains $_.email
}

foreach($email in $SubscriberEmail.email)
{
    if($email -notin $ADEnabledUsersEmail.'Work Email')
    {
        $email
    }
}

There are many more options to filter arrays, just search filtering arrays powershell on Google.

edited Nov 1, 2021 at 5:29

answered Nov 1, 2021 at 5:14

Santiago Squarzon

65.8k5 gold badges26 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

Powershell Comparing two object properties

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related