steampipe plugin install jira

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;

Get share permissions details

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
edit_permissionsjsonbThe details of any edit share permissions for the dashboard.
idtext=The ID of the dashboard.
is_favouritebooleanIndicates if the dashboard is selected as a favorite by the user.
nametextThe name of the dashboard.
owner_account_idtextThe user info of owner of the dashboard.
owner_display_nametextThe user info of owner of the dashboard.
popularitybigintThe number of users who have this dashboard as a favorite.
rankbigintThe rank of this dashboard.
selftextThe URL of the dashboard details.
share_permissionsjsonbThe details of any view share permissions for the dashboard.
titletextTitle of the resource.
viewtextThe 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