Skip to main content

reservation_order_alias

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

Overview

Namereservation_order_alias
TypeResource
Idazure.billing_benefits.reservation_order_alias

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
appliedScopePropertiesobjectProperties specific to applied scope type. Not required if not applicable.
appliedScopeTypestringType of the Applied Scope. Known values are: "Single", "Shared", and "ManagementGroup". (Single, Shared, ManagementGroup)
billingPlanstringRepresents the billing plan in ISO 8601 format. Required only for monthly billing plans. "P1M" (P1M)
billingScopeIdstringSubscription that will be charged for purchasing the benefit.
displayNamestringDisplay name.
locationstringThe Azure Region where the reserved resource lives.
provisioningStatestringProvisioning state. Known values are: "Creating", "PendingBilling", "ConfirmedBilling", "Created", "Succeeded", "Cancelled", "Expired", and "Failed". (Creating, PendingBilling, ConfirmedBilling, Created, Succeeded, Cancelled, Expired, Failed)
quantityintegerTotal Quantity of the SKUs purchased in the Reservation.
renewbooleanSetting this to true will automatically purchase a new benefit on the expiration date time.
reservationOrderIdstringIdentifier of the reservation order created.
reservedResourcePropertiesobjectProperties specific to each reserved resource type. Not required if not applicable.
reservedResourceTypestringThe type of the resource that is being reserved. Known values are: "VirtualMachines", "SqlDatabases", "SuseLinux", "CosmosDb", "RedHat", "SqlDataWarehouse", "VMwareCloudSimple", "RedHatOsa", "Databricks", "AppService", "ManagedDisk", "BlockBlob", "RedisCache", "AzureDataExplorer", "MySql", "MariaDb", "PostgreSql", "DedicatedHost", "SapHana", "SqlAzureHybridBenefit", "AVS", "DataFactory", "NetAppStorage", "AzureFiles", "SqlEdge", and "VirtualMachineSoftware". (VirtualMachines, SqlDatabases, SuseLinux, CosmosDb, RedHat, SqlDataWarehouse, VMwareCloudSimple, RedHatOsa, Databricks, AppService, ManagedDisk, BlockBlob, RedisCache, AzureDataExplorer, MySql, MariaDb, PostgreSql, DedicatedHost, SapHana, SqlAzureHybridBenefit, AVS, DataFactory, NetAppStorage, AzureFiles, SqlEdge, VirtualMachineSoftware)
reviewDateTimestring (date-time)This is the date-time when the Reservation needs to be reviewed.
skuobjectReservation order SKU. Required.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
termstringRepresent benefit term in ISO 8601 format. Known values are: "P1M", "P1Y", "P3Y", and "P5Y". (P1M, P1Y, P3Y, P5Y)
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectreservation_order_alias_nameGet a reservation order alias.
createinsertreservation_order_alias_name, skuCreate a reservation order alias.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
reservation_order_alias_namestringName of the reservation order alias. Required.

SELECT examples

Get a reservation order alias.

SELECT
id,
name,
appliedScopeProperties,
appliedScopeType,
billingPlan,
billingScopeId,
displayName,
location,
provisioningState,
quantity,
renew,
reservationOrderId,
reservedResourceProperties,
reservedResourceType,
reviewDateTime,
sku,
systemData,
term,
type
FROM azure.billing_benefits.reservation_order_alias
WHERE reservation_order_alias_name = '{{ reservation_order_alias_name }}' -- required
;

INSERT examples

Create a reservation order alias.

INSERT INTO azure.billing_benefits.reservation_order_alias (
sku,
location,
properties,
reservation_order_alias_name
)
SELECT
'{{ sku }}' /* required */,
'{{ location }}',
'{{ properties }}',
'{{ reservation_order_alias_name }}'
RETURNING
id,
name,
location,
properties,
sku,
systemData,
type
;