How can I create a filter by project to see when most recent update occurred? Edited

[Pete P]

How can I create a filter by project to see when last update occurred?

I need to provide an inventory of projects, the project lead and the most recent time an issue was updated in each project.  Anyone know how I might achieve this? We have a lot of turnover and abandoned Jira projects strewn about I am trying to clean up.  

[Zoryana Bohutska _SaaSJet_ · Accepted solution]

Hi @Pete P 

Maybe, you can find the solution at this discussion https://community.atlassian.com/t5/Jira-questions/SQL-to-return-for-every-project-most-recent-updated-date/qaq-p/437248 

[Pete P]

Thanks @Zoryana Bohutska _SaaSJet_ , that page lead me to "Latest Activity Report for Jira" app which should do the trick.  

https://marketplace.atlassian.com/apps/1210777/latest-activity-report-for-jira?hosting=server&tab=overview

[Daniel Ebers]

Hi @Pete P

in more recent versions of Jira Server you could just navigate to:

https://jira.example.org/secure/project/BrowseProjects.jspa?s=view_projects

to get those information - they can be easily copy & pasted to Excel. A filter on that page directly is not possible, though.
jira.example.org must be replaces with valid data, of course.

Regards,
Daniel

[Pete P]

Thanks @Daniel Ebers !