steampipe plugin install jplanckeel/opsgenie

Opsgenie + Steampipe

Opsgenie provides on-call and alert management to keep services always one.

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

List teams in your Opsgenie account:

select
team_id,
name,
description
from
opsgenie_team;
+--------------------------------------+------------------------------------+--------------------------------------------+
| team_id | name | description |
+--------------------------------------+------------------------------------+--------------------------------------------+
| 8cfdd4da-73e9-4526-be90-02111f2f2f1f | Infra_Team | Infrastructure Team |
| 555d4f34-46d5-41b6-88bd-12df8z1f7104 | Dev_Team | Developper Team |
+--------------------------------------+------------------------------------+--------------------------------------------+

Documentation

Quick start

Install

Download and install the latest Opsgenie plugin:

steampipe plugin install jplanckeel/opsgenie

Credentials

ItemDescription
CredentialsOpsgenie requires an API key for all requests.
PermissionsAPI keys have the same permissions as the user who creates them, and if the user permissions change, the API key permissions also change.
RadiusEach connection represents a single Opsgenie Installation.
ResolutionCredentials explicitly set in a steampipe config file (~/.steampipe/config/opsgenie.spc)

Configuration

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

Configure your account details in ~/.steampipe/configopsgenie.spc:

connection "opsgenie" {
plugin = "jplanckeel/opsgenie"
# URL to access the API (required).
# If using the EU instance of Opsgenie, the URL needs to be api.eu.opsgenie.com for requests to be successful.
# url = "api.opsgenie.com"
# API token for your opsgenie instance (required).
# See https://docs.opsgenie.com/docs/api-access-management
# token = "5c44f27d-8dd5-4939-aa5f-499d8cssf64a"
# To filter request you can add opsgenie query
# query = "status: open AND responders: 'My_Team'"
}
  • url - The site url of your attlassian opsgenie subscription.
  • token - API token for user's Atlassian account.
  • query - Query to filter alert Query.

Alternatively, you can also use the standard Opsgenie environment variables to obtain credentials only if other arguments (url, token) are not specified in the connection:

export OPSGENIE_URL=https://your-domain.atlassian.net/
export OPSGENIE_TOKEN=8WqcdT0rvIZpCjtDqReF48B1

Get involved