Forum Discussion
sany98
May 07, 2021Copper Contributor
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,...
- 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
May 08, 2021Copper Contributor
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
May 08, 2021Copper Contributor
Got it! 🙂
$UserName="User1"
Set-ADUser -id $UserName -Replace @{EmployeeID=(Get-ADUser $UserName -Properties employeenumber).EmployeeNumber}
Set-ADUser -id $UserName -EmployeeNumber $null
$UserName="User1"
Set-ADUser -id $UserName -Replace @{EmployeeID=(Get-ADUser $UserName -Properties employeenumber).EmployeeNumber}
Set-ADUser -id $UserName -EmployeeNumber $null