Need to rename all issues from Old id to New id

Question

Hi Team ,

We have user A , his AD id is A.xxx ,but A is moved to full time employee and now he has new id as B.xxx. We need to rename all issues related A.xxx in comments, assignee, reporter, watcher and status updates to new id of B.xxx . Currently user A holds more than 5k tickets. Please let us know if there is any way to achieve this ,

Ravi Sagar _Sparxsys_ · Answer

Hi @Karthika Thangavel

Broadly you can do the following steps.

1. Move the user from external to internal directory. This can be done by disabling external directory and then simply creating that user and group manually (or using script for bulk users).

2. Rename the user in the internal directory.

3. Enable the directory again (with the new username).

This will ensure that the old user associations to issues/comments etc are still valid.

I hope it helps.

Ravi

Daniel Eads · Answer

Hi Karthika,

If you're using Jira's internal directory, renaming a user is a simple operation:

* How to rename users in Jira

In the case that you're using an external directory, the user could also be renamed in the external directory and depending on the setup, should sync in.

But in the case that there are two separate accounts in an external user directory, and one has now been disabled and another set up - that's a trickier situation. We provide instructions for doing this in official product documentation in How to migrate user contributions to new user name.

Unofficially it's possible to do this with direct database modifications, although we don't recommend this route. If you'd like to see the options for that, a search along the lines of "migrate username jira server sql" might turn up user-contributed results that are close. Be warned that SQL modifications can mess up a system if done incorrectly, so use caution when evaluating scripts, and never apply them directly to a production environment without first running them on a lower environment and thoroughly testing the results.

Cheers,
Daniel