You will have to go with the assumption that if no issues have been updated in a project for a long period of time (you can decide the period), then the project is no longer being used.
You can use JQL to find issues that have been not been updated for a long period of time.
For example, if you want to search for issues that were last updated before 12th December 2010, you can use the query
updated < "2010/12/12"
Documentation is available here
I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs