Email address change for all users in Confluence

[Bryan Thomas]

I want to change all confluence users email address from our old company name to new company name?

Is there a way we can replace each users email with the new email address and have that account maintain their documents and content?

[Lars Olav Velle]

@Bryan Thomas have you checked that the users email address is does not update when the user logs into the application?

With our Single Sign-on add-on attributes are updated automatically when the user logs in.

Example:

The user mark.miller has an email address mark.miller@example.com in JIRA and in Okta. 

His email address is then changed to mark.miller@newdomain.com in Okta.

The next time he logs into JIRA his email address is automatically changed to mark.miller@newdomain.com

A requirement for this is (obviously) that the email address is sent as a attribute statement (Name: email, Value user.email) 

Cheers,

Lars, Kantega Single Sign-on

[Nic Brough -Adaptavist-]

It depends on what type of user directory you are using and your username format.

Is it the internal Confluence directory?  Is the user name format a simple "login" and not their email (e.g. when logging in, I'd enter "nic" in the username box, not "nic@mydomain.com")

[Bryan Thomas]

We currently use Confluence Internal Directory and are using login ids (bthomas) to login via OKTA 

[Nic Brough -Adaptavist-]

Ok, that keeps it more simple.   I assume your Okta is the usual usage - it's effectively a password safe, rather than an authenticator?

[Bryan Thomas]

Correct they gain access by login in to OKTA and click on icon to gain access.  

[Nic Brough -Adaptavist-]

Ok, good.  There's several ways to do this, but it's better to look at what needs doing before talking methods.

The change you need to make is relatively simple. There is a table in the database called cwd_user.  This holds (amongst other stuff), the login id, the data that connects a user to a thing in Jira, and an email address.  As you only want to change the email address, there's no problem with losing connections to other things - the email has nothing to do with how users are linked to pages/spaces/permissions/etc

I would personally do it the safer way - whack in script runner and write a little bit of one-off code to go through the user directory and replace addresses as appropriate.

But SQL is probably quicker and cheaper.   If, for example, you have an email format of a.name@youroldplace.com and the update is as simple as changing it to a.name@yournewplace.com, then a simple search and replace through the two email columns will do it.  Make sure Confluence is offline before doing this otherwise it might cache some of the old emails.

[Bryan Thomas]

Great info and thanks for your help.