[Xray] How to get all Archived Projects?

You might want to recover all archived projects, specially if you are planning to run a Jira Cloud Migration and want to make sure the archived projects are migrated. 

So if you want to know which projects are archived you can run this SQL query:

SELECT pe.property_key,p.* 
FROM propertyentry pe 
JOIN project p on pe.entity_id=p.id 
WHERE property_key = 'jira.archiving.projects';