Reserved Instances Utilization Report Automation

Basic Parameters
Advanced Parameters
Example Output
Workflow Library Example

Lists the reservations details for provided date range.

External DocumentationTo learn more, visit the Azure documentation.

Basic Parameters

Parameter	Description
Billing Account ID	Your Azure Billing account ID. Can be obtained by using the `List Billing Account ID` action.
Billing Profile ID	Your Azure Billing profile ID. Can be obtained by using the `List Billing Profile ID` action.
Filter	Filter reservation details by date range. The properties/UsageDate for start date and end date. The filter supports ‘le’ and ‘ge’. Not applicable when querying with billing profile.

Advanced Parameters

Parameter	Description
End Date	End date. Only applicable when querying with billing profile.
Reservation ID	Filter to a specific reservation by GUID. Only valid if reservationOrderId is also provided.
Reservation Order ID	Filter to a specific reservation order by GUID. Required if reservationId is provided.
Start Date	Start date. Only applicable when querying with billing profile.

Example Output

{
	"value": [
		{
			"id": "/providers/Microsoft.Billing/billingAccounts/12345/providers/Microsoft.Consumption/reservationDetails/reservationDetails_Id1",
			"name": "reservationDetails_Id1",
			"type": "Microsoft.Consumption/reservationDetails",
			"tags": null,
			"properties": {
				"reservationOrderId": "00000000-0000-0000-0000-000000000000",
				"reservationId": "00000000-0000-0000-0000-000000000000",
				"usageDate": "2017-11-30T00:00:00-08:00",
				"skuName": "Standard_D2s_v3",
				"instanceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourcegroups/sqlh1/providers/microsoft.compute/virtualmachines/sqlh1",
				"totalReservedQuantity": 0,
				"reservedHours": 48,
				"usedHours": 0.6,
				"instanceFlexibilityGroup": "DSv3 Series",
				"instanceFlexibilityRatio": "1"
			}
		}
	]
}