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
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in talking to 20 people planning t...
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