Import SharePoint Security Group Members

How to Sync Active Directory Group Members with SharePoint Security Groups

Step 1:Connect Data Source A to Active Directory

In this example we use a LDAP Filter to return only those users of a specific AD group, for example:
(&(objectClass=User)(memberOf=CN=SharePoint Team Users,CN=Users,DC=corp,DC=litware,DC=inc))

Connect to Source

Step 2: Connect Data Source B to the Microsoft SharePoint Security Groups provider

Choose the SharePoint Group to synchronise from the dropdown.

Connect to Target

Step 3: Map the Fields

Adjust the schema map like this so that the AD Account Name is mapped to Login name and Display Name is mapped to Name. Account Name should be the Key Column.

Schema Map

Your completed project will look like this.


Step 4: Compare the Ad with SharePoint

Run a Compare A to B which will show the differences and you can now synchronise the member lists.

Compare A to B

And now after synchronisation in SharePoint the Group Members is populated.


Now that the users have been correctly added to SharePoint you can also setup a standard SharePoint List sync with the User Information List to populate other meta data from AD into SharePoint.

Can't find the answers you're looking for? Contact our support team and we'll personally get back to you as quickly as we can.