---
title: "[Xray] How to get all Archived Projects?"
canonical: "https://docs.getxray.app/space/ProductKB/140705894/%5BXray%5D%20How%20to%20get%20all%20Archived%20Projects%3F"
format: markdown
---
You might want to recover all archived projects, especially 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';
```