SharePoint 2019 User Information List Duplicates

Kummari, Rani 66 Reputation points
2022-11-14T17:10:38.387+00:00

Hello,
We have some duplicate users in User Information List. The duplicates are created because of the rehire of the same user with a different account name in AD.
Ex:
User1 exists in User Information List with Domain\xxxx with a created date in 2017 and with Domain\yyyy with a created date in 2022.
User1 was hired in 2017 with AccountName in AD as Domain\xxxx and was terminated some time in 2019. This account exists in UIL.
User1 was re-hired in 2022 with AccountName in AD as Domain\yyyy and is currently working. This account exists in UIL.

How to move Domain\xxxx to Domain\yyyy without loosing Domain\yyyy

Hope this makes sense. Thanks in advance.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,297 questions
{count} votes

4 answers

Sort by: Most helpful
  1. James Whitlock 5 Reputation points
    2024-02-29T14:47:21.4366667+00:00

    I've had this issue since implementation of ADFS and found no "built-in" solution. I mitigated the issue by creating a scheduled task that runs every 15 mins to delete the duplicate profiles and have been running in this configuration for several years.

    1 person found this answer helpful.
    0 comments No comments

  2. Haoyan Xue_MSFT 22,461 Reputation points Microsoft Vendor
    2022-11-15T08:25:44.677+00:00

    Hi @Kummari, Rani
    Both Domain\xxxx and Domain\yyyy still exist in AD, right?
    When granting permission to user and the user accesses the site collection, the user will be automatically added to the User Information List.
    If the domain \yyyy has been idle and you want to delete it, you can manually delete the user in UIL.
    Navigate to the URL in the browser to: https://YourDomain.sharepoint.com/_layouts/15/people.aspx?membershipGroupId=0
    What does How to move Domain\xxxx to Domain\yyyy without loosing Domain\yyyy mean?
    Do you want to copy the permissions originally belonging to Domain\xxxx to Domain\yyyy?
    If yes, you can get the User Permissions detail report of Domain\xxxx through powershell, and grant it to Domain\yyyy. Finally, delete Domain\xxxx from AD.
    User Permissions detail report powershell code: https://mstechtalk.com/sharepoint-user-permissions-detail-report-for-a-web-application/


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  3. Kummari, Rani 66 Reputation points
    2022-11-15T20:45:29.333+00:00

    The old account Domain\xxxx does not exist in AD as the user is terminated. Domain\yyyy exists in AD as the user is rehired with this new account.
    I can delete the account Domain\xxxx as it is idle, but I'm worried that on any of the infopath forms where the user is referenced, the user won't be found.
    That's why I'm thinking if I can move Domain\xxxx to Domain\yyyy using move-spuser command (meaning wherever the sharepoint/infopath forms show User Domain\xxxx, after move will have User: Domain\yyyy)
    For this I'm willing to create a dummy AD user for Domain\xxxx

    Ultimately my goal is to combine Domain\xxxx into Domain\yyyy
    Hope this makes sense.


  4. Kummari, Rani 66 Reputation points
    2022-11-18T18:35:39.493+00:00

    Since we can't merge two accounts into one, the only option left for me is to delete the users, I'm looking into that and the issues that come with that.