Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to find inactive projects list?

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!

3 answers

1 vote
edwin Community Leader Jan 09, 2020

Hi @Narendra Kumar ,

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

Screen Shot 2019-02-01 at 16.47.11.png

Jack Community Leader Jan 09, 2020

@edwin, 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 Community Leader Jan 09, 2020


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

@Narendra Kumar Please disregard my above answer.

Hi @edwin yeah this is not available for cloud instance. 

0 votes
Veera Atlassian Team Jan 09, 2020

@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.

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

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 Community Leader Oct 22, 2020

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

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

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you