savings_plan_orders

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

Overview

Name	savings_plan_orders
Type	Resource
Id	azure.billing_benefits.savings_plan_orders

Fields

vw_savings_plan_orders

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
benefit_start_time	text	field from the properties object
billing_account_id	text	field from the properties object
billing_plan	text	field from the properties object
billing_profile_id	text	field from the properties object
billing_scope_id	text	field from the properties object
customer_id	text	field from the properties object
display_name	text	field from the properties object
expiry_date_time	text	field from the properties object
extended_status_info	text	field from the properties object
plan_information	text	field from the properties object
provisioning_state	text	field from the properties object
savingsPlanOrderId	text	field from the properties object
savings_plans	text	field from the properties object
sku	text	The resource model definition representing SKU
system_data	text	field from the properties object
term	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

savings_plan_orders

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	Savings plan order properties
sku	object	The resource model definition representing SKU
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	savingsPlanOrderId	Get a savings plan order.
list	SELECT		List all Savings plan orders.
elevate	EXEC	savingsPlanOrderId	Elevate as owner on savings plan order based on billing permissions.

SELECT examples

List all Savings plan orders.

vw_savings_plan_orders

SELECT
id,
name,
benefit_start_time,
billing_account_id,
billing_plan,
billing_profile_id,
billing_scope_id,
customer_id,
display_name,
expiry_date_time,
extended_status_info,
plan_information,
provisioning_state,
savingsPlanOrderId,
savings_plans,
sku,
system_data,
term,
type
FROM azure.billing_benefits.vw_savings_plan_orders
;

savings_plan_orders

SELECT
id,
name,
properties,
sku,
systemData,
type
FROM azure.billing_benefits.savings_plan_orders
;