Forum Discussion

Copper Contributor

May 07, 2021

Solved

Move records from one attribute to another

Hi all, I need to move the records from employeeNumber field to the employeeID field. I would like to run test on one single user and then on whole OU. Is this doable and how? I'm still learning,...

Windows PowerShell

farismalaeb
May 08, 2021
sany98
Yes, everything is doable in PowerShell
You will get ADUser with the employeeNumber and then set it to the employeeID
$UserName="User1" Set-ADUser -id $UserName -Replace @{EmployeeID=(Get-ADUser $UserName -Properties employeenumber).EmployeeNumber}

Iron Contributor

May 08, 2021

Yes, everything is doable in PowerShell
You will get ADUser with the employeeNumber and then set it to the employeeID

$UserName="User1"
Set-ADUser -id $UserName -Replace @{EmployeeID=(Get-ADUser $UserName -Properties employeenumber).EmployeeNumber}

sany98
Copper Contributor
May 11, 2021
farismalaebHow do I Get-ADUser from specific OU? I've tried to use - SearchBase but it's throwing me an error. (Get-ADUser $UserName -Properties - SearchBase ''......)
- SteveMacNZ
  Iron Contributor
  May 11, 2021
  sany98
  there is no space between the - and SearchBase
  Get-ADUser -SearchBase $SearchBase
  - sany98
    Copper Contributor
    May 12, 2021
    SteveMacNZ
    
    @SteveMacNZ
    Sorry, it was a typo. There is no space between the - and SearchBase but the error is still there.
    Set-ADUser -id $UserName -Replace @{EmployeeID=(Get-ADUser $UserName -SearchBase 'OU=ex,OU=t2,DC=t3,DC=t4' -Properties employeenumber).EmployeeNumber}
sany98
Copper Contributor
May 08, 2021
Thank you! farismalaeb
It copies the record from EmployeeID field to EmployeeNumber field but it doesn't remove it from EmployeeID. Can I run -Remove with the same script?
- sany98
  Copper Contributor
  May 08, 2021
  Got it! 🙂
  $UserName="User1"
  Set-ADUser -id $UserName -Replace @{EmployeeID=(Get-ADUser $UserName -Properties employeenumber).EmployeeNumber}
  Set-ADUser -id $UserName -EmployeeNumber $null

Resources