Find and Delete Orphaned Users in SharePoint
Orphaned User? Who are they?
Orphaned users are those who have been disabled/removed from Active Directory, but still have permissions to sites, lists and items. Internally, SharePoint keeps them in “UserInfo” table of the content database for meta-data such as created/modified by fields.
It’s unavoidable in any organization where employees constantly on-boarding and off-boarding. It’s really difficult to manage when it comes to thousands of sub-sites, sites, libraries, and lists with their own sets of permissions.
Why do we care about orphaned users?
It is a best practice to delete orphaned users to keep the farm clean & organized. Also, this will solve the problem of deleted active directory users still appearing on the people picker which was discussed here People Picker not showing users from Active Directory? . If you know the user base or criteria then you can use: Clean-up User Information List
Found only a few users and want to delete them?
Go to: https://YOUR-SHAREPOINT-SITE-URL/_layouts/people.aspx?MembershipGroupId=0
This will give the master list of users in the site collection, from here you can remove users who are no longer need by clicking “Remove Users from Site Collection”
If you know the orphaned user name (E.g. Employee left the Company), You can go to above URL Filter and delete the particular user. Alternatively, You can query the SQL Server table to find the orphaned users. Here is how:
Step 1. Open SQL Server Management Studio from SharePoint’s SQL box, and run this query for relevant content database.
SELECT * FROM [MOSS_Content_DatabaseName].[dbo].[UserInfo] WHERE tp_Login='DOMAIN\UserID'
Step 2. Take note of the tp_ID column value
Step 3. Go to https://<your sharepoint-site-collection/_layouts/userdisp.aspx?ID=tp_ID, where tp_ID is the number you found from the above select statement.
Step 4. This will take you to the user’s profile where you can click on the Delete User from Site Collection button.
However, it is not possible to manually check for SharePoint 2010 orphaned users and clean them, as it would take lot of time. Things become easier with PowerShell, Lets use it here to find & delete Orphaned users in SharePoint.
How to Find and Delete Orphaned Users in SharePoint using PowerShell?
Here is my script to Find and Delete Orphaned SharePoint Domain Users: Find and Delete Orphaned Users in SharePoint with PowerShell
Related Post: Remove all alerts assigned to Orphaned users: Find and Delete Orphaned Alerts in SharePoint
10 thoughts on “Find and Delete Orphaned Users in SharePoint”
I am using Sharepoint 2013 foundation , and when I delete Item from custom list I look in the database , I see the item still there even when I delete it from the recycle bin , Please I need the column that shows that the item is deleted , knowing that the tp_deletedtransactionid in the allusersdata data is not set to a value a fter deletion , please inbox me at my email firstname.lastname@example.org
Thanks in advance.
I have removed a few users in the manual way, but keep seeing the names in the people picker when adding new users to a group. How can I prevent this behaviour
Archie, That is because: People picker get entries from Both AD and “User Information List”. Here is how you can cleanup your UIL: How to Cleanup SharePoint User Information List
Salaudeen Rajack, To my humble opion this is exactly what is mentioned above at: ‘Found only few users and want to delete them?’. That shows how to remove users from Group=0.
My problem is: Users are listed in the People Picker even after removing them from Group=0
Are they Removed from AD as well?
If a user is deleted from the user list, what happens to any content associated with that user – is it gone or still around?
If still around, who is listed as the owner?
Content stays intact. Owner Information replaced with “System Account”
This is a great script. I hope you don’t mind, but I used it as the basis for a similar script that I had a need for, then added some “improvements”. Let me know if you’re interested in seeing them. Maybe we can collaborate on making this a great powershell tool.
larry DOT wapnitsky AT tmnas DOT com
Sure, I’m open Larry!
May I take a look at your scripts?
Thanks a lot!