Profiles synchronization from PowerShell

Share on print
Share on facebook
Share on linkedin
Share on whatsapp
Share on email

As an administrator, you can force a user profile synchronization with the following steps. The synchronization can get users from AD group, .csv file, UPS (only WSP) or Beezy DB and sync (add or update) them with fresh UPS information to Beezy DB.

Depending on your installation model:

WSP Beezy Release Package

  1. From a WFE
  2. Run Powershell as administrator
  3. Browse to “Deployment files” folder

Add-in Beezy Release Package

  1. Unzip “Script_Credentials.zip”
  2. Run Powershell as administrator
  3. Browse to the unzipped folder

Once you are in the right folder, steps are the same:

Execute the following script:

.beezy-SyncUsers.ps1 -SiteCollectionUrl <beezy-sitecollection_url> [-ADGroup <groupname>] [-CsvFile <filepath>] [-UPS]

Mandatory parameters:

  • <beezy-sitecollection_url>: Beezy site collection URL.

Optional parameters (source):

  • -ADGroup <groupname>: specify the AD group name if you want to sync users from an AD group to Beezy DB.
  • -CsvFile <filepath>: specify the path of a .csv file if you want to sync users from an AD group to Beezy DB.
  • -UPS: if you want to import and synchronize ALL existing users in UPS (it will import service accounts and all accounts from UPS) (only works for WSP)

If no source is specified, the source will be the Beezy database itself.

Format .csv file:

On-premises (header ‘username’ is required)
——————
username
domainuser1
domainuser2
domainuser3
——————

Cloud (header ‘username’ is required)
——————
username
user1@domain.com
user2@domain.com
user3@domain.com
——————

Examples:

Add members from Beezy database:

.beezy-SyncUsers.ps1 -SiteCollectionUrl http://portal.b13qa.local

.beezy-SyncUsers.ps1 -SiteCollectionUrl https://beezyqa.sharepoint.com/sites/beezy

Add members from CSV file:

.beezy-SyncUsers.ps1 -SiteCollectionUrl http://portal.b13qa.local -CsvFile c:tempusers.csv

Add members from AD group:

.beezy-SyncUsers.ps1 -SiteCollectionUrl http://portal.b13qa.local -ADgroup b13qaallpeople

.beezy-SyncUsers.ps1 -SiteCollectionUrl https://beezyqa.sharepoint.com/sites/beezy -ADgroup allusers

Add members from UPS:

.beezy-SyncUsers.ps1 -SiteCollectionUrl http://portal.b13qa.local -UPS