savings_plan_orders

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

Overview

Name	savings_plan_orders
Type	Resource
Id	azure.billing.savings_plan_orders

Fields

vw_savings_plan_orders

Name	Datatype	Description
benefit_start_time	text	field from the properties object
billingAccountName	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
product_code	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 SKU to be applied for this resource
tags	text	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /
term	text	field from the properties object

savings_plan_orders

Name	Datatype	Description
properties	object	Savings plan order properties
sku	object	The SKU to be applied for this resource
tags	object	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /

Methods

Name	Accessible by	Required Params	Description
get_by_billing_account	SELECT	billingAccountName, savingsPlanOrderId	Get a savings plan order by billing account.
list_by_billing_account	SELECT	billingAccountName	List all Savings plan orders by billing account.

SELECT examples

List all Savings plan orders by billing account.

vw_savings_plan_orders

SELECT
benefit_start_time,
billingAccountName,
billing_account_id,
billing_plan,
billing_profile_id,
billing_scope_id,
customer_id,
display_name,
expiry_date_time,
extended_status_info,
plan_information,
product_code,
provisioning_state,
savingsPlanOrderId,
savings_plans,
sku,
tags,
term
FROM azure.billing.vw_savings_plan_orders
WHERE billingAccountName = '{{ billingAccountName }}';

savings_plan_orders

SELECT
properties,
sku,
tags
FROM azure.billing.savings_plan_orders
WHERE billingAccountName = '{{ billingAccountName }}';