Sometimes it is useful to get a list of users exported to CSV for various purposes. Jira applications don't have this functionality but you can make use of either the Active User Filter Add-on or 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;

これにはヘッダーは含まれません。

PostgreSQL

copy cwd_user(id, user_name, lower_first_name, lower_last_name) to '/tmp/jirausers.csv' delimiters',' CSV HEADER;

これにはヘッダーが含まれます。

クラウドのユーザー インポート

copy cwd_user(user_name, first_name, last_name, email_address, credential) to '/tmp/jirausers.csv' delimiters',' CSV HEADER;

copy cwd_membership(child_name, parent_name) to '/tmp/jiramembership.csv' delimiters',' CSV HEADER;