support_plan_types

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

Overview

Name	support_plan_types
Type	Resource
Id	azure_extras.addons.support_plan_types

Fields

vw_support_plan_types

Name	Datatype	Description
id	string	The id of the ARM resource, e.g. "/subscriptions/{id}/providers/Microsoft.Addons/supportProvider/{supportProviderName}/supportPlanTypes/{planTypeName}".
name	string	The name of the Canonical support plan, i.e. "essential", "standard" or "advanced".
planTypeName	text	field from the properties object
providerName	text	field from the properties object
provisioning_state	text	field from the properties object
subscriptionId	text	field from the properties object
type	string	Microsoft.Addons/supportProvider

support_plan_types

Name	Datatype	Description
id	string	The id of the ARM resource, e.g. "/subscriptions/{id}/providers/Microsoft.Addons/supportProvider/{supportProviderName}/supportPlanTypes/{planTypeName}".
name	string	The name of the Canonical support plan, i.e. "essential", "standard" or "advanced".
properties	object	The properties of the Canonical support plan.
type	string	Microsoft.Addons/supportProvider

Methods

Name	Accessible by	Required Params	Description
get	SELECT	planTypeName, providerName, subscriptionId	Returns whether or not the canonical support plan of type {type} is enabled for the subscription.
list_info	SELECT	subscriptionId	Returns the canonical support plan information for all types for the subscription.
create_or_update	INSERT	planTypeName, providerName, subscriptionId	Creates or updates the Canonical support plan of type {type} for the subscription.
delete	DELETE	planTypeName, providerName, subscriptionId	Cancels the Canonical support plan of type {type} for the subscription.

SELECT examples

Returns the canonical support plan information for all types for the subscription.

vw_support_plan_types

SELECT
id,
name,
planTypeName,
providerName,
provisioning_state,
subscriptionId,
type
FROM azure_extras.addons.vw_support_plan_types
WHERE subscriptionId = '{{ subscriptionId }}';

support_plan_types

SELECT
id,
name,
properties,
type
FROM azure_extras.addons.support_plan_types
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.addons.support_plan_types (
planTypeName,
providerName,
subscriptionId
)
SELECT 
'{{ planTypeName }}',
'{{ providerName }}',
'{{ subscriptionId }}'
;

Manifest

- name: your_resource_model_name
  props: []

DELETE example

Deletes the specified support_plan_types resource.

/*+ delete */
DELETE FROM azure_extras.addons.support_plan_types
WHERE planTypeName = '{{ planTypeName }}'
AND providerName = '{{ providerName }}'
AND subscriptionId = '{{ subscriptionId }}';