steampipe plugin install francois2metz/scalingo

Table: scalingo_notifier

List notifier associated to an app.

The scalingo_notifier table can be used to query information about notifier, and you must specify which application in the where or join clause using the app_name column.

Examples

List notifiers of an application

select
name,
type
from
scalingo_notifier
where
app_name = 'caresteouvert-api';

List active notifiers of an application

select
name,
type
from
scalingo_notifier
where
app_name = 'caresteouvert-api'
and active;

List notifiers of an application posting to slack

select
name,
type
from
scalingo_notifier
where
app_name = 'caresteouvert-api'
and type = 'slack';

List events type associated to notifiers

select
n.name,
e.name
from
scalingo_notifier as n,
jsonb_array_elements_text(n.selected_event_ids) as event_id,
scalingo_event_type as e
where
e.id = event_id
and n.app_name = 'caresteouvert-api';

Schema for scalingo_notifier

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
activebooleanIs the notifier active or not.
app_idtextID of the application which owns the notifier.
app_nametext=Name of the app.
created_attimestamp with time zoneDate of creation of the notifier.
idtextUnique ID identifying the notifier.
nametextName of the notifier.
platform_idtextNotification platform used by this notifer.
selected_event_idsjsonbList of events accepted by this notifier.
send_all_alertsbooleanShould the notifier accept all alerts.
send_all_eventsbooleanShould the notifier accept all events.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
typetextNotifier type.
type_datajsonbNotification platform dependant additional data
updated_attimestamp with time zoneWhen was the notifier updated.