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, so any help is appreciated.

sany98 Yes, everything is doable in PowerShellYou 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}

Move records from one attribute to another

11 Replies

farismalaeb
Steel Contributor
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}
- 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 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

Forum Discussion

Move records from one attribute to another

11 Replies

Resources