Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

SQL to translate a JIRAUSERxxxxx to a User Name or ID on the CWD_USER table

There are a couple of columns the JIRA SQL database that list 'JIRAUSERxxxxx' instead of the standard User_Name or LAN ID.  I understand there was a change awhile back in JIRA.

I'm trying to figure out the SQL needed to translate the JIRAUSERxxxxx ID to a row on the CWD_USER table.  Originally I thought, "Hey ... the xxxxx corresponds to the ID column in the CWD_USER table!"  unfortunately that's not the case.

JIRA seems to be able to do this in the GUI.  Can anyone point me in the right direction which tables I need to join to resolve this via SQL?


1 answer

1 accepted

9 votes
Answer accepted
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Aug 04, 2021

Hi @Tom Gross 

I believe the JIRAUSERxxxxx is the user_key column at the app_user table. Give a try on this query (tested on PostgreSQL):

select app_user.user_key, cwd_user.lower_user_name from app_user , cwd_user where app_user.lower_user_name = cwd_user.lower_user_name

I did test it myself for a few user migration/consolidations I did for clients.

I hope it helps. If this answer helps solve the problem, please come back and mark this answer as solved to help other community members with the same challenge. If not, you are welcome to share your solution as well.



Exactly what I was looking for.  Thanks!

Like Alex likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events