How do I produce a list of all Jira Project Spaces - either via JQL or export to CSV / Excel ?

[Michael Green]

How do I produce a list of all Jira Project Spaces - either via JQL or export to CSV / Excel ?

Ideally this list should include owner, create date, last updated date and last viewed date.

Reason:  To archive or delete unused Jira projects

[Mohanraj Thangamuthu]

Hello, Good day. One option to try the following REST API call.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-projects/#api-rest-api-3-project-search-get

[David Nickell]

Good evening.  I have long stated that JIRA can be self documenting by using the REST APIs as @Mohanraj Thangamuthu suggests.   The problem is REST APIs can be complicated and if your job is producing widgets, you may not have time to write API Calls....

Last night in the community I "finally" put a downloadable version of my Work Item Excel on my website.  Tonight, I got a bit lazy and simply added the Project List to that same XLS.  I'll separate the Configuration calls (projects, statuses, dashboards, portals, etc) before the weekend is up.

In the meantime - you may want to go to the download page on my Website, watch the Youtube(s) on API Tokens and the Work Item Extracts, then download Version 2 of the Work Ietm Extract and run it.  The project list is made available as a 3rd tab in the XLS.

https://splitdimedata.com/downloads

[Aron Gombas _Midori_]

The Better Excel Exporter app has an Excel export template called "project export".

With that template you can export your projects to a spreadsheet like this:

It seems it contains all the information you look for, but "last viewed". I think that this piece isn't even available in Jira as column, you can only know when the current user last viewed a work item, not "anybody".

(Discl. this paid and supported app is developed by our team. Free for 10 users!)

[Michael Green]

Hi Aron.  Thanks - but correct me if I'm wrong .... your app can't be inidividually assigned to users in our Jira instance i.e. it has to be purchased / subscribed for ALL our users....... even if only 1 or 2 need it for this administration type use case of mine above ?  That would be $300USD per month per 100 users wouldn't it ?