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_idfrom jira_user;
+-------------------------------+-----------+--------+-----------------------------+| display_name | type | status | account_id |+-------------------------------+-----------+--------+-----------------------------+| Confluence Analytics (System) | app | true | 557058:cbc04d7be567aa5332c6 || John Smyth | atlassian | true | 1f2e1d34e0e56a001ea44fc1 |+-------------------------------+-----------+--------+-----------------------------+
Documentation
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