plans

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

Overview

Name	plans
Type	Resource
Id	azure_stack.subscriptions_admin.plans

Fields

vw_plans

Name	Datatype	Description
id	text	URI of the resource.
name	text	Name of the resource.
description	text	field from the properties object
display_name	text	field from the properties object
external_reference_id	text	field from the properties object
location	text	Location of the resource
plan	text	field from the properties object
quota_ids	text	field from the properties object
resourceGroupName	text	field from the properties object
sku_ids	text	field from the properties object
subscriptionId	text	field from the properties object
subscription_count	text	field from the properties object
tags	text	List of key-value pairs.
type	text	Type of resource.

plans

Name	Datatype	Description
id	string	URI of the resource.
name	string	Name of the resource.
location	string	Location of the resource
properties	object	Properties of a plan.
tags	object	List of key-value pairs.
type	string	Type of resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	plan, resourceGroupName, subscriptionId	Get the specified plan.
list	SELECT	resourceGroupName, subscriptionId	Get the list of plans under a resource group.
list_all	SELECT	subscriptionId	List all plans across all subscriptions.
create_or_update	INSERT	plan, resourceGroupName, subscriptionId	Create or update the plan.
delete	DELETE	plan, resourceGroupName, subscriptionId	Delete the specified plan.

SELECT examples

List all plans across all subscriptions.

vw_plans

SELECT
id,
name,
description,
display_name,
external_reference_id,
location,
plan,
quota_ids,
resourceGroupName,
sku_ids,
subscriptionId,
subscription_count,
tags,
type
FROM azure_stack.subscriptions_admin.vw_plans
WHERE subscriptionId = '{{ subscriptionId }}';

plans

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure_stack.subscriptions_admin.plans
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_stack.subscriptions_admin.plans (
plan,
resourceGroupName,
subscriptionId,
properties,
location
)
SELECT 
'{{ plan }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: description
          value: string
        - name: displayName
          value: string
        - name: externalReferenceId
          value: string
        - name: quotaIds
          value:
            - string
        - name: name
          value: string
        - name: subscriptionCount
          value: integer
        - name: skuIds
          value:
            - string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

DELETE example

Deletes the specified plans resource.

/*+ delete */
DELETE FROM azure_stack.subscriptions_admin.plans
WHERE plan = '{{ plan }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';