How to extract Jira user data from Database tables
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Purpose of this article
The purpose of this article is to explain how to extract user data like usernames and emails of all the users in Jira using databases like SQL Server or PostgreSQL.
Which database table is this information stored in?
The table where this information is stored in the Jira database is called cwd_user.
Here are a few SQL statements that can help you with extracting user data from your database:
All fields:
1
select * from cwd_user /* all fields */
Only usernames and email addresses:
1
select user_name, email_address from cwd_user /* only username and email field */Which database table contains information related to username changes?
The table where this information is stored in your database is called app_user.
This SQL statement will show you the ID, original account name (user_key), and the new account name (lower_user_name):
1
select * from app_userWas this helpful?