steampipe plugin install marekjalovec/make

Table: make_scenario_log

Scenario Logs allow you to explore past runs of your scenarios.

Key columns

  • Provide a numeric scenario_id to query Scenario Logs for a specific Scenario. This can be either set directly in a where clause, or specified as part of join with another table.
  • Provide both a string id and a numeric scenario_id if you want to query for a specific Scenario Log.

Examples

List of all Scenario Logs

select
*
from
make_scenario_log
where
scenario_id = 1;

List all non-auto scenario runs (errors, manual, etc.)

select
*
from
make_scenario_log
where
scenario_id = 1
and type != 'auto';

Schema for make_scenario_log

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
author_idbigintAuthor User ID.
durationbigintDuration of the run in milliseconds.
idtext=The Scenario Log ID.
imt_idtextThe Internal execution ID.
instantbooleanInstant run?
operationsbigintNumber of operations consumed.
organization_idbigintThe Organization where the scenario belongs to.
scenario_idbigint=Virtual column, used to map the entity to another object.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statusbigintStatus of the run.
team_idbigintThe Team where the scenario belongs to.
timestamptimestamp with time zoneDate and time of the run.
titletextThe display name for the resource.
transferbigintTransfer consumed in bytes.
typetextType of the run.