acquired_plans

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

Overview

Name	acquired_plans
Type	Resource
Id	azure_stack.subscriptions_admin.acquired_plans

Fields

Name	Datatype	Description
id	string	Identifier in the tenant subscription context.
acquisitionId	string	Acquisition identifier.
acquisitionTime	string	Acquisition time.
externalReferenceId	string	External reference identifier.
planId	string	Plan identifier in the tenant subscription context.
provisioningState	string	Provisioning state for subscriptions service resources, for example, resource provider registration.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	planAcquisitionId, subscriptionId, targetSubscriptionId	Gets the specified plan acquired by a subscription consuming the offer.
list	SELECT	subscriptionId, targetSubscriptionId	Get a collection of all acquired plans that subscription has access to.
create	INSERT	planAcquisitionId, subscriptionId, targetSubscriptionId	Creates an acquired plan.
delete	DELETE	planAcquisitionId, subscriptionId, targetSubscriptionId	Deletes an acquired plan.

SELECT examples

Get a collection of all acquired plans that subscription has access to.

SELECT
id,
acquisitionId,
acquisitionTime,
externalReferenceId,
planId,
provisioningState
FROM azure_stack.subscriptions_admin.acquired_plans
WHERE subscriptionId = '{{ subscriptionId }}'
AND targetSubscriptionId = '{{ targetSubscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new acquired_plans resource.

All Properties

/*+ create */
INSERT INTO azure_stack.subscriptions_admin.acquired_plans (
planAcquisitionId,
subscriptionId,
targetSubscriptionId,
acquisitionId,
id,
planId,
externalReferenceId,
provisioningState,
acquisitionTime
)
SELECT 
'{{ planAcquisitionId }}',
'{{ subscriptionId }}',
'{{ targetSubscriptionId }}',
'{{ acquisitionId }}',
'{{ id }}',
'{{ planId }}',
'{{ externalReferenceId }}',
'{{ provisioningState }}',
'{{ acquisitionTime }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: acquisitionId
      value: string
    - name: id
      value: string
    - name: planId
      value: string
    - name: externalReferenceId
      value: string
    - name: provisioningState
      value: []
    - name: acquisitionTime
      value: string

DELETE example

Deletes the specified acquired_plans resource.

/*+ delete */
DELETE FROM azure_stack.subscriptions_admin.acquired_plans
WHERE planAcquisitionId = '{{ planAcquisitionId }}'
AND subscriptionId = '{{ subscriptionId }}'
AND targetSubscriptionId = '{{ targetSubscriptionId }}';