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

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;