Is there a sample query or a way I can export a list of all projects on our server? Similar to what you see in Jira Administration > Projects.
I would like to see: Project Name, Key, Project Type, Project Status, Project Lead, Project Category, Last issue update, Number of issues, Date Archived (if applicable).
I cannot see a way that I can export my project list to excel. I would be using this report to help monitor clean up progress as we migrate to cloud.
