How to sync hidden or unusual attributes in Active Directory to a SharePoint list | SharePoint AD Information Sync - BoostSolutions App, Saas & Software for Microsoft 365, Microsoft Teams, SharePoint

How to sync hidden or unusual attributes in Active Directory to a SharePoint list?

When you sync the user information from Active Directory to a SharePoint list using AD Information Sync, besides the attributes in ADUS tabs (General, Address, Account, Telephone and Organization), you can also sync those hidden or unusual attributes to SharePoint list, such as birthday, room number, mailNickname, etc.

In this article, we will demonstrate how to sync those attributes to the SharePoint list.

WHAT YOU'LL GET

The attributes of user objects are synced to the Employees list from Active Directory.

WHAT YOU'LL NEED

AD Information Sync

The sample data we use for this case

And there are 6 users in the Active Directory as following.

Sync hidden or unusual attributes 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 Employees 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 Employees 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, specify the information you want to synchronize. Specify the object type as User.
In the Column Mapping section, follow the steps below to map the AD attributes to the SharePoint list columns.

Because the corresponding name of the attribute for Alias in the Active Directory (which is mailNickname) is not available in the drop-down list of AD Attribute, select Enter an AD attribute from the drop-down list firstly.

When the textbox appears, type the attribute’s name mailNickname in the textbox as following.

Repeat these two steps above, fill other missing attributes’ names in the AD Attribute section as following.

You can also map and sync more AD attributes to SharePoint list columns; AD Information Sync supports almost all active directory attributes. For more details, please refer to the AD Information Sync User Guide.
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 Employees list and you will find that those 6 users in the Active Directory have been imported to the SharePoint list with corresponding attributes as following.