How to search for projects which had no issues created/updated from last X DAYS?
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
How can we find a list of projects those are not updated or no issues created in that from last X DAYS?
Environment
8.13.0
Solution
We have two ways to get the list:
From the UI:
Click on Settings → Projects
Look out for "Last issue update"columnand sort the column (either ascending or Descending)
Run the below SQL query:
1
2
3
4
5
6
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) < '2020-05-01'
ORDER BY MAX(i.UPDATED) desc, i.PROJECT, p.pname
Note: Change the date according to your requirementWas this helpful?