We have a bunch of old projects, some of them never even used. I've found 3, but I'm sure there are more. I'm after the syntax to do a search on the Jira Db that returns all projects with 0 issues in them.
Since you would like to query the projects that doesn't have any issue created under it, then I believe that we may combine the project and jiraissue table in order to get the desire results. Kindly note that in jiraissue table, there's a project column which stores the ID of the project in project table.
Hence, I believe that you may run the following SQL statement to retrieve the projects:
select * from project where id not in (select project from jiraissue);
I hope that this will help!
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot