Hi,
I need to find JIRA projects which have not been used for past N days through a script. Is it possible to find the same either by using an api or sql command.
Thanks
I think you can consider a JIRA project inactive if there's no issue created on it on the past N days and this can be retrieved using a simple JQL (Project = ABC and created = startOfDay(-60)
https://confluence.atlassian.com/jira/advanced-searching-179442050.html
Other than that, you can explore on directly querying it from the JIRA DB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.