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
Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...
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