Skip to main content

provisioned_product_plans

Creates, updates, deletes, gets or lists a provisioned_product_plans resource.

Overview

Nameprovisioned_product_plans
TypeResource
Idaws.servicecatalog.provisioned_product_plans

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
next_page_tokenstringThe page token to use to retrieve the next set of results. If there are no additional results, this value is null. (pattern: <code>[\u0009\u000a\u000d\u0020-\uD7FF\uE000-\uFFFD]*</code>)
provisioned_product_plan_detailsobjectInformation about the plan.
resource_changesarrayInformation about the resource changes that will occur when the plan is executed.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_provisioned_product_planselectregionGets information about the resource changes for the specified plan.
list_provisioned_product_plansselectregionLists the plans for the specified provisioned product or all plans to which the user has access.
create_provisioned_product_planinsertregion, PlanName, PlanType, ProductId, ProvisionedProductName, ProvisioningArtifactId, IdempotencyTokenCreates a plan. A plan includes the list of resources to be created (when provisioning a new product) or modified (when updating a provisioned product) when the plan is executed. You can create one plan for each provisioned product. To create a plan for an existing provisioned product, the product status must be AVAILABLE or TAINTED. To view the resource changes in the change set, use DescribeProvisionedProductPlan. To create or modify the provisioned product, use ExecuteProvisionedProductPlan.
delete_provisioned_product_plandeleteregionDeletes the specified plan.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

SELECT examples

Gets information about the resource changes for the specified plan.

SELECT
next_page_token,
provisioned_product_plan_details,
resource_changes
FROM aws.servicecatalog.provisioned_product_plans
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a plan. A plan includes the list of resources to be created (when provisioning a new product) or modified (when updating a provisioned product) when the plan is executed. You can create one plan for each provisioned product. To create a plan for an existing provisioned product, the product status must be AVAILABLE or TAINTED. To view the resource changes in the change set, use DescribeProvisionedProductPlan. To create or modify the provisioned product, use ExecuteProvisionedProductPlan.

INSERT INTO aws.servicecatalog.provisioned_product_plans (
AcceptLanguage,
PlanName,
PlanType,
NotificationArns,
PathId,
ProductId,
ProvisionedProductName,
ProvisioningArtifactId,
ProvisioningParameters,
IdempotencyToken,
Tags,
region
)
SELECT
'{{ AcceptLanguage }}',
'{{ PlanName }}' /* required */,
'{{ PlanType }}' /* required */,
'{{ NotificationArns }}',
'{{ PathId }}',
'{{ ProductId }}' /* required */,
'{{ ProvisionedProductName }}' /* required */,
'{{ ProvisioningArtifactId }}' /* required */,
'{{ ProvisioningParameters }}',
'{{ IdempotencyToken }}' /* required */,
'{{ Tags }}',
'{{ region }}'
RETURNING
plan_id,
plan_name,
provision_product_id,
provisioned_product_name,
provisioning_artifact_id
;

DELETE examples

Deletes the specified plan.

DELETE FROM aws.servicecatalog.provisioned_product_plans
WHERE region = '{{ region }}' --required
;