Skip to content

aws.servicecatalog.search_provisioned_products

Example SQL Queries

SELECT * FROM
aws.servicecatalog.search_provisioned_products;

Description

Gets information about the provisioned products that meet the specified criteria.

Table Definition

Column NameColumn Data Type
accept_language Input Column

The language code.

  • jp - Japanese

  • zh - Chinese

VARCHAR
access_level_filter Input Column

The access level to use to obtain results. The default is User.

STRUCT(
"key" VARCHAR,
"value" VARCHAR
)
Show child fields
access_level_filter.key

The access level.

  • Account - Filter results based on the account.

  • Role - Filter results based on the federated role of the specified user.

  • User - Filter results based on the specified user.

access_level_filter.value

The user to which the access level applies. The only supported value is self.

filters Input Column

The search filters.

When the key is SearchQuery, the searchable fields are arn, createdTime, id, lastRecordId, idempotencyToken, name, physicalId, productId, provisioningArtifactId, type, status, tags, userArn, userArnSession, lastProvisioningRecordId, lastSuccessfulProvisioningRecordId, productName, and provisioningArtifactName.

Example: "SearchQuery":["status:AVAILABLE"]

MAP(VARCHAR, VARCHAR[])
page_size Input Column

The maximum number of items to return with this call.

BIGINT
page_token Input Column

The page token for the next set of results. To retrieve the first set of results, use null.

VARCHAR
sort_by Input Column

The sort field. If no value is specified, the results are not sorted. The valid values are arn, id, name, and lastRecordId.

VARCHAR
sort_order Input Column

The sort order. If no value is specified, the results are not sorted.

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
next_page_token

The page token to use to retrieve the next set of results. If there are no additional results, this value is null.

VARCHAR
provisioned_products

Information about the provisioned products.

STRUCT(
"name" VARCHAR,
"arn" VARCHAR,
"type" VARCHAR,
"id" VARCHAR,
"status" VARCHAR,
"status_message" VARCHAR,
"created_time" TIMESTAMP_S,
"idempotency_token" VARCHAR,
"last_record_id" VARCHAR,
"last_provisioning_record_id" VARCHAR,
"last_successful_provisioning_record_id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"physical_id" VARCHAR,
"product_id" VARCHAR,
"product_name" VARCHAR,
"provisioning_artifact_id" VARCHAR,
"provisioning_artifact_name" VARCHAR,
"user_arn" VARCHAR,
"user_arn_session" VARCHAR
)[]
Show child fields
provisioned_products[]
Show child fields
provisioned_products[].arn

The ARN of the provisioned product.

provisioned_products[].created_time

The UTC time stamp of the creation time.

provisioned_products[].id

The identifier of the provisioned product.

provisioned_products[].idempotency_token

A unique identifier that you provide to ensure idempotency. If multiple requests differ only by the idempotency token, the same response is returned for each repeated request.

provisioned_products[].last_provisioning_record_id

The record identifier of the last request performed on this provisioned product of the following types:

  • ProvisionProduct

  • UpdateProvisionedProduct

  • ExecuteProvisionedProductPlan

  • TerminateProvisionedProduct

provisioned_products[].last_record_id

The record identifier of the last request performed on this provisioned product.

provisioned_products[].last_successful_provisioning_record_id

The record identifier of the last successful request performed on this provisioned product of the following types:

  • ProvisionProduct

  • UpdateProvisionedProduct

  • ExecuteProvisionedProductPlan

  • TerminateProvisionedProduct

provisioned_products[].name

The user-friendly name of the provisioned product.

provisioned_products[].physical_id

The assigned identifier for the resource, such as an EC2 instance ID or an S3 bucket name.

provisioned_products[].product_id

The product identifier.

provisioned_products[].product_name

The name of the product.

provisioned_products[].provisioning_artifact_id

The identifier of the provisioning artifact.

provisioned_products[].provisioning_artifact_name

The name of the provisioning artifact.

provisioned_products[].status

The current status of the provisioned product.

  • AVAILABLE - Stable state, ready to perform any operation. The most recent operation succeeded and completed.

  • UNDER_CHANGE - Transitive state. Operations performed might not have valid results. Wait for an AVAILABLE status before performing operations.

  • TAINTED - Stable state, ready to perform any operation. The stack has completed the requested operation but is not exactly what was requested. For example, a request to update to a new version failed and the stack rolled back to the current version.

  • ERROR - An unexpected error occurred. The provisioned product exists but the stack is not running. For example, CloudFormation received a parameter value that was not valid and could not launch the stack.

  • PLAN_IN_PROGRESS - Transitive state. The plan operations were performed to provision a new product, but resources have not yet been created. After reviewing the list of resources to be created, execute the plan. Wait for an AVAILABLE status before performing operations.

provisioned_products[].status_message

The current status message of the provisioned product.

provisioned_products[].tags[]
Show child fields
provisioned_products[].tags[].key

The tag key.

provisioned_products[].tags[].value

The value for this key.

provisioned_products[].type

The type of provisioned product. The supported values are CFN_STACK, CFN_STACKSET, TERRAFORM_OPEN_SOURCE, TERRAFORM_CLOUD, and EXTERNAL.

provisioned_products[].user_arn

The Amazon Resource Name (ARN) of the user.

provisioned_products[].user_arn_session

The ARN of the user in the session. This ARN might contain a session ID.

total_results_count

The number of provisioned products found.

BIGINT