Change User_name to Match LDAP Name

Question

We current have Jira running premises and running version 8.1.2. This has been place for a long time, going to back to 2011. The user names where created with their name (i.e. asmith or ajohnson).

Currently, we have turned on LDAP directory and new user creation works correctly. Howerver, we need to rename 400 plus accounts from asmith to OR123478. Rather than change each one individually. We are hoping to modify the mysql database by runnning a powershell script to modify the user to use their email address to find the user and replace the User_name from the cwd_user table with OR123478.

Has anyone success modify users via a script.

Mikael Sandberg · Answer

Yes, the cwd_user table is the only one you need to change.

Scott Branco · Answer

Thanks is it working for most of the changes that I need to make. Thank you for the sql statements.

Mikael Sandberg · Answer

This KB should help, How to change all JIRA internal users e-mail domain name in bulk. Instead of email_address use user_name. As noted in the KB, make sure you do a backup and I would test it out in a test environment first before trying it in your production.