Skip to content
AWS for Query.Farm

aws.ssm.list_association_versions

Example SQL Queries

SELECT * FROM
aws.ssm.list_association_versions
WHERE
"association_id" = 'VALUE';

Description

Retrieves all versions of an association for a specific association ID.

Table Definition

Column NameColumn Data Type
association_id Required Input Column

The ID created by the system when the association was created.

VARCHAR
_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
apply_only_at_cron_interval

By default, when you create a new associations, the system runs it immediately after it is created and then according to the schedule you specified. Specify this option if you don't want an association to run immediately after you create it. This parameter isn't supported for rate expressions.

BOOLEAN
association_name

The name specified for the association version when the association version was created.

VARCHAR
association_version

The association version.

VARCHAR
calendar_names

The names or Amazon Resource Names (ARNs) of the Change Calendar type documents your associations are gated under. The associations for this version only run when that Change Calendar is open. For more information, see Amazon Web Services Systems Manager Change Calendar.

VARCHAR[]
Show child fields
calendar_names[]
compliance_severity

The severity level that is assigned to the association.

VARCHAR
created_date

The date the association version was created.

TIMESTAMP_S
document_version

The version of an Amazon Web Services Systems Manager document (SSM document) used when the association version was created.

VARCHAR
duration

The number of hours that an association can run on specified targets. After the resulting cutoff time passes, associations that are currently running are cancelled, and no pending executions are started on remaining targets.

BIGINT
max_concurrency

The maximum number of targets allowed to run the association at the same time. You can specify a number, for example 10, or a percentage of the target set, for example 10%. The default value is 100%, which means all targets run the association at the same time.

If a new managed node starts and attempts to run an association while Systems Manager is running MaxConcurrency associations, the association is allowed to run. During the next association interval, the new managed node will process its association within the limit specified for MaxConcurrency.

VARCHAR
max_errors

The number of errors that are allowed before the system stops sending requests to run the association on additional targets. You can specify either an absolute number of errors, for example 10, or a percentage of the target set, for example 10%. If you specify 3, for example, the system stops sending requests when the fourth error is received. If you specify 0, then the system stops sending requests after the first error is returned. If you run an association on 50 managed nodes and set MaxError to 10%, then the system stops sending the request when the sixth error is received.

Executions that are already running an association when MaxErrors is reached are allowed to complete, but some of these executions may fail as well. If you need to ensure that there won't be more than max-errors failed executions, set MaxConcurrency to 1 so that executions proceed one at a time.

VARCHAR
name

The name specified when the association was created.

VARCHAR
output_location

The location in Amazon S3 specified for the association when the association version was created.

STRUCT(
    "s3_location" STRUCT(
        "output_s3_region" VARCHAR,
        "output_s3_bucket_name" VARCHAR,
        "output_s3_key_prefix" VARCHAR
    )
)
Show child fields
output_location.s3_location

An S3 bucket where you want to store the results of this request.

Show child fields
output_location.s3_location.output_s3_bucket_name

The name of the S3 bucket.

output_location.s3_location.output_s3_key_prefix

The S3 bucket subfolder.

output_location.s3_location.output_s3_region

The Amazon Web Services Region of the S3 bucket.

parameters

Parameters specified when the association version was created.

MAP(VARCHAR, VARCHAR[])
schedule_expression

The cron or rate schedule specified for the association when the association version was created.

VARCHAR
schedule_offset

Number of days to wait after the scheduled day to run an association.

BIGINT
sync_compliance

The mode for generating association compliance. You can specify AUTO or MANUAL. In AUTO mode, the system uses the status of the association execution to determine the compliance status. If the association execution runs successfully, then the association is COMPLIANT. If the association execution doesn't run successfully, the association is NON-COMPLIANT.

In MANUAL mode, you must specify the AssociationId as a parameter for the PutComplianceItems API operation. In this case, compliance data isn't managed by State Manager, a capability of Amazon Web Services Systems Manager. It is managed by your direct call to the PutComplianceItems API operation.

By default, all associations use AUTO mode.

VARCHAR
target_locations

The combination of Amazon Web Services Regions and Amazon Web Services accounts where you wanted to run the association when this association version was created.

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_locations[]
Show child fields
target_locations[].accounts[]
target_locations[].execution_role_name

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

target_locations[].regions[]
target_locations[].target_location_alarm_configuration

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

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

The name of your CloudWatch alarm.

target_locations[].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_locations[].target_location_max_concurrency

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

target_locations[].target_location_max_errors

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

target_maps

A key-value mapping of document parameters to target resources. Both Targets and TargetMaps can't be specified together.

MAP(VARCHAR, VARCHAR[])[]
Show child fields
target_maps[]
targets

The targets specified for the association when the association version was created. 

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[]