Archiving of projects in Jira. SQL Tricks

In large companies, there are usually a large number of projects of which, most of them are currently inoperative. Therefore, from MrAddon we advise you to execute this query every year and list all those projects that since a certain date have not updated their tickets. The list includes the name and the key of the project and its leader, that way we can contact the indicated people that will help us decide if the project can be already archived. Here we give you an example of SQL:

select j.pname, j.pkey, j.LEAD from project j where j.pkey not in (select project.pkey from jiraissue, project
where project.id = jiraissue.project and jiraissue.updated > "2019-01-01" )

Here a trick more to find or view a Jira issue from the database using SQL (here)