Get all projects schemes in CSV format

Andrew
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 4, 2019

Hi @All here !! 

Extend my previous post https://community.atlassian.com/t5/Enterprise/Get-user-roles-from-all-projects-in-CSV-format/gpm-p/1068800

So what is the problem when you manage a large number of projects? This is a lot of schemes and settings.

I was tasked to change several schemes, but this should not affect the scope (call it projectsA).

Hmm .... for that, I have to check that these schemes are not installed for pojectsA. It's simple, if you have 10 projects and 4 schemes, and not when there are a hundred.

I thought it would be easy if I had one table with all the projects and its schemes.

I wrote a GEB script for this purpose. The script accumulates all the name schemes in a single CSV file. Now everything is in one place and you can do the filtering.

tableProj.PNG

For example, we can now filter 'workflow scheme' and get a list of projects that will be affected. And we can use the Excel function to find duplicates with our 'projects A' and filtered.

Link to source code: https://git.andrewsite.ru/blob/JiraGebAuto.git/master/JiraGebAuto.groovy


I also added project deletion methods to the script, be careful! Use it only if you know groovy.

I hope this post was helpful.

1 comment

Comment

Log in or Sign up to comment
Jonas Fischer July 9, 2019

Hey @Andrew

Unfortunately the link to the Git does not work. Can you put the code in here? That would be nice ;) 

Andrew
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 10, 2019

Hi @Jonas Fischer ,

Sorry for long time answer. Please use very careful because script has methods to delete items. Check first on test env.

https://github.com/AndrewDvizhok/JiraGebAuto

B.R.

Like Dave Liao likes this
Jonas Fischer July 10, 2019

That works ! Thank you.

TAGS
AUG Leaders

Atlassian Community Events