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';