Change Confluence User Email Domains in Bulk on Data Center
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 is acquired, it is necessary for it to change its email address domain name to the new company. However, Confluence does not have a bulk editing feature that could help simplify this process.
Workaround
- Stop Confluence
- Create a complete database backup for safety precautions.
Execute this SQL query to obtain the internal directory ID.
SELECT id FROM cwd_directory WHERE impl_class = 'com.atlassian.crowd.directory.InternalDirectory';Execute the following SQL queries to modify the email 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>;- Access the Confluence "Cache Management" menu and click "Flush All"
- Rebuild search index of Confluence
Extra Notes
This method does not work for external users, as Confluence retrieves the data from the external server configured. Hence, any modification in the Confluence database will be temporary.