savings_plans

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

Overview

Name	savings_plans
Type	Resource
Id	azure.billing.savings_plans

Fields

vw_savings_plans

Name	Datatype	Description
applied_scope_properties	text	field from the properties object
applied_scope_type	text	field from the properties object
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
commitment	text	field from the properties object
customer_id	text	field from the properties object
display_name	text	field from the properties object
display_provisioning_state	text	field from the properties object
effective_date_time	text	field from the properties object
expiry_date_time	text	field from the properties object
extended_status_info	text	field from the properties object
product_code	text	field from the properties object
provisioning_state	text	field from the properties object
purchase_date_time	text	field from the properties object
renew	text	field from the properties object
renew_destination	text	field from the properties object
renew_properties	text	field from the properties object
renew_source	text	field from the properties object
savingsPlanId	text	field from the properties object
savingsPlanOrderId	text	field from the properties object
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 < > % & \ ? /
term	text	field from the properties object
user_friendly_applied_scope_type	text	field from the properties object
utilization	text	field from the properties object

savings_plans

Name	Datatype	Description
properties	object	Savings plan 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, savingsPlanId, savingsPlanOrderId	Get savings plan by billing account.
list_by_billing_account	SELECT	billingAccountName	List savings plans by billing account.
list_by_savings_plan_order	SELECT	billingAccountName, savingsPlanOrderId	List savings plans in an order by billing account.
update_by_billing_account	EXEC	billingAccountName, savingsPlanId, savingsPlanOrderId	Update savings plan by billing account.
validate_update_by_billing_account	EXEC	billingAccountName, savingsPlanId, savingsPlanOrderId	Validate savings plan patch by billing account.

SELECT examples

List savings plans by billing account.

vw_savings_plans

SELECT
applied_scope_properties,
applied_scope_type,
benefit_start_time,
billingAccountName,
billing_account_id,
billing_plan,
billing_profile_id,
billing_scope_id,
commitment,
customer_id,
display_name,
display_provisioning_state,
effective_date_time,
expiry_date_time,
extended_status_info,
product_code,
provisioning_state,
purchase_date_time,
renew,
renew_destination,
renew_properties,
renew_source,
savingsPlanId,
savingsPlanOrderId,
sku,
tags,
term,
user_friendly_applied_scope_type,
utilization
FROM azure.billing.vw_savings_plans
WHERE billingAccountName = '{{ billingAccountName }}';

savings_plans

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