Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,575 questions
How can we map azure reservation with the retail price.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 94%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Manish Kumar
0
Reputation points
Thank you in advance for attempting to solve this issue
My organization has multiple Azure tenants, underneath we have 100+ subscriptions. We make a lot of reservations to save costs. However, as an analyst, I am trying to build an automated report that can map reservations with the retail price and determine how much savings we made using the reservation. I am using the below APIs to map the cost.
-
Retail Price public API: https://prices.azure.com/api/retail/prices?api-version=2023-01-01-preview&meterRegion='primary' -
Reservation Orders: GET https://management.azure.com/providers/Microsoft.Capacity/reservationOrders?api-version=2022-11-01 -
Reservation Transactions: GET https://management.azure.com/providers/Microsoft.Billing/billingAccounts/123456/providers/Microsoft.Consumption/reservationTransactions?$filter=properties/eventDate+ge+2020-05-20+AND+properties/eventDate+le+2020-05-30&api-version=2024-08-01&useMarkupIfPartner=True&previewMarkupPercentage=15.5
I am using ReservationOrderId to join reservation orders and transactions.
To Join the retail price I could find armSKUName and armRegion. However, there are multiple options available for armSKUName and armRegion. That causes duplicates. What I could find in retail price is, MeterId, SKUId, and ProductId what makes it unique, however, I cannot get such details from reservation orders or transactions.
I am trying to understand if there is any API that can uniquely map to the retail price with the reservation. It would be a great help for me and the community if you have encountered the same and found a solution.
{count} votes
-
SadiqhAhmed-MSFT 45,186 Reputation points Microsoft Employee2024-09-20T11:26:02.3266667+00:00 @Manish Kumar Greetings!
Recommended approach is to download your agreement PriceSheet instead of retail price API. https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/ea-pricing And then do the mapping as that will be more accurate.
Hope this helps!
-
Manish Kumar 0 Reputation points
2024-09-26T15:51:06.0033333+00:00 Thank you shadiqhAhmed for the input, I did download the EA price, but there is not way I can join with reservationOrder and reservationTransaction since I am not getting anything from these two endpoint which can help me map the unit price.
Do you think we should leverage some other endpoint to find the exact match?
-
SadiqhAhmed-MSFT 45,186 Reputation points Microsoft Employee
2024-09-27T16:52:33.5966667+00:00 @Manish Kumar You need to join multipel keys like MeterId, MeterCatregory, MeterSubCategory etc.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 0%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
youzeliang 735 Reputation points2024-09-27T16:59:15.26+00:00 To achieve the goal of mapping Azure Reservations to retail prices while considering potential issues like duplicate mappings (due to multiple armSKUName and armRegion options), you’ll need to ensure a more precise matching between the Reservation Orders, Transactions, and Retail Prices. The challenge, as you pointed out, is that the identifiers like MeterId, SKUId, and ProductId in the Retail Price API are unique, but these aren’t directly available in the Reservation Orders or Transactions APIs. Below are some strategies and steps you can follow to minimize ambiguity and more accurately match your reservations to retail prices:
- Look for Additional Identifiers in Reservation APIs
While armSKUName and armRegion are the most apparent fields in Reservation APIs to match with the Retail Price API, there might be hidden or less obvious fields that can provide better matching.
• Reservation API (ReservationOrders and Transactions): • In the Reservation Orders API response (GET /providers/Microsoft.Capacity/reservationOrders), you can often find additional fields like properties.sku or properties.appliedScopeType. These fields could be used to refine the matching process. • Check the properties.billingPlan field, as the billing plan might affect price comparisons. • Look for the properties.reservedResourceType in the response as it can help match with the corresponding retail resource type (e.g., Virtual Machines, SQL Database).You may want to log all available fields in the API responses to see if there are less obvious identifiers that could help make a more accurate mapping.
- Use the ReservationDetails API for Specific Mapping
You can retrieve more granular reservation details using the ReservationDetails API. It provides more detailed data regarding individual reservations, which might include SKU and Meter IDs:
This API can provide specific details about each reservation that could potentially have better matching fields (like MeterId) to map with the retail price data.
- Match Based on Billing Transactions and Consumption
One alternative strategy is to use billing or consumption APIs in Azure to map reservations to retail prices. These APIs may provide additional details, such as MeterId or SKUId, that match with the retail pricing API.
• Consumption Usage Details:Use the Azure Consumption API to gather granular billing and usage details that can include both **reservation discounts
If my answer is helpful to you, you can adopt it, thank you！
Sign in to comment
Sign in to answer