Do you know by any chance if there is another way to modify multiple users? For example I have multiple users that are email@example.com and I want to delete @email.com from their user.
I tried doing this from the DB but I ended up changing the usernames how I wanted but the users appear corrupt.
This needs to be properly tested before done on the production but i have done something very similar a few years back and this approach worked superwell.
cat your.jira.db.sql | sed 'firstname.lastname@example.org//g' > your.new.jira.db.sql
You might have to login with JIRA using a built in admin account if this fails, in that case you might also have to adjust the JIRA user directory to reflect that you no longer use the email, but another object for usernames on AD or whatever you might use.
Once authentication is done, i warmly recommend you to rebuild all indexes. You will also have to do the same for all other systems that ride on Jira's authentication. An example would be if Confluence uses a JIRA user server for authentication, Confluence database would need the same treatment.
Other things to think of:
If you have users with other email addresses you can piggyback these with more sed statements, but beware that a user can only exist once, so if you have a email@example.com and a firstname.lastname@example.org you will end up with a conflict.
I warmly recommend you to test, test, test, test and test again on a virtual server that is a close clone of your system before you actually go ahead and do this on a production system. Make sure you back up both databases and filesystems so you can reverse fast. Make it an art, than kick it into gear.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot