Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Run some statistics about which projects are used versus which ones are not used

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?

2 answers

0 votes

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:

  • Project name
  • Project Lead
  • Last issue update
  • Number of issues
  • many more + the ability to customize to your specific needs


(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

0 votes

@Mouna Hammoudi 


Hi Mouna

if you have access to the database you can use SQL queries provided at


Let me know if that covers your needs




Suggest an answer

Log in or Sign up to answer

Atlassian Community Events