> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Reserved Instances Utilization Report Automation

Lists the reservations details for provided date range.

<Note>
  External Documentation

  To learn more, visit the [Azure documentation](https://learn.microsoft.com/en-us/rest/api/consumption/reservations-details/list?view=rest-consumption-2023-05-01\&tabs=HTTP).
</Note>

## Basic Parameters

<div className="integrations-table">
  | Parameter          | Description                                                                                                                                                                                 |
  | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Billing Account ID | Your Azure Billing account ID.<br />Can be obtained by using the `List Billing Account ID` action.                                                                                          |
  | Billing Profile ID | Your Azure Billing profile ID.<br />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. <br />The filter supports 'le' and 'ge'. Not applicable when querying with billing profile. |
</div>

## Advanced Parameters

<div className="integrations-table">
  | 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.                              |
</div>

## Example Output

```json theme={"dark"}
{
	"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](https://library.blinkops.com/workflows/reserved-instances-utilization-report-automation-with-azure-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/reserved-instances-utilization-report-automation-with-azure-and-send-results-via-email/canvas" />
</div>
