My users which have been removed from AD are still showing up in SP. I notice the mysites are still there for these users as well. I am not expert at all and seem to find issues in user profile sync.

There is no trouble on the import - all new users are added. I have approximately 390 users but the sync is showing 475 - significantly more. Some guidance as to where to begin to troubleshoot would be most appreciated.

As mentioned using SP2019 on premise (no azure) - Userprofile synchronization connection using Active Directory Import.

1 Answer 1


Run this SQL query against the Profile database to check if deleted users have been marked:

Select * From upa.UserProfile_Full Where bDeleted = 1

Then run the My Site Cleanup Job. After the job runs, it schedules the profiles to be deleted after 30 days,The 30-day setting is hard-coded. There is no way to change it. Also, if your build is pre-August 2017 CU (16.0.4573.1002), this functionality does not work at all, even after 30 days.

More information:



  • Thanks for this Julie. I have run the query against the upa.UserProfile_Full and no results come up. If I run the query and set the bDeleted = 0 all my users show up - including the ones which are removed from AD. Unless I manually remove the users under SP CA they still appear.
    – garvon-77
    May 20, 2021 at 3:28
  • It seems that UPA does not recognized some users has been removed from AD, try to create a new connection, run full sync, and compare the result.
    – Julie_MSFT
    May 25, 2021 at 9:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.