We are hosting > 100 projects in our JIRA instance. I'd like to know if all of these projects are active.
Current idea is to run a query that returns the most recent update date or create date for any issue, one for each project. So it doesn't matter which issue within the project it is. I just want to know when the last activity was.
Hope this makes sense. If you have a better way to gather this information would love to hear it.
If it makes a difference, we're running postgresql.
Please try the query from this previous answer:
I've adapted it to postgres:
SELECT DISTINCT i.PROJECT, MIN(i.UPDATED) as "Last Updated", p.pname FROM jiraissue i INNER JOIN project p ON p.ID = i.PROJECT GROUP BY i.PROJECT, p.pname ORDER BY MIN(i.UPDATED) ASC, i.PROJECT, p.pname
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