Documentation for JIRA 5.2. 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.
ご利用のデータベースに応じて次のクエリのいずれかを実行します。出力には、ユーザーの ID、ユーザー名、名、姓が含まれます。
データベースの変更を行う場合は 必ず事前に バックアップ を取得してください。
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.
Unknown macro: {htmlcomment}
深刻度 |
Low |
|---|
概要
コンテンツ ツール
アプリ
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.