Table: jira_board - Query Jira Boards using SQL

Jira Boards is a feature within Atlassian's Jira Software that allows teams to visualize their work. Boards can be customized to fit the unique workflow of any team, making it easier to manage tasks and projects. They provide a visual and interactive interface to track the progress of work.

Table Usage Guide

The jira_board table provides insights into Jira Boards within Atlassian's Jira Software. As a project manager or a team lead, you can explore board-specific details through this table, including board configurations, types, and associated projects. Utilize it to uncover information about boards, such as their associated projects, the types of boards, and their configurations.

Examples

Basic info

Explore the types of boards in your Jira project and identify any associated filters. This can help in understanding the organization and management of tasks within your project.

select
  id,
  name,
  type,
  filter_id
from
  jira_board;

select
  id,
  name,
  type,
  filter_id
from
  jira_board;

List all scrum boards

Explore which project management boards are organized using the Scrum methodology. This can help you assess the prevalence and usage of this agile framework within your organization.

select
  id,
  name,
  type,
  filter_id
from
  jira_board
where
  type = 'scrum';

select
  id,
  name,
  type,
  filter_id
from
  jira_board
where
  type = 'scrum';

List sprints in a board

Explore the various sprints associated with a specific board to manage project timelines effectively. This can help in tracking progress and identifying any bottlenecks in the project workflow.

select
  s.board_id,
  b.name as board_name,
  b.type as board_type,
  s.id as sprint_id,
  s.name as sprint_name,
  start_date,
  end_date
from
  jira_sprint as s,
  jira_board as b
where
  s.board_id = b.id;

select
  s.board_id,
  b.name as board_name,
  b.type as board_type,
  s.id as sprint_id,
  s.name as sprint_name,
  start_date,
  end_date
from
  jira_sprint as s
  join jira_board as b on s.board_id = b.id;

Schema for jira_board

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
filter_id	bigint		Filter id of the board.
id	bigint	=	The ID of the board.
login_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the user login.
name	text		The name of the board.
self	text		The URL of the board details.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
sub_query	text		JQL subquery used by the given board - (Kanban only).
title	text		Title of the resource.
type	text		The board type of the board. Valid values are simple, scrum and kanban.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- jira

You can pass the configuration to the command with the --config argument:

steampipe_export_jira --config '<your_config>' jira_board