steampipe plugin install jirasteampipe plugin install jira

Jira + Steampipe

Jira provides on-demand cloud computing platforms and APIs to plan, track, and release great software.

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

For example:

select
  display_name,
  account_type as type,
  active as status,
  account_id
from
  jira_user;

+-------------------------------+-----------+--------+-----------------------------+
| display_name                  | type      | status | account_id                  |
+-------------------------------+-----------+--------+-----------------------------+
| Confluence Analytics (System) | app       | true   | 557058:cbc04d7be567aa5332c6 |
| John Smyth                    | atlassian | true   | 1f2e1d34e0e56a001ea44fc1    |
+-------------------------------+-----------+--------+-----------------------------+

Documentation

Table definitions & examples →

Get started

Install

Download and install the latest Jira plugin:

steampipe plugin install jira

Credentials

Item	Description
Credentials	Jira requires an API token, sit base url and username for all requests.
Radius	Each connection represents a single Jira site.

Configuration

Installing the latest jira plugin will create a config file (~/.steampipe/config/jira.spc) with a single connection named jira:

connection "jira" {
  plugin   = "jira"
  base_url = "https://your-domain.atlassian.net/"
  username = "abcd@xyz.com"
  token    = "wOABk1jLlKktmtg43ZHNh9D12"
}

base_url - The site url of your attlassian jira subscription.
username - Email address of agent user who have permission to access the API.
token - API token for user's Atlassian account.

Get involved

Open source: https://github.com/turbot/steampipe-plugin-jira
Community: Slack Channel

turbot/jira