Could you some please help me on how to get List of projects under which no ticket is created during last one year.
This will help me help me to clean up my jira instance.
I have used for years REST API for than (+Python) and have a script that get all projects and count number of issues. Then get the last one and check created/updated date. That all gets generated as a CSV file that I can later filter easily for example in Excel.
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.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events