Resolving Duplicate User Accounts

[#1]

We had an issue with our user data import scripts that resulted in some duplicate User accounts. In some cases the user has activities associated with both of their duplicate accounts...

Is anyone aware of a script/process that could be used to "merge" the two accounts to one, and then remove the duplicate?

Thanks in advance!

[Brad Tilton]

The second script on this Useful User Scripts page on the wiki shows how to copy all of a user's references to another user. You could do this manually for each account with a UI Action or something like that, or you could run a script that queries the user table to find and mark duplicate accounts, then copy all of the references from one account to the other and delete the duplicate.

http://wiki.service-now.com/index.php?title=Useful_User_Scripts

[#3]

Great - Thanks Brad!