steampipe plugin install jira

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
filter_idbigintFilter id of the board.
idbigint=The ID of the board.
login_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier of the user login.
nametextThe name of the board.
selftextThe URL of the board details.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
sub_querytextJQL subquery used by the given board - (Kanban only).
titletextTitle of the resource.
typetextThe 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