User Profiles is full of deleted users in SharePoint Online, how to remove them?

Question

Hi,&nbsp;The tenant has Azure AD Connect to sync on-premise AD users to Azure AD.SharePoint User Profiles is created based on the users in Azure AD.This works fine! :)&nbsp;When a user is deleted from local AD, it is also deleted from Azure AD.But the User Profile in SharePoint is not deleted.&nbsp;How can I purge and remove all User Profiles for non exisiting users in Azure AD?&nbsp;I have not found any powershell cmdlet or scripts to do this or to help me find all user profiles.&nbsp;&nbsp;

pieter veenstra · Answer

Hi&nbsp;Deleted,&nbsp;Interesting question.&nbsp;&nbsp;I came across this article:&nbsp;https://blogs.technet.microsoft.com/fromthefield/2014/02/27/office-365-retrieve-user-profile-properties-using-csom-with-powershell/&nbsp;The script in question will need to be modified a bit, but it will get you all the user profiles from&nbsp;&nbsp;Microsoft.SharePoint.Client.UserProfiles.PeopleManager&nbsp;Once you've got a collection of users you migth quite well be able to delete them.&nbsp;&nbsp;&nbsp;

narasimaperumal chandramohan · Answer

Check the script in the below blog, this should work for you.http://www.jijitechnologies.com/blogs/how-to-find-and-delete-orphaned-users-from-sharepoint-online-site-collection

cprothero · Answer

Are there negative ramifications to doing this? I guess I've assumed they were left in there for a reason. Would it affect pages or list items that deleted user might have created?

Forum Discussion

User Profiles is full of deleted users in SharePoint Online, how to remove them?

3 Replies

Resources