I have to send reports weekly of all current users in JIRA. Currently having to highlight and scroll down, copy and then paste into Excel to get a list. With over 300 users, this can be tricky and time consuming. Is there a way that this list can be exported to Excel where it then can be manipulated?
Ugly hack: find inactive users in JIRA by processing the HTML from the UserBrowser page.
Browse to the JIRA Users page, select All from Users per Page, add
?max=10000 to the URL and save the HTML only to the local file
user.html then parse it
You can use the REST API to retrieve a list of users. You your favorite scripting language that has a web client interface.
If you are on server edition then the Active User Filter add-on (https://marketplace.atlassian.com/plugins/cr.tin.ActiveUserFilter.active-user-filter/server/overview) allows you to export users to CSV.
Better Excel Plugin does produce a customizable Excel file from the JIRA user accounts!
(Please note that this is only applicable to JIRA Server at the moment, but we are already working on the JIRA Cloud version.)
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot