Documentation for JIRA 5.0. Documentation for other versions of JIRA is available too. 
Sometimes it is useful to get a list of users exported to CSV for various purposes. JIRA doesn't currently have this functionality but you can leverage various database functionalities to do this.
Run one of the following queries specific to your database. The output will consist of the id, username, first, and last name of the users.
Always back up your data before performing any modification to the database.
MySQL
select id, user_name, lower_first_name, lower_last_name into outfile '/tmp/jirausers.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' from cwd_user;
this will not include headers
PostgreSQL
copy cwd_user(id, user_name, lower_first_name, lower_last_name) to '/tmp/jirausers.csv' delimiters',' CSV HEADER;
this will include the headers.
Overview
Content Tools
Apps
See our Getting Help page for details.
Raise an issue for our developers.
See answers from the community.
Tweet, blog and update our documentation.
Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.