How to extract user data from external Database table.
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.