Skip to main content

acquired_plans

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

Overview

Nameacquired_plans
TypeResource
Idazure_stack.subscriptions_admin.acquired_plans

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringIdentifier in the tenant subscription context.
acquisitionIdstringAcquisition identifier.
acquisitionTimestring (date-time)Acquisition time.
externalReferenceIdstringExternal reference identifier.
planIdstringPlan identifier in the tenant subscription context.
provisioningStatestringState of the provisioning.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, targetSubscriptionId, planAcquisitionIdGets the specified plan acquired by a subscription consuming the offer.
listselectsubscriptionId, targetSubscriptionIdGet a collection of all acquired plans that subscription has access to.
createinsertsubscriptionId, targetSubscriptionId, planAcquisitionIdCreates an acquired plan.
deletedeletesubscriptionId, targetSubscriptionId, planAcquisitionIdDeletes an acquired 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
planAcquisitionIdstringThe plan acquisition Identifier
subscriptionIdstringSubscription credentials which uniquely identify Microsoft Azure subscription.The subscription ID forms part of the URI for every service call.
targetSubscriptionIdstringThe target subscription ID.

SELECT examples

Gets the specified plan acquired by a subscription consuming the offer.

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

INSERT examples

Creates an acquired plan.

INSERT INTO azure_stack.subscriptions_admin.acquired_plans (
data__acquisitionId,
data__id,
data__planId,
data__externalReferenceId,
data__provisioningState,
data__acquisitionTime,
subscriptionId,
targetSubscriptionId,
planAcquisitionId
)
SELECT
'{{ acquisitionId }}',
'{{ id }}',
'{{ planId }}',
'{{ externalReferenceId }}',
'{{ provisioningState }}',
'{{ acquisitionTime }}',
'{{ subscriptionId }}',
'{{ targetSubscriptionId }}',
'{{ planAcquisitionId }}'
RETURNING
id,
acquisitionId,
acquisitionTime,
externalReferenceId,
planId,
provisioningState
;

DELETE examples

Deletes an acquired plan.

DELETE FROM azure_stack.subscriptions_admin.acquired_plans
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND targetSubscriptionId = '{{ targetSubscriptionId }}' --required
AND planAcquisitionId = '{{ planAcquisitionId }}' --required
;