steampipe plugin install francois2metz/scalingo

Table: scalingo_app_event

List events associated to an app.

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

Examples

List all events of an application

select
created_at type,
user_username
from
scalingo_app_event
where
app_name = 'caresteouvert-api';

Filter by type edit_variables

select
created_at,
type,
user_username
from
scalingo_app_event
where
app_name = 'caresteouvert-api'
and type = 'edit_variables';

Schema for scalingo_app_event

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
app_idtextID of the application where the event belong.
app_nametext=Name of the app.
created_attimestamp with time zoneCreation date of the event.
idtextUnique ID identifying the event.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
typetextType of the event.
user_emailtextEmail of the user.
user_idtextUnique id of the user.
user_usernametextUsername of the user.