steampipe plugin install jira

Table: jira_project - Query Jira Projects using SQL

Jira is a popular project management tool used by software development teams to plan, track, and release software. It offers a range of features including bug tracking, issue tracking, and project management functionalities. Jira Projects are the primary containers in Jira where issues are created and tracked.

Table Usage Guide

The jira_project table provides insights into Projects within Jira. As a Project Manager or a Scrum Master, you can explore project-specific details through this table, including project key, project type, project lead, and project category. Use it to uncover information about projects, such as the project's status, the lead responsible for the project, and the category the project belongs to.

Examples

Basic info

Explore the different projects within your Jira environment, gaining insights into key aspects like the project's name, ID, key, lead display name, category, and description. This can be useful for understanding the scope and management of your projects.

select
name,
id,
key,
lead_display_name,
project_category,
description
from
jira_project;
select
name,
id,
key,
lead_display_name,
project_category,
description
from
jira_project;

List all issues in a project

Explore the status and details of all issues within a specific project. This can be useful for project management, allowing you to assess the workload and track the progress of tasks.

select
id,
key,
project_id,
project_key,
created,
creator_display_name,
assignee_display_name,
status,
summary
from
jira_issue
where
project_key = 'TEST';
select
id,
key,
project_id,
project_key,
created,
creator_display_name,
assignee_display_name,
status,
summary
from
jira_issue
where
project_key = 'TEST';

Schema for jira_project

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
component_idsjsonbList of the components contained in the project.
descriptiontextA brief description of the project.
emailtextAn email address associated with the project.
idtext=The ID of the project.
issue_typesjsonbList of the issue types available in the project.
keytext=The key of the project.
lead_account_idtextThe user account id of the project lead.
lead_display_nametextThe user display name of the project lead.
login_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier of the user login.
nametextThe name of the project.
project_categoryjsonbThe category the project belongs to.
project_type_keytext=The project type of the project. Valid values are software, service_desk and business.
propertiesjsonbThis resource represents project properties, which provide for storing custom data against a project.
selftextThe URL of the project details.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle of the resource.
urltextA link to information about this project, such as project documentation.

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_project