Use SQL to query infrastructure including servers, networks, facilities and more from Opsgenie.
Download and install the latest Opsgenie plugin:
steampipe plugin install jplanckeel/opsgenie
Configure your credentials and config file.
Configure your account details in ~/.steampipe/config/opsgenie.spc
:
connection "steampipe-plugin-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'"
}
Run steampipe:
steampipe query
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 |
+--------------------------------------+------------------------------------+--------------------------------------------+
Prerequisites:
Clone:
git clone https://github.com/jplanckeel/steampipe-plugin-opsgenie.git
cd steampipe-plugin-opsgenie
Build, which automatically installs the new version to your ~/.steampipe/plugins
directory:
make
Configure the plugin:
cp config/* ~/.steampipe/config
vi ~/.steampipe/config/opsgenie.spc
Try it!
steampipe query
> .inspect opsgenie
Further reading:
Please see the contribution guidelines and our code of conduct. All contributions are subject to the Apache 2.0 open source license.
help wanted
issues: