steampipe plugin install francois2metz/scalingo

Table: scalingo_alert

List alerts associated to an app.

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

Examples

List alerts of an application

select
id,
disabled,
metric
from
scalingo_alert
where
app_name = 'caresteouvert-api';

List alerts which do not send notifications when triggered

select
id,
disabled,
container_type,
metric
from
scalingo_alert
where
app_name = 'caresteouvert-api'
and not send_when_below;

List alerts which are disabled

select
id,
container_type,
metric
from
scalingo_alert
where
app_name = 'caresteouvert-api'
and disabled;

Schema for scalingo_alert

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
app_idtextID of the application this alert applies to.
app_nametext=Name of the app.
container_typetextContainer type concerned by the alert.
created_attimestamp with time zoneCreation date of the alert.
disabledbooleanIs the alert disabled.
duration_before_triggerbigintAlert is triggered if the value is above the limit for the specified duration activated.
idtext=Unique ID, starts with “al-“.
limitdouble precisionThreshold to activate the alert.
metadatajsonbVarious data.
metrictextMetric name this alert is about.
remind_everytextSend the alert at regular interval when activated.
send_when_belowbooleanWill the alert be sent when the value goes above or below the limit.
updated_attimestamp with time zoneLast time the alert has been updated.