steampipe plugin install francois2metz/scalingosteampipe 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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
active	boolean		Is the notifier active or not.
app_id	text		ID of the application which owns the notifier.
app_name	text	=	Name of the app.
created_at	timestamp with time zone		Date of creation of the notifier.
id	text		Unique ID identifying the notifier.
name	text		Name of the notifier.
platform_id	text		Notification platform used by this notifer.
selected_event_ids	jsonb		List of events accepted by this notifier.
send_all_alerts	boolean		Should the notifier accept all alerts.
send_all_events	boolean		Should the notifier accept all events.
type	text		Notifier type.
type_data	jsonb		Notification platform dependant additional data
updated_at	timestamp with time zone		When was the notifier updated.