Updating Updating Active Directory Manager Attribute using PS from a CSV File

Question

I'm trying to update the AD manager field using PS. We we're given a CSV file from HR with everyone's manager info. This is PS script.

Import-Module ActiveDirectory
$Users = Import-Csv "C:\Users\Administrator.APC-SERVICES\Desktop\mngimport\Managers1.csv"
ForEach ($User in $User)
{
$ADUser = Get-ADUser -Filter "displayname -eq '$($User.ProfessionalFullName)'"
$manager = (Get-ADUser -Filter "displayname -eq '$($User.'ManagerFullName')'").distinguishedname

if ($ADUser -and $manager) {
Set-ADUser -Identity $ADUser -Replace @{manager = $manager }
}
}

Nothing happens after running this. I keep checking the AD Users and the Manager attribute does not update. What am i missing?

CSV format:
ProfessionalFullName,ManagerFullName
Greg Brown,Jay Smith
Jesus Lopez ,Jay Smith
Stephen Jones,Jay Smith
Scott Williams ,Roy Miller
Jason Davis,Roy Miller

Answer 1

Try it this way:

Import-Csv "C:\Users\Administrator.APC-SERVICES\Desktop\mngimport\Managers1.csv" |
    ForEach-Object {
        $ADUser  =  Get-ADUser -Filter "displayname -eq '$($_.ProfessionalFullName)'"
        $manager = (Get-ADUser -Filter "displayname -eq '$($_.ManagerFullName)'").distinguishedname

        if ($ADUser -and $manager) {
            $ADUser | Set-ADUser -manager $manager
        }
    }

Two things:

1. You don't have to explicitly import the ActiveDirectory module. PowerShell (since version 3) will do that automatically.
2. Using the DisplayName to identify users is a little bit risky since a display name may not be unique in the AD forest. A samaccountname or primary email address is much better

Answer 2

Hey,

Is look like half of my users failed to updated. I modified it for "sAMAccountName" and the "Name".

This is what I'm running:

Import-Csv "C:\Users\Administrator.APC-SERVICES\Desktop\mngimport\managers.csv" |
ForEach-Object {
$ADUser = Get-ADUser -Filter "Name -eq '$($.Name)'"
$manager = (Get-ADUser -Filter "sAMAccountName -eq '$($.sAMAccountName)'").distinguishedname
}
if ($ADUser -and $manager) {
$ADUser | Set-ADUser -manager $manager
}

CSV File:
Name,sAMAccountName
Dipal Smith,VBell
Dolly Ryan,VBell

Any thoughts?