List of Archived Projects from Database
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Purpose
As of Jira 7.10+, Data Center introduced the ability to archive projects. This article is to show how you can identified archived projects via a database SQL query.
Solution
SQL Query for getting a list of archived projects:
select pe.property_key,p.* from propertyentry pe join project p on pe.entity_id=p.id where property_key = 'jira.archiving.projects';Example Results:
jira7135=# select pe.property_key,p.* from propertyentry pe join project p on pe.entity_id=p.id where property_key = 'jira.archiving.projects';
property_key | id | pname | url | lead | description | pkey | pcounter | assigneetype | avatar | originalkey | projecttype
-------------------------+-------+------------+-----+-------+-------------+-----------+----------+--------------+--------+-------------+-------------
jira.archiving.projects | 10001 | archive me | | admin | | ARCHIVEME | 1 | 3 | 10324 | ARCHIVEME | business
jira.archiving.projects | 10100 | archiveme | | admin | | ARCME | 1 | 3 | 10324 | ARCME | business
(2 rows)
Last modified on Nov 23, 2020
Powered by Confluence and Scroll Viewport.