Identifying Active Projects

[Emerico Vespucci]

Hello. We are looking to identify all 'active' projects in our Jira Server instance, v8.20.17.  We are defining 'active' as a project, which has had content created in the last 'X' amount of days.

Our team was considering the use of REST API or JQL or a combination of both. 

I saw the possible use of a database query as well:

Example below. 

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

Thank you

[Emerico Vespucci · Accepted solution]

Here's how its done

SELECT DISTINCT i.PROJECT, MAX(i.UPDATED) as Last_Updated, p.pname, p.lead FROM jiraissue i  INNER JOIN project p ON p.ID = i.PROJECT  GROUP BY i.PROJECT, p.pname, p.lead having MAX(i.UPDATED) > '2023-01-01' ORDER BY MAX(i.UPDATED) desc, i.PROJECT, p.pname;

[Dave Mathijs]

Hi @Emerico Vespucci 

The Projects section in Administration lists all project where you can sort by Last issue update. Isn't this easier to identify active or non-active projects?

[Emerico Vespucci]

Correct.  But I don't see an option to extract to create a list.