Skip to content

aws.ssm.describe_automation_step_executions

Example SQL Queries

SELECT * FROM
aws.ssm.describe_automation_step_executions
WHERE
"automation_execution_id" = 'VALUE';

Description

Information about all active and terminated step executions in an Automation workflow.

Table Definition

Column NameColumn Data Type
automation_execution_id Required Input Column

The Automation execution ID for which you want step execution descriptions.

VARCHAR
filters Input Column

One or more filters to limit the number of step executions returned by the request.

STRUCT(
"key" VARCHAR,
"values" VARCHAR[]
)[]
Show child fields
filters[]
Show child fields
filters[].key

One or more keys to limit the results.

filters[].values[]
reverse_order Input Column

Indicates whether to list step executions in reverse order by start time. The default value is 'false'.

BOOLEAN
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
action

The action this step performs. The action determines the behavior of the step.

VARCHAR
execution_end_time

If a step has finished execution, this contains the time the execution ended. If the step hasn't yet concluded, this field isn't populated.

TIMESTAMP_S
execution_start_time

If a step has begun execution, this contains the time the step started. If the step is in Pending status, this field isn't populated.

TIMESTAMP_S
failure_details

Information about the Automation failure.

STRUCT(
"failure_stage" VARCHAR,
"failure_type" VARCHAR,
"details" MAP(VARCHAR, VARCHAR[])
)
Show child fields
failure_details.details

Detailed information about the Automation step failure.

failure_details.failure_stage

The stage of the Automation execution when the failure occurred. The stages include the following: InputValidation, PreVerification, Invocation, PostVerification.

failure_details.failure_type

The type of Automation failure. Failure types include the following: Action, Permission, Throttling, Verification, Internal.

failure_message

If a step failed, this message explains why the execution failed.

VARCHAR
inputs

Fully-resolved values passed into the step before execution.

MAP(VARCHAR, VARCHAR)
is_critical

The flag which can be used to help decide whether the failure of current step leads to the Automation failure.

BOOLEAN
is_end

The flag which can be used to end automation no matter whether the step succeeds or fails.

BOOLEAN
max_attempts

The maximum number of tries to run the action of the step. The default value is 1.

BIGINT
next_step

The next step after the step succeeds.

VARCHAR
on_failure

The action to take if the step fails. The default value is Abort.

VARCHAR
outputs

Returned values from the execution of the step.

MAP(VARCHAR, VARCHAR[])
overridden_parameters

A user-specified list of parameters to override when running a step.

MAP(VARCHAR, VARCHAR[])
parent_step_details

Information about the parent step.

STRUCT(
"step_execution_id" VARCHAR,
"step_name" VARCHAR,
"action" VARCHAR,
"iteration" BIGINT,
"iterator_value" VARCHAR
)
Show child fields
parent_step_details.action

The name of the automation action.

parent_step_details.iteration

The current repetition of the loop represented by an integer.

parent_step_details.iterator_value

The current value of the specified iterator in the loop.

parent_step_details.step_execution_id

The unique ID of a step execution.

parent_step_details.step_name

The name of the step.

response

A message associated with the response code for an execution.

VARCHAR
response_code

The response code returned by the execution of the step.

VARCHAR
step_execution_id

The unique ID of a step execution.

VARCHAR
step_name

The name of this execution step.

VARCHAR
step_status

The execution status for this step.

VARCHAR
target_location

The combination of Amazon Web Services Regions and Amazon Web Services accounts targeted by the current Automation execution.

STRUCT(
"accounts" VARCHAR[],
"regions" VARCHAR[],
"target_location_max_concurrency" VARCHAR,
"target_location_max_errors" VARCHAR,
"execution_role_name" VARCHAR,
"target_location_alarm_configuration" STRUCT(
"ignore_poll_alarm_failure" BOOLEAN,
"alarms" STRUCT(
"name" VARCHAR
)[]
)
)
Show child fields
target_location.accounts[]
target_location.execution_role_name

The Automation execution role used by the currently running Automation. If not specified, the default value is AWS-SystemsManager-AutomationExecutionRole.

target_location.regions[]
target_location.target_location_alarm_configuration

The details for the CloudWatch alarm you want to apply to an automation or command.

Show child fields
target_location.target_location_alarm_configuration.alarms[]
Show child fields
target_location.target_location_alarm_configuration.alarms[].name

The name of your CloudWatch alarm.

target_location.target_location_alarm_configuration.ignore_poll_alarm_failure

When this value is true, your automation or command continues to run in cases where we can’t retrieve alarm status information from CloudWatch. In cases where we successfully retrieve an alarm status of OK or INSUFFICIENT_DATA, the automation or command continues to run, regardless of this value. Default is false.

target_location.target_location_max_concurrency

The maximum number of Amazon Web Services Regions and Amazon Web Services accounts allowed to run the Automation concurrently.

target_location.target_location_max_errors

The maximum number of errors allowed before the system stops queueing additional Automation executions for the currently running Automation.

targets

The targets for the step execution.

STRUCT(
"key" VARCHAR,
"values" VARCHAR[]
)[]
Show child fields
targets[]
Show child fields
targets[].key

User-defined criteria for sending commands that target managed nodes that meet the criteria.

targets[].values[]
timeout_seconds

The timeout seconds of the step.

BIGINT
triggered_alarms

The CloudWatch alarms that were invoked by the automation.

STRUCT(
"name" VARCHAR,
"state" VARCHAR
)[]
Show child fields
triggered_alarms[]
Show child fields
triggered_alarms[].name

The name of your CloudWatch alarm.

triggered_alarms[].state

The state of your CloudWatch alarm.

valid_next_steps

Strategies used when step fails, we support Continue and Abort. Abort will fail the automation when the step fails. Continue will ignore the failure of current step and allow automation to run the next step. With conditional branching, we add step:stepName to support the automation to go to another specific step.

VARCHAR[]
Show child fields
valid_next_steps[]