Table: jira_dashboard - Query Jira Dashboards using SQL

Jira Software is a project management tool developed by Atlassian. It provides a platform for planning, tracking, and releasing software, and is widely used by agile teams. A key feature of Jira Software are dashboards, which provide a customizable and flexible view of a project's progress and status.

Table Usage Guide

The jira_dashboard table provides insights into the various dashboards available within a Jira Software instance. As a project manager or team lead, explore dashboard-specific details through this table, including the owner, viewability, and associated projects. Utilize it to uncover information about dashboards, such as those that are shared with everyone, the ones owned by a specific user, and the projects associated with each dashboard.

Examples

Basic info

Gain insights into your favorite Jira dashboards and their respective owners. This can help you understand who is responsible for the dashboards you frequently use.

select
  id,
  name,
  is_favourite,
  owner_account_id,
  owner_display_name
from
  jira_dashboard;

select
  id,
  name,
  is_favourite,
  owner_account_id,
  owner_display_name
from
  jira_dashboard;

Explore which Jira dashboards have specific share permissions. This can help you understand how information is being disseminated, ensuring the right teams have access to the right data.

select
  id,
  name,
  owner_display_name,
  popularity,
  jsonb_pretty(share_permissions) as share_permissions
from
  jira_dashboard;

select
  id,
  name,
  owner_display_name,
  popularity,
  share_permissions
from
  jira_dashboard;

Schema for jira_dashboard

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
edit_permissions	jsonb		The details of any edit share permissions for the dashboard.
id	text	=	The ID of the dashboard.
is_favourite	boolean		Indicates if the dashboard is selected as a favorite by the user.
login_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the user login.
name	text		The name of the dashboard.
owner_account_id	text		The user info of owner of the dashboard.
owner_display_name	text		The user info of owner of the dashboard.
popularity	bigint		The number of users who have this dashboard as a favorite.
rank	bigint		The rank of this dashboard.
self	text		The URL of the dashboard details.
share_permissions	jsonb		The details of any view share permissions for the dashboard.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.
view	text		The URL of the dashboard.

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_dashboard