Export/Report on all Projects

[Michelle Gronwold]

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.

[Trudy Claspill · Accepted solution]

Hello @Michelle Gronwold 

There is not a built in report for that.

You could use the REST API to extract the information or you could use a third party application.

I found several other posts on the same topic by searching with Google. Some of those recommend third party apps.

https://www.google.com/search?q=jira+server+export+list+of+projects

[Michelle Gronwold]

Thank you!