Given that user fields are lookups to the user information list in a particular site, is there an easy way to find all user fields in the site that are populated with a particular user ID?

We recently switched from Windows/classic auth to claims, and now the user information list has a bunch of duplicate entries for users, some with their AD formatted login, like


and some with their claims formatted login, like

i:0e.t|some-type-of-code|[email protected]

I want to de-dupe the list, but I don't want to arbitrarily remove all the domain\user style entries because I'm worried that some of those list items might be the lookup IDs in some fields somewhere on the site. If I can find those, I can swap them out for the IDs of the user's claims formatted entry.

So given a specific user ID from the user information list, is there an easy way to find out everywhere it's used on the site?

  • Hi. You convert to claims WebApplication after that? docs.microsoft.com/en-us/powershell/module/sharepoint-server/… Jun 24, 2022 at 4:16
  • I don't know, I'm not the SP Admin and I didn't do the conversion to claims. All I know is, we're using claims now (and it works just fine), but there are duplicate entries in the user info list. I may end up deleting this question anyway because we actually solved the issue that I thought was caused by the duplicate entries. Jun 24, 2022 at 14:26

1 Answer 1


This situation is most likely due to the fact that you did not convert web applications to claims. This often happens after a migration or change to an organization's authentication scheme. First of all, you need to make this conversion - https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/convert-spwebapplication?view=sharepoint-server-ps After that, users who have become duplicates must be migrated to existing - https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/move-spuser?view=sharepoint-server-ps Be careful as this method does not update rights and permissions, it only updates lookup values ​​and fields related to creation and modification.

Your Answer

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

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