reservations

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

Overview

Name	reservations
Type	Resource
Id	azure.billing.reservations

Fields

vw_reservations

Name	Datatype	Description
applied_scope_properties	text	field from the properties object
applied_scope_type	text	field from the properties object
applied_scopes	text	field from the properties object
archived	text	field from the properties object
benefit_start_time	text	field from the properties object
billingAccountName	text	field from the properties object
billing_plan	text	field from the properties object
billing_scope_id	text	field from the properties object
capabilities	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
etag	integer	field from the properties object
expiry_date	text	field from the properties object
expiry_date_time	text	field from the properties object
extended_status_info	text	field from the properties object
instance_flexibility	text	field from the properties object
last_updated_date_time	text	field from the properties object
location	text	The location of the reservation.
merge_properties	text	field from the properties object
product_code	text	field from the properties object
provisioning_state	text	field from the properties object
provisioning_sub_state	text	field from the properties object
purchase_date	text	field from the properties object
purchase_date_time	text	field from the properties object
quantity	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
reservationId	text	field from the properties object
reservationOrderId	text	field from the properties object
reserved_resource_type	text	field from the properties object
review_date_time	text	field from the properties object
sku	text	The property of reservation sku object.
sku_description	text	field from the properties object
split_properties	text	field from the properties object
swap_properties	text	field from the properties object
tags	text	Resource Tags
term	text	field from the properties object
user_friendly_applied_scope_type	text	field from the properties object
user_friendly_renew_state	text	field from the properties object
utilization	text	field from the properties object

reservations

Name	Datatype	Description
etag	integer
location	string	The location of the reservation.
properties	object	The property of reservation object.
sku	object	The property of reservation sku object.
tags	object	Resource Tags

Methods

Name	Accessible by	Required Params	Description
get_by_reservation_order	SELECT	billingAccountName, reservationId, reservationOrderId	Get specific Reservation details in the billing account.
list_by_billing_account	SELECT	billingAccountName	Lists the reservations in the billing account and the roll up counts of reservations group by provisioning states.
list_by_billing_profile	SELECT	billingAccountName, billingProfileName	Lists the reservations for a billing profile and the roll up counts of reservations group by provisioning state.
list_by_reservation_order	SELECT	billingAccountName, reservationOrderId	List Reservations within a single ReservationOrder in the billing account.
update_by_billing_account	EXEC	billingAccountName, reservationId, reservationOrderId	Update reservation by billing account.

SELECT examples

Lists the reservations in the billing account and the roll up counts of reservations group by provisioning states.

vw_reservations

SELECT
applied_scope_properties,
applied_scope_type,
applied_scopes,
archived,
benefit_start_time,
billingAccountName,
billing_plan,
billing_scope_id,
capabilities,
display_name,
display_provisioning_state,
effective_date_time,
etag,
expiry_date,
expiry_date_time,
extended_status_info,
instance_flexibility,
last_updated_date_time,
location,
merge_properties,
product_code,
provisioning_state,
provisioning_sub_state,
purchase_date,
purchase_date_time,
quantity,
renew,
renew_destination,
renew_properties,
renew_source,
reservationId,
reservationOrderId,
reserved_resource_type,
review_date_time,
sku,
sku_description,
split_properties,
swap_properties,
tags,
term,
user_friendly_applied_scope_type,
user_friendly_renew_state,
utilization
FROM azure.billing.vw_reservations
WHERE billingAccountName = '{{ billingAccountName }}';

reservations

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