Update Manager Attribute on AD by Importing CSV file

Question

Hello,

How can I update the reporting manager attribute on AD based on the user's email address / UserPrincipalName instead of the user's name.

I have seen some examples online but still a bit confuse. Appreciate some help. Thank you !

CSV file sample
UserEmail ManagerFullname
john@keyman .com Tim Wang

Answer 1

Hello,

You can do it what you will have to do is:

1. Search for the manager user based on the email address
2. Modify the target user manager with the previously user object you get from 1

Below an example :

$CSV = Import-Csv -path Example_csv.csv -Delimiter ";"  
foreach($line in $CSV) {  
    $Manager = Get-ADUser -LDAPFilter "(mail=$($line.UserEmail))"  
    Set-ADUser xxx -Manager $Manager  
}  

My CSV look like this :
UserEmail;ManagerFullname
john@keyman .com;Tim Wang

Regards,

Answer 2

$CSV = Import-Csv -Path Example_csv.csv -Delimiter ";"
foreach($line in $CSV) {
    $Manager = Get-ADUser -Filter "Name -like '$($line.ManagerFullname)'"
    $TargetUser = Get-ADUser -Filter "UserPrincipalName -like '$($line.UserEmail)'"
    if(@($Manager).Count -lt 2) {
        Set-ADUSer $TargetUser -Manager $Manager
    } else {
        Write-Output "More than 1 user exist with this name $($line.ManagerFullname)"
    }
}

I posted it here to have the actual answer