Skip to content
AWS for Query.Farm

aws.proton.list_service_instances

Example SQL Queries

SELECT * FROM
aws.proton.list_service_instances;

Description

List service instances with summary data. This action lists service instances of all services in the Amazon Web Services account.

Table Definition

Column NameColumn Data Type
filters Input Column

An array of filtering criteria that scope down the result list. By default, all service instances in the Amazon Web Services account are returned.

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

The name of a filtering criterion.

filters[].value

A value to filter by.

With the date/time keys (*At{Before,After}), the value is a valid RFC 3339 string with no UTC offset and with an optional fractional precision (for example, 1985-04-12T23:20:50.52Z).

service_name Input Column

The name of the service that the service instance belongs to.

VARCHAR
sort_by Input Column

The field that the result list is sorted by.

When you choose to sort by serviceName, service instances within each service are sorted by service instance name.

Default: serviceName 

VARCHAR
sort_order Input Column

Result list sort order.

Default: ASCENDING 

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
arn

The Amazon Resource Name (ARN) of the service instance.

VARCHAR
created_at

The time when the service instance was created.

TIMESTAMP_S
deployment_status

The service instance deployment status.

VARCHAR
deployment_status_message

A service instance deployment status message.

VARCHAR
environment_name

The name of the environment that the service instance was deployed into.

VARCHAR
last_attempted_deployment_id

The ID of the last attempted deployment of this service instance.

VARCHAR
last_deployment_attempted_at

The time when a deployment of the service was last attempted.

TIMESTAMP_S
last_deployment_succeeded_at

The time when the service was last deployed successfully.

TIMESTAMP_S
last_succeeded_deployment_id

The ID of the last successful deployment of this service instance.

VARCHAR
name

The name of the service instance.

VARCHAR
template_major_version

The service instance template major version.

VARCHAR
template_minor_version

The service instance template minor version.

VARCHAR
template_name

The name of the service template.

VARCHAR