Project update

[Rumceisz]

Hi All,

I am an admin in a JIRA instance of about 150 projects. We are about to migrate some projects, but to delete the unused one's. Do you know a feature (script, plugin, etc.) we could see for each project in a list when the projects were updated last time. I mean I would like to make a historically ranking according to the last update: with this ranking list we can decide which project could we delete or conversate with the appropriate project leaders.

Thanks in advance!

Rumi

[JamieA · Accepted solution]

It would be easy as a groovy script, but probably I'd just use a bit of sql:

select project.pname, max(updated) from jiraissue
  inner join project on jiraissue.project = project.id
  group by project.pname
order by 2 desc

[JamieA]

Using pgAdmin III for instance, or psql.

[Rumceisz]

Hi Jamie,

where can we run a sql script? I mean we use psotgres