How to find inactive projects list?

[Narendra Kumar]

Suppose I have 1000 projects in my jira instance. How can I find the list of all projects that are not active (any updation) from last one year? 

Please suggest solution if we can use REST API for this?

Thanks in advance!

[Veera]

@Narendra Kumar 

You can run below SQL on your Jira database. It'll give you list of projects which are not updated after a specific date and time. You might have to tweak the date and time part in the 'where' clause. I ran it on PostgreSQL.

select 
pname,pkey,created as project_createtd,updated as project_updatetd
from 
project
where updated <= '2019-10-01T02:15:00.102738Z'

[Edwin Kyalangalilwa]

Hi @Narendra Kumar ,

Under Administration > Projects there's a column where you can see the last time an issue was updated in the project.

[Jack Brickey]

@Edwin Kyalangalilwa, is that an image from Cloud? Not sure it is and I do not have that field in my Projects page and I checked another instance as well w/o success. I wonder if this is Server specific?

[Edwin Kyalangalilwa]

@Jack Brickey 

You're right, i missed that this is a question related to cloud.

@Narendra Kumar Please disregard my above answer.

[Narendra Kumar]

Hi @Edwin Kyalangalilwa yeah this is not available for cloud instance. 

[Russell Zera]

Hey, just to update this old thread with new information :-) 

This is now available in CLOUD! See Screenshot from one of my cloud instances... Yup, you can now see "Last Issue Updated" and sort by that in the manner @edwin mentioned above! 

[Jack Brickey]

@Russell Zera , is this standard or premium? I don't see in my standard instance (yet).

[Russell Zera]

ohhhh nooooooo... Premium strikes again!  sorry... I'm on Premium