@Rodolfo - I do it on the terminal (bash/zsh on Linux or Unix(MacOS)) but I guess it runs on Windows CMD as well.
* Jira Rest API
* httpie - a human curl
* jq - a parser for json on commandline
* tr - a bash command to remove '"'
I believe it works with postman as well.
I hope it helps
With the Better Excel Plugin you can export all user information to a customizable Excel spreadsheet, post-process in Excel (if necessary) and then convert to CSV if that fits your use case better than an XLSX file.
The default Excel file will contain the following data for each user account:
I am not sure about Jira Server but if you are using Jira Cloud (on-demand), then this feature is already implemented (no need to install third party add-on).
Admin users can export all Jira users to CSV file.
Here is how I use it:
See the screenshot I took from our Jira Cloud instance below.
If you have access to your DB tool, ours in Sequel, you can query the table that the users are stored on and export that. Not the most user friendly, but that's the only way I know of at the moment.
For example, our JIRA db instance is named 'jiradb2' and the full table name in this environment is 'jiraschema.cwd_user'.
SQL would be:
select * from jiraschema.cwd_user;
You can narrow you results by specifying the column(s) instead of getting them all.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event