Report on version/components across all projects in JIRA

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

Thanks in advance,

1 answer

Community moderators have prevented the ability to post new answers.

0 votes

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thank you.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.