I would like to run some statistics about my Jira projects. For example, I would like to know if a project has almost no issues or if all issues have been created more than 1 year ago and the project is no longer used. I would like to know these statistics, that way I can clean up my Jira and remove all the projects that are nor really needed. Anyone has a suggestion on how to run this analysis? Should I use a specfic Jira gadget or should I export everything into Excel and run some analysis using Excel? Is there a JQL query that could make my life easier? What do you recommend?
If you are not against analyzing your Jira project details in Excel, one way to export Jira projects to Excel is with the dedicated template by Better Excel Exporter for Jira. This article has details for Jira Cloud and this separate one is for Jira Data Center (Server).
The output contains details like:
(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)
if you have access to the database you can use SQL queries provided at
Let me know if that covers your needs