How to populate the manager field on Active Directory, using powerShell

Question

Im trying to populate the manager fields on AD using

Import-Csv C:\Testimport.csv | ForEach-Object {Set-ADUser -Identity $_.samAccountName -Replace @{Manager=$_.manager}}

But I get the following error:

Set-ADUser : Cannot bind parameter 'Replace' to the target. Exception setting " Replace": "Object reference not set to an instance of an object." At line:1 char:95 + Import-Csv C:\Testimport.csv | ForEach-Object {Set-ADUser -Identity $.samAcc ountName -Replace <<<< @{manager=$.manager}} + CategoryInfo : WriteError: (:) [Set-ADUser], ParameterBindingEx ception + FullyQualifiedErrorId : ParameterBindingFailed,Microsoft.ActiveDirectory
.Management.Commands.SetADUser

Have you tried anything to solve this issue so far?

Aleksander Lidtke
– Aleksander Lidtke

2014-10-18 13:34:15 +00:00
Commented Oct 18, 2014 at 13:34 — Aleksander Lidtke
– Aleksander Lidtke, Commented Oct 18, 2014 at 13:34

Matt · Accepted Answer · 2014-10-18 14:20:34Z

1

Depending on what the Manager is represented by in your csv you can just use the Set-Aduser parameter -Manager on its own.

Import-Csv C:\Testimport.csv | ForEach-Object {Set-ADUser -Identity $_.samAccountName -Manager $_.manager}

If not please show some sample date in your question. This would work in Manager was a account name at least. Also there is an error in the code you ran: manager=$.manager should be manager=$_.manager

edited Oct 18, 2014 at 14:20

answered Oct 18, 2014 at 13:30

Matt

47k9 gold badges90 silver badges125 bronze badges

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

Comments

Ramiro Encinas · Accepted Answer · 2020-05-01 16:31:34Z

1

If $_.manager is the Manager sAMAccountName attribute, you need the distinguidhedName attribute to use it later as a value into -Replace parameter:

Import-Csv C:\Testimport.csv | 

ForEach-Object {

    $managerDN = (Get-ADUser $_.manager).distinguishedName

    Set-ADUser -Identity $_.samAccountName -Replace @{Manager=$managerDN}
}

answered May 1, 2020 at 16:31

Ramiro Encinas

1717 bronze badges

Collectives™ on Stack Overflow

How to populate the manager field on Active Directory, using powerShell

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related