Anyone who knows how to count the number of boards in the database of one JIRA instance?
Need it before upgrading JIRA Software.
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.
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
thanks.
so this command should count the number of rows (boards) in the table?
mysql> select count(*) from AO_XXXXXX_RAPIDVIEW
Yes, but you should change XXXXXX to the numbers in your Jira instance
It looks like you're new here. Sign in or register to get started.