Documentation for JIRA 4.4. 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 and full name of the users.

データベースの変更を行う場合は 必ず事前に バックアップ を取得してください。

MySQL

SELECT u.id, u.username, ps.propertyvalue INTO OUTFILE '/path/to/userlist.csv'
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
FROM userbase u JOIN propertyentry pe ON pe.entity_id = u.id JOIN propertystring ps ON ps.id = pe.id
WHERE  property_key = 'fullName' ORDER BY propertyvalue ASC;

PostgreSQL

SELECT u.id, u.username, ps.propertyvalue INTO TEMPORARY TABLE userdetails
FROM userbase u JOIN propertyentry pe ON pe.entity_id = u.id JOIN propertystring ps ON ps.id = pe.id
WHERE  property_key = 'fullName' ORDER BY propertyvalue asc;
copy userdetails to '/path/to/userlist.csv' using delimiters ',' CSV QUOTE AS '"';

Unknown macro: {htmlcomment}

深刻度

Low
Regular Expression:
Article ID: JIRAKB267257325



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.