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!

2 answers

0 votes
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

@Jack 

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

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

Suggest an answer

Log in or Sign up to answer
TAGS

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