Why is the Azure VM Cost report only showing OnDemand cost?

Products

• CloudHealth

Issue/Introduction

It is expected to see only OnDemand cost under the Azure VM Cost/Usage report when you select Y-Axis=Total Cost or Compute Cost & Category = Reservation Types.

This is due to how Azure reports VM usage.  The VM usage line items will have the cost for only OnDemand usage and the usage covered under Reservation will not have any costs.
Also, Reservation Order charges are billed separately from the VM usage line items as well.

Resolution

If you change the Y-AXIS to "Compute Cost Before RI" or "VM Hours" you will be able to view the total usage covered under the Reservations.

This can be verified by using the FlexReport (for EA customers only):

VM Usage covered under Reservation will not have Cost:

{
"sqlStatement": "SELECT timeInterval_Month AS Month, SUM(azure_Cost) AS \"SUM(azure_Cost)\", SUM(azure_ConsumedQuantity) AS \"SUM(azure_ConsumedQuantity)\", azure_MeterCategory AS Azure_MeterCategory, azure_MeterSubCategory AS Azure_MeterSubCategory, \"azure_AdditionalInfo_#_ReservationOrderId\" AS \"Azure_AdditionalInfo_#_ReservationOrderId\", \"azure_AdditionalInfo_#_ServiceType\" AS \"Azure_AdditionalInfo_#_ServiceType\" FROM AZURE_EA WHERE (azure_MeterCategory IN ('Virtual Machines')) AND (azure_MeterSubCategory LIKE '%Reservation-Base VM%') GROUP BY timeInterval_Month, azure_MeterCategory, azure_MeterSubCategory, \"azure_AdditionalInfo_#_ReservationOrderId\", \"azure_AdditionalInfo_#_ServiceType\" ORDER BY \"SUM(azure_ConsumedQuantity)\" DESC",
"needBackLinkingForTags": true,
"dataGranularity": "MONTHLY",
"timeRange": {
"last": 0
},
"limit": -1
}

OnDemand usage will not have ReservationOrder details under AdditionalInfo column

{
"sqlStatement": "SELECT timeInterval_Month AS Month, SUM(azure_Cost) AS \"SUM(azure_Cost)\", SUM(azure_ConsumedQuantity) AS \"SUM(azure_ConsumedQuantity)\", azure_MeterCategory AS Azure_MeterCategory, azure_MeterSubCategory AS Azure_MeterSubCategory, \"azure_AdditionalInfo_#_ReservationOrderId\" AS \"Azure_AdditionalInfo_#_ReservationOrderId\", \"azure_AdditionalInfo_#_ServiceType\" AS \"Azure_AdditionalInfo_#_ServiceType\" FROM AZURE_EA WHERE (azure_MeterCategory IN ('Virtual Machines')) AND (azure_MeterSubCategory NOT LIKE '%Reservation-Base VM%') GROUP BY timeInterval_Month, azure_MeterCategory, azure_MeterSubCategory, \"azure_AdditionalInfo_#_ReservationOrderId\", \"azure_AdditionalInfo_#_ServiceType\" ORDER BY \"SUM(azure_ConsumedQuantity)\" DESC",
"needBackLinkingForTags": true,
"dataGranularity": "MONTHLY",
"timeRange": {
"last": 0
},
"limit": -1
}