Skip to main content

reservations_summaries

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

Overview

Namereservations_summaries
TypeResource
Idazure.consumption.reservations_summaries

Fields

The following fields are returned by SELECT queries:

OK. The request has succeeded.

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
namestringThe name of the resource
propertiesobjectThe properties of the reservation summary. (title: Reservation Summary properties)
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
list_by_reservation_order_and_reservationselectreservationOrderId, reservationId, grain$filterLists the reservations summaries for daily or monthly grain. Note: ARM has a payload size limit of 12MB, so currently callers get 400 when the response size exceeds the ARM limit. In such cases, API call should be made with smaller date ranges.
list_by_reservation_orderselectreservationOrderId, grain$filterLists the reservations summaries for daily or monthly grain. Note: ARM has a payload size limit of 12MB, so currently callers get 400 when the response size exceeds the ARM limit. In such cases, API call should be made with smaller date ranges.
listselectresourceScope, grainstartDate, endDate, $filter, reservationId, reservationOrderIdLists the reservations summaries for the defined scope daily or monthly grain. Note: ARM has a payload size limit of 12MB, so currently callers get 400 when the response size exceeds the ARM limit. In such cases, API call should be made with smaller date ranges.

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
grainstringCan be daily or monthly
reservationIdstringId of the reservation
reservationOrderIdstringOrder Id of the reservation
resourceScopestringThe scope associated with reservations summaries operations. This includes '/providers/Microsoft.Billing/billingAccounts/{billingAccountId}' for BillingAccount scope (legacy), and '/providers/Microsoft.Billing/billingAccounts/{billingAccountId}/billingProfiles/{billingProfileId}' for BillingProfile scope (modern).
$filterstringRequired only for daily grain. The properties/UsageDate for start date and end date. The filter supports 'le' and 'ge'. Not applicable when querying with billing profile
endDatestringEnd date. Only applicable when querying with billing profile
reservationIdstringReservation Id GUID. Only valid if reservationOrderId is also provided. Filter to a specific reservation
reservationOrderIdstringReservation Order Id GUID. Required if reservationId is provided. Filter to a specific reservation order
startDatestringStart date. Only applicable when querying with billing profile

SELECT examples

Lists the reservations summaries for daily or monthly grain. Note: ARM has a payload size limit of 12MB, so currently callers get 400 when the response size exceeds the ARM limit. In such cases, API call should be made with smaller date ranges.

SELECT
id,
name,
properties,
type
FROM azure.consumption.reservations_summaries
WHERE reservationOrderId = '{{ reservationOrderId }}' -- required
AND reservationId = '{{ reservationId }}' -- required
AND grain = '{{ grain }}' -- required
AND $filter = '{{ $filter }}'
;