How to sync users from specific OU in Active Directory to a SharePoint list | SharePoint AD Information Sync - BoostSolutions App, Saas & Software for Microsoft 365, Microsoft Teams, SharePoint

How to sync users from specific OU in Active Directory to a SharePoint list?

An organization unit (OU) is a container within Active Directory which can hold users, contacts and computers. Your company may create several different OUs to organize and manage users.

AD Information Sync also supports to sync or import users, contacts or computers from specific OUs to a SharePoint list.

In this article we will demonstrate how to sync users from specific OU to a SharePoint list.

WHAT YOU'LL GET

Select the specific OU in Active Directory to sync users contained to a SharePoint list

WHAT YOU'LL NEED

AD Information Sync

The sample data we use for this case

And we have 3 users in the Organizational Unit (OU) IT in the Active Directory as following.

Sync users from specific OU in Active Directory to a SharePoint list

Download the trial version of AD Information Sync and install it to your SharePoint server.
Navigate to the site in which the Employee Info list is located.
In the upper right corner, click Settings and then click Site Settings.
On the Site Settings page, click AD Information Sync settings under BoostSolutions Software section in the bottom right corner of the page.
On the AD Information Sync Settings page, click Create Profile to create a new profile, specify a unique name for it.
In the List section, select the SharePoint list to which we will synchronize the information from Active Directory. Select Employee Info list from the dropdown list.
In the Active Directory section, specify a domain server and user credentials to connect to the domain server (Ensure the user account you specify has the appropriate permissions to access the domain server). Then click Connect. If everything goes right, it will show Connection attempt successful under the Connect button. If things went wrong, please check the user account you specified, make sure it has the permissions required.
In the Filter section, check the checkbox of Filter by Organizational Unit option.

Then the OU tree will be expanded as following, you can select the desired OU/OUs by checking the checkbox before the name of the OU. Here we select IT.

Also, in the Filter section, specify the object type as User.
In the Column Mapping section, map the AD attributes to the list columns as following.
Keep other settings as default and click OK to save the settings for the profile.
On the AD Information Sync Settings page, click Sync Now for the profile we created.
A confirmation message will appear to remind you that the synchronization will modify data in Active Directory or the SharePoint list of this profile. Click OK to start the synchronization.
Wait for a few seconds for the synchronization to be completed.

Navigate to the Employee Info list and you will find that the 3 users contained in the Organizational Unit (OU) IT have been synced to the SharePoint list successfully as following.

Note that you can also sync computer or contact objects from specific OU with the same steps as what we did for the user object, the only difference is selecting Computer or Contact as the Object Type in the Filter section.