Solving Some Azure Active Directory User Synchronisation Issues on Office 365

We started moving over to Office 365 quite a while before we decided to ditch Notes mail and move to Outlook. It was also my plan to get rid of our internal active directory server and rely solely on the cloud for authentication.

As it turned out, management wanted to keep the AD server a little longer, so weve had to synchronise our onsite accounts with the Office 365 ones. The synchronisation processes immediately created duplicates (and sometimes triplicates) of users.

The journey to resolve this issue was time consuming and data destructive, so I thought Id let everyone know how to fast-track it.

What Causes the Problems

Microsofts Office 365 users have unique IDs much like the objects in the Active Directory. When you create a user from scratch on Office 365, you create them with a unique ID. While there are tools that will let you change these unique IDs, weve found that they generally do more damage than good.

Deleted people are another part of the problem, If you delete someone and then let the system recreate them, it will happily recreate them but wont set their ID properly. This is because their ID isnt unique. Its still in the person "recycle bin". To truly delete someone, you need to use the PowerShell command line.

Backing Up First

Before I jump into the whole process, you need to make sure that you back up things. Deleting users is fairly data-destructive.

If your users have anything on OneDrive, take a local copy of it all.
If your users have data in Sharepoint or Yammer, backup what you can.
Transfer Ownership of Groups in Yammer and Sharepoint very carefully - dont delete all the Admins at once because you may have trouble getting them back.
Backup any Outlook mail they may have to a PST file (theyll lose mail)
Make a note of any licences they have.
Do whatever you need to about OneNote

Getting into Microsoft Azure Active Directory

You have to have Microsoft Azure Active Directory Module for Windows PowerShell installed.
Note that this is different from PowerShell and its different from the AD Module for Powershell. Its hard to find the right version of the right software - at the time of writing, you need version 2.

In case youre interested in other Azure AD commands, heres a handy reference.

The first command is to connect to the Azure AD;

Connect-MsolService

Youll be prompted to login (so hopefully youll use a user who has Global Administrator access).

Next, you will want look at the records of users...

get-msoluser -UserPrincipalName jsmith@mycompany.com |fl

This command line will show you jsmiths record. Things to look for in the text include;

ProxyAddresses : {SMTP:jsmith@mycompany.com
ImmutableId : Pjo+HQRGtXm9GsUXzYYRqQ==
DisplayName : John Smith
SignInName : jsmith@mycompany.com
UserPrincipalName : jsmith@mycompany.com

We found that our Proxy Addresses didnt start with SMTP: and that our Immutable IDs often had peoples names (eg: jsmith) in them, instead of the ID.

The SMTP thing can be fixed but if your immutable ID is wrong, you really need to look at destroying the profile record and recreating. Weve found that all of the records we destroyed have recreated properly but that the ones where weve just changed the proxy still have some glitches. Id personally recommend removing everything.

Deleting People from the AD

Youll find that you simply cant delete a person in the Office 365 AD, particularly if theyre synched from a local server. The GUI just wont work. You need to delete via command line.

Make sure that you check which licences they have been assigned because youll want to reallocate them back.

remove-msoluser -UserPrincipalName jsmith@mycompany.com

Deleting a user is not enough though. You have to knock them out of the trash, otherwise theyll reside there for 60 days and prevent recreation via the AD synch process.

Even if your user wasnt having issues with their immutableID, they could still be having problems with Synch and email because of similarly named deleted people.

Before you delete, make sure that youve backed everything up. Emptying the trash is permanent and theres no recovery.The empty trash command is more or less the same as the delete command but with an extra switch (-RemoveFromRecycleBin)

remove-msoluser -UserPrincipalName jsmith@mycompany.com -RemoveFromRecycleBin

Wait for AD Synchronisation

In our case, AD synchronisation is set to 30 minutes. You can check via the front page of the admin centre. You might have to click More and then Refresh to get things to display properly because Office 365 doesnt always automatically refresh person lists or time displayed on the screen.

Once the next synchronisation has run, you should see the record appearing.

Some Fixes on the Local AD Record

We also had to do a couple of fixes on our local AD record, particularly making sure that the ProxyAddresses start with SMTP.

To do this;

Go to your local Active Directory Server.
Open users and Groups and get to our users.
Edit the User Record.
Go to the Attribute Editor Tab
Find ProxyAddresses and double-click on it.
If the address is something like: jsmith@mycompany.com then click on it and click REMOVE
Then type SMTP:jsmith@mycompany.com and click Add.
If you need two, you might also want to type smtp:jsmith@mycompany.onmicrosoft.com
(note the first/main SMTP is capitalised and the second is lowercase ... yes, seriously).

Reassigning Licensing and Finishing Up

Back in the Office 365 GUI, youll want to go back into the persons user record when they appear.
Reselect their country
Re-add their licences.

Youll probably want to re-check their outlook settings but you cant because you have to wait for it to be finished being setup.

Repeat the process for all other users. Note that there are options for wildcard deletions and mass trash emptying. I havent covered them here because the command line was fast enough for me and I dont really want to be responsible for someone trashing their entire Azure AD.

A big thanks to the amazing Microsoft support team in Shanghai who figured out some of the more technical parts of this process and walked me through them.

download file now

Search This Blog

Apps Media