nested foreach loop powershell

Question

I have exports from two systems in two separate csv files.

These files contain a lot of different data but just to keep the question simple let's say one of them contains the email and username and the other one contains mobile numbers and email.

What I want to do is run a foreach loop that updates an attribute in the ad and within the loop run an another foreach loop to update the mobile number in the ad.

How can I match the email from the first list in the second nested foreach loop and get the row?

The script I already wrote:

    $users = import-csv -path C:\temp\list1.csv
    $users2 = import-csv -path c:\temp\list2.csv

    Foreach ($user in $users) {
        try {
            $aduser = get-aduser -Filter "mail -eq '$($user.mail)'" -properties *
        }
        catch {
            $aduser = $null
            Write-host "No aduser found"
            Continue
        }
        if ($user.username -ne $aduser.EmployeeID) {
            set-aduser $aduser -EmployeeID $user.username
        }
        Foreach ($user2 in $users2) {
            if ($user.mobile -ne $aduser.mobile) {
                set-aduser $aduser -MobilePhone $user.mobile
        }
    }

Ivan Mirchev · Accepted Answer · 2020-06-12 13:33:16Z

I do not have the content of the files, so improvising a bit, but hopefully you'll get the idea. Why you need a second loop? I assume that the e-mail address is the unique identifier in both files? Then you may loop the first one, to get each ad user details and based on the mail, search in the second file, to get the phone and add it. For example

$users = import-csv -path C:\temp\list1.csv
$users2 = import-csv -path c:\temp\list2.csv

# loop the users
Foreach ($user in $users) {
    try {
        #get ad user details and check if existing
        $aduser = get-aduser -Filter "mail -eq '$($user.mail)'" -properties *

        # Get the mobile from the second list, using the mail from the current loop
        $Mobile = ($users2 | Where-Object -Property Mail -eq $user.mail)

        # Set EmployeeID
        if ($user.username -ne $aduser.EmployeeID) {
            set-aduser $aduser -EmployeeID $user.username
        }

        #Set Mobile
        if ($Mobile -ne $aduser.mobile) {
            set-aduser $aduser -MobilePhone $Mobile
        }
    }
    catch {
        $aduser = $null
        Write-host "No aduser found"
        Continue
    }
}

What do you think about that as a scenario?

Thanks, didn't have to be a second loop but couldn't figure out how to pull the object from the other file. this works great with email as an identifier. nice!

Collectives™ on Stack Overflow

nested foreach loop powershell

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related