Please avoid using the database, it's complex, messy and if you get it wrong, you can destroy your installation, and you will not technically be supported if anything goes wrong.
A far better option on the first one is really simple. Run and save a filter for "custom-field is not empty". Use that filter in a "filter statistics" gadget and group by the custom field. You'll get all the values, and a count of usage.
Nope, because you haven't really told me what data you think you want from the custom fields, so I'm guessing. And a filter is a far better, safer way to do it. SQL is a last resort and a terrible idea.
The SQL for the user changes is "update cwd_user with your changes". Remember to take a full backup before you run it, and have JIRA totally shut down when you do it.
I think there may be some confusion here.
The problem we have is that we’ve changed email address format for our users so for example where users used to be firstname.lastname@example.org is now email@example.com
Consequently we need to update approx. 2000 user records and was wondering what would be the best method to achieve this
We are not looking to update any custom fields
If doing this via sql is not recommended then that's fine – we will look at alternative methods (any suggestions you have will be appreciated)
There's no confusion, you're trying to change email addresses on user accounts. It's not advisable to do it with SQL, but you can do it. I don't know why you keep asking about it, or why you've suddenly started looking at the login ids when you're only interested in email.
Secondly, you specifically asked about custom fields. You've had an answer to that as well.
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