List of Archived Projects from Database

Still need help?

The Atlassian Community is here for you.

Ask the community

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)



Description
ProductJira
Last modified on Nov 23, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.