How can I generate an Agile Version Report for multiple projects?

[Mike Lange]

I must be missing something simple here. I've got an agile board set up to support multiple projects, but when I try to view a version report it appears that Agile only supports viewing the report on one project at a time because it prefaces each available version to report on with the project name.

Is there any way to get a story point burn down of some sort or another on >1 project at a time?

Thanks,

Mike

[Pablo Beltran]

It would be easy by using SQL for JIRA.

The following query will get all the versions for all the boards:

select * from AGILE.BOARDS b inner join AGILE.BOARDVERSIONS v on v.board.id=b.id

Then join the ISSUEVERSIONS table to get the issues for each version above and the ISSUECUSTOMFIELDS table to get the Story Points, etc.