Report on version/components across all projects in JIRA

[Adolfo Casari]

Is there any mean to list all projects in JIRA and their versions and components?

Thanks in advance,

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

As a report? No. You will have to write something custom.

[Adolfo Casari]

Do you happen to know a SQL query for that? Thanks.

[Jobin Kuruvilla [Adaptavist]]

You can find some sample queries here. You will have rewrite them to get all versions and components, grouped by project. https://developer.atlassian.com/jiradev/jira-architecture/database-schema#Databaseschema-Componentsandversions

[Adolfo Casari]

Thank you.