How to bulk get the versions of all projects?

[xinan liu]

As the title says. I want to get all versions of all projects in JIRA.

How can I do that?

Thanks very much!

[Taha Khanzada]

Hi Xinan,

You can use REST API to get list of all versions in the projects

/rest/api/2/project/{projectIdOrKey}/versions

For more info you can refer - https://docs.atlassian.com/jira/REST/latest/#d2e2079

Taha

[xinan liu]

Thanks! But can I get all projects' verions in one time instead of get one project's versions in one time?

[Jonas Andersson]

This is another thing that is a lot easier to do via mysql (if you have access to the database):

mysql> select DISTINCT vname from projectversion;

+----------------------------------------------------------------------------+

| vname                                                                      |

+----------------------------------------------------------------------------+

| Release 1.0.2                                                              |

| Release 1.0.3                                                              |

...

...

(JIRA 6.2.1)

[Andrew Boutin]

Using the rest API this is your best bet:

Use /rest/api/2/project to get all accessible projects.

Extract the project keys, and loop over every project key.

Use /rest/api/2/project/{projectIdOrKey}/versions to get all versions for a specific project.

Accumulate all of the results.

[Bob Swift [Bob Swift Atlassian Add-ons]]

Use JIRA Command Line Interface (CLI) and get a CSV file with them all listed:

--action runFromProjectList --common "--action getVersionList --project @project@ --file versionList.csv --append --outputFormat 999"