Hello guys! I have some amount of users in our Jira/Bitbucket/Confluence instance, who have their full names set in different formats - some of them as '<first name> <second name>', some as '<second name>, <first name>'. I need to standardize it. I know I can do in Jira via API, but it looks like a user update is in beta (and there is no such functionality for Bitbucket and Confluence). We have a scriptrunner installed for our Jira instance, and I can update through a groovy script (which I don't know how to use tbh), but still, I will have a Bitbucket and a Conflunce instance.
So, I am going to do it via database update, updating in cwd_user table. It looks like I need to update first_name, lower_first_name, last_name, lower_last_name, display_name, lower_display_name for all three services. Is there are any other way to do it? Did I miss some tables/rows I need to modify? Thank you.
