How to extract user data from external Database table.

Still need help?

The Atlassian Community is here for you.

Ask the community

Extracting user data like usernames and emails of all the users in JIRA using external databases like SQL Servers or Postgres can be achieved easily by running an SQL select.

Which database table is this information stored in?

The table where this information is stored in your database is called cwd_user.

Here are a few SQL statements that can help you with extracting user data from your database: 

All fields:

select * from cwd_user /* all fields */

Only usernames and email addresses:

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): 

select * from app_user

Known "invalid object" error while running queries or manually opening the table on SQL server.

This should refresh the data cached by Intellisense to provide typeahead support and pre-execution error detection.

1. Edit -> IntelliSense -> Refresh Local Cache
2. Ctrl + Shift + R refreshes IntelliSense as well.

Last modified on Aug 29, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.