How do I count all the Agile boards I currently have in my JIRA instance

This FAQ is for JIRA Administrators with access to the JIRA database.

On this page:

Procedure

This can be done by directly running an SQL select query from the database:

SELECT COUNT(id) FROM ao_60db71_rapidview;

This will return the number of boards regardless of Kanban or Scrum.

Kanban Specific

To get the number of Kanban-only boards:

SELECT COUNT(id) FROM ao_60db71_rapidview WHERE SPRINTS_ENABLED = 0;

Scrum Specific

To get the number of Scrum-only boards:

SELECT COUNT(id) FROM ao_60db71_rapidview WHERE SPRINTS_ENABLED = 1;

Was this helpful?

Thanks for your feedback!

Why was this unhelpful?

Have a question about this article?

See questions about this article

Powered by Confluence and Scroll Viewport