Bulk Change Email Domain for All Jira Internal Users (Server & Data Center)

Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.

Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

This guide is for informational purposes and is not eligible for support from Atlassian. If you have any questions about the information on this page, please reach out to our community at Atlassian Answers for help.

When a company get acquired, it is necessary for them to change their e-mail address domain name to the new company. However, JIRA does not have a bulk editing feature that could help simplify this process.

Solution

Workaround

Create a complete database backup for safety precaution.
Execute this SQL query to obtain internal directory id.
SELECT id FROM cwd_directory WHERE impl_class = 'com.atlassian.crowd.directory.InternalDirectory';
Execute the following SQL queries to modified the e-mail domain of your internal users.
UPDATE cwd_user SET email_address = replace(email_address,'<PreviousDomain>','<NewDomain>') WHERE directory_id = <ID from step 2>; UPDATE cwd_user SET lower_email_address = replace(lower_email_address,'<PreviousDomain>','<NewDomain>') WHERE directory_id = <ID from step 2>;
Restart JIRA

Extra Notes

This method does not work for external users such as LDAP server, Crowd or another JIRA as JIRA will retrieve the data from the external server configured. Hence any modification in JIRA database will be temporary.

Atlassian Support