Hello @Neeta Dubey
The JQL provides search across issues, so searching across projects based on a specific criteria is not something which is supported out the box. There might a custom plugin out there or you can write a script for it using Script runner plugin as well.
But with newer Jira versions when you open the project section and see the list of projects, then you see the column
"Last issue update"
Which can give you an easy idea about how active the project is and then you can write a JQL based on the project name and see how many issues were created this year or last year. And this is how you can start the cleanup of the Jira instance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.