Reserved Instances Utilization Report Automation

Lists the reservations details for provided date range.

External Documentation

To 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"
            }
        }
    ]
}

Workflow Library Example

Reserved Instances Utilization Report Automation with Azure and Send Results Via Email

Preview this Workflow on desktop