Microsoft Online - How to remove duplicated users

Microsoft Online - How to remove duplicated users

Overview

This KB overviews how to resolve a user being duplicated by the Azure AD User sync within the Microsoft Online service in Atria.

There is a couple of ways to see how this is occuring

1. Two Users with the same name appear on the search
2. There are duplicate users in Active Directory
3. There is a user missing from Atria who was previously there, and appears on the search.

The reason why the users do not appear on User list is because two users are not shown if they have the same Primary Email Address. To make them appear on the UI, change the primary email address of the invalid user directly in AD for them both to appear.

Applies To 

Any version before Atria 15.2 - This has been fixed to handle this scenario and tie the users correctly in 15.2.

Procedure

1. On your SQL database - query the DUPLICATE user and grab it's userID (example: select userid, name,label, upn from users where label = 'Joan Lee')

2. Execute the stored procedure to delete this duplicate user (exec sp_UsersDelete @userid=788)

3. Validate that the duplicate user was removed including the associated service

      select userid, name,label, upn from users where label = 'Joan Lee'

      select * from UserServices where userid=788

4. Now that this is cleared in Atria, navigate to PartnerCenter and update the user's username. Wait this update to propagate into Office365

NOTE: it is really required that UPN matches on both sides.

5. Once the update is done, it should reflect the changes in Office365 Admin

6. Double check the e-mail addresses in Exchange Online to make sure all are still intact- make changes if necessary

7. Run the Sync Tenant in Atria. This will now match the user and sync it properly and provision MSOL

8. Validate this user

9. Lastly, on your AD - delete the duplicate user account that was created

• Related Articles

• Microsoft Online Service Planning

  Overview The Microsoft Online Service for Atria allows Customers and the service desk to manage tenants, licenses, users and features of Office 365 – with no access to the 365 admin portal. It reduces your risk, while still being able to effectively ...

• Microsoft Online - How to configure your Customer plan

  Overview The Microsoft Online service within Atria has been designed from the Ground Up with Customization and flexibility in mind. This means, that it can likely cater with most configuration scenarios you may come across with Microsoft Online ...

• Connecting Atria to Microsoft Partner Center

  As of October 2023, Microsoft no longer supports DAP. We have updated the scripts within the platform as of 15.16 to create new GDAP level permissions. Please see below for more information. Objective This article shows you how to set up a secure ...

• Microsoft Online Group Management in Atria

  Introduction to Group Management Groups are a fundamental feature used to control access and make information sharing easier.  In the Microsoft 365 platform, there are four core group types, all of which have a core component in Azure AD.  Many ...

• Microsoft Online - Change Subscription Page Behaviour

  Overview By default, our Microsoft Online Subscription page queries subscriptions from our Database, instead of loading subscriptions directly from Microsoft. This was chosen as default behaviour due to performance issues and seeing long loading ...