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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
app_id	text		ID of the application where the event belong.
app_name	text	=	Name of the app.
created_at	timestamp with time zone		Creation date of the event.
id	text		Unique ID identifying the event.
type	text		Type of the event.
user_email	text		Email of the user.
user_id	text		Unique id of the user.
user_username	text		Username of the user.