How to move OU members into other OU based on sAMaccountname or other attribute

Question

How to move OU members into other OU based on sAMaccountname or other attribute

Eaven Huang 1,786

Dear friend,

We have an OU containing around 1000+ members and we will need to create sub-OU to separate them. We will create 10 sub-OUs and move them into different ones. I have an excel list containing the members' E-mail, sAMAccountName, can we do this in bulk based on their E-mail field or sAMAccountName attribute?

Many thanks in advance for any assistance.

Answer 1

Ian Xue (Shanghai Wicresoft Co., Ltd.) 18,766 Microsoft Vendor

Hi，

You can create a script to do this. The Move-ADObject cmdlet moves an AD object to a specific container.

$sAMAccountName = "someuser"  
$ou = "OU=test,DC=contoso,DC=com"  
Get-ADUser -Identity $sAMAccountName | Move-ADObject -TargetPath $ou

https://learn.microsoft.com/en-us/powershell/module/activedirectory/move-adobject

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Eaven Huang 1,786 Reputation points

2021-07-01T09:17:45.897+00:00

Hi Ian,

Thanks for the information, I was looking for the same:) Is there anyway that we can read the sAMAccountName from .csv instead of putting all of them into the PS script?
Ian Xue (Shanghai Wicresoft Co., Ltd.) 18,766 Reputation points Microsoft Vendor

2021-07-01T09:35:11.587+00:00
If the list is a CSV file you can use the Import-Csv cmdlet to read it. Assudming the header of the column is "sAMAccountName", you can get the sAMAccountName like below

$file = "C:\temp\list.csv" (Import-Csv -Path $file).sAMAccountName
Eaven Huang 1,786 Reputation points

2021-07-02T05:57:13.103+00:00

Many thanks Ian!

I was also referring to this link https://www.alitajran.com/bulk-move-ad-users-to-another-ou-with-powershell/ and I think it's the same as your reply:)

How to move OU members into other OU based on sAMaccountname or other attribute

0 additional answers

Activity