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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • 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 which projects are inactive in last 6 months? Like to know all possible ways to find.

I want to find out the projects which are inactive in my instance from last 6 months.

2 answers

1 accepted

1 vote
Answer accepted
Syauqi Atlassian Team Sep 17, 2018

Hi Neeranjan, 

There have been several similar post which you can refer to and here's one of them: Need a query to find out active and inactive Jira project over the last 6 months.

You can use the following queries:

1. SELECT count(id) FROM project WHERE ID NOT IN (SELECT DISTINCT(project) FROM jiraissue WHERE updated > DATE_SUB(NOW(), INTERVAL 6 MONTH) and created > DATE_SUB(NOW(), INTERVAL 6 MONTH));

2. SELECT count(id) FROM project WHERE ID NOT IN (SELECT DISTINCT(project) FROM jiraissue WHERE updated > DATE_SUB(NOW(), INTERVAL 6 MONTH) or created > DATE_SUB(NOW(), INTERVAL 6 MONTH));

Hope this helps!

I will try to with those queries. Thank you @Syauqi

Syauqi Atlassian Team Sep 18, 2018

No worries neeranjan 

2 votes
edwin Community Leader Sep 17, 2018

Hi @niranjan,

Upgrade to Jira v7.11.1 and above. They have added a feature that lets you see more project information in the admin section.

Jira Software 7.11.x release notes

projects_columns2.png

Does this feature exist on JIRA Cloud as well?

Not that i have been able to locate.  You would think they would make this available as we have limited querying options where as the server version can always query the DB.

On Jira Cloud you can see activity by doing the following:

  • Go to the Gear icon and choose "Projects"
  • Choose "Manage Projects" to the left
  • The column "Last issue update" is to the far right, sort descending 

Project dormancy.png

Like Marianne Miller likes this

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