Is there a way to export all project names, categories and project leads for auditing purposes?

[Nicki Adams]

We are working to structure standards and guidelines for rolling out a plan for Jira governance at our company. In order to get a baseline of where we are currently at with existing projects and respective settings, I was wondering if anyone has found a simple way to export project names, their categories, project leads and/or any respective schemes associated with them. 

I haven't been able to find an easy way to do this without just curating a list by individually going through each project and noting the project lead, category and then referencing the Admin settings to find the respective schemes. 

We currently have the Jira Standard plan and do not have Atlassian Access- I'm not looking for an additional paid add-on in this case either. I'm just curious if anyone has found a way to audit your system without paying for more to do so.

I welcome any ideas and suggestions you may have - thanks!

[Mikael Sandberg · Accepted solution]

Yes, it can be done using the REST API. You can get the all the information you are looking for by getting all the projects and then for each project use Get project. The response from Get project will have both the project lead and the category it belongs too.

[Laurie Sciutti · Accepted solution]

Hi @Nicki Adams ~ to expand on @Mikael Sandberg 's answer: 

you can also append ?expand=lead to include that information and then use https://data.page/json/csv to convert the JSON into a CSV file (ref:  https://community.atlassian.com/t5/Jira-Software-questions/Export-a-list-of-all-projects/qaq-p/2197127 ).  You may also need to tweak the maxResults to ensure all of your projects are displayed.  HTH

https://[yourjirasite]/rest/api/3/project/search?expand=lead&maxResults=500

[Nicki Adams]

You both are wonderful, thank you so much @Mikael Sandberg @Laurie Sciutti!