Knowledge Base

How to sync user profile from Active Directory to SharePoint user information list?

The user information list is a hidden list in each SharePoint site collection, it stores properties information about a user. Whenever you add an AD user into a site collection, some attributes about the AD user will be stored in the user information list.

With AD Information Sync, you can map the attributes about the user in Active Directory to the columns in the user information list in SharePoint and sync these properties’ values to the list. Even better, if you change the user profile in Active Directory, the changes can be synced to the user information list automatically.

In this article we will demonstrate how to sync user information from AD to user information list.

WHAT YOU'LL GET

The users’ profiles have been synced from AD to the user information list.

WHAT YOU'LL NEED

The sample data we use for this case

And we have 6 users in the Active Directory.

Sync user profile to a SharePoint user information list

  1. Download the trial version of AD Information Sync and install it to your SharePoint server.

  2. Navigate to the root site of the site collection.

  3. In the upper right corner, click Settings and then click Site Settings.

  4. On the Site Settings page, click AD Information Sync settings under BoostSolutions Software section in the bottom right corner of the page.

  5. On the AD Information Sync Settings page, click Create Profile to create a new profile, specify a unique name for it.

  6. In the List section, select the SharePoint list to which we will synchronize the information from Active Directory. Select user information list from the dropdown list.

  7. 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.

  8. In the Filter section, specify the information you want to synchronize. Specify the object type as User.

  9. In the Column Mapping section, map the AD attributes to the SharePoint list columns as following.

  10. Keep other settings as default and click OK to save the settings for the profile.

  11. On the AD Information Sync Settings page, click Sync Now for the profile we created.

  12. 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.

  13. Wait for a few seconds for the synchronization to be completed.

    Navigate to the User Information list and you will find that those 6 user have been synced from Active Directory to the SharePoint list as following.

  14. Check details of any of these users such as Mike Miller, the profile of Mike Miller has been synchronized from Active Directory to the Employee Info list as following.

Login