Number of agile board in one JIRA Instance

[Deleted user]

Anyone who knows how to count the number of boards in the database of one JIRA instance?

Need it before upgrading JIRA Software.

[Alexey Matveev · Accepted solution]

Hello,

You can find an answer here:

https://community.atlassian.com/t5/Questions/sql-query-to-get-all-board-id-s-srum-kanban-which-are-associated/qaq-p/226611

Bascally this information is stored in AO_XXXXXX_RAPIDVIEW. The XXXXXX part is different for all Jira instances. You can open your database and find a table with AO and RAPIDVIEW.

[Deleted user]

thanks.

[Deleted user]

so this command should count the number of rows (boards) in the table?

mysql> select count(*) from AO_XXXXXX_RAPIDVIEW

[Alexey Matveev]

Yes, but you should change XXXXXX to the numbers in your Jira instance

[Sean Binny]

A count of the below table should give you the list of Agile boards 

AO_60DB71_RAPIDVIEW 

 Sean Binny

Product Manager

At a Glance Jira Plugin