Azure Reservations Reports
- Panagiotis Papanastasiou
- Apostolos Karakaxas
A report for your Azure Reservations can be constructed either including in your report the asset records that are created for each Azure Reservation or the invoice items that were used for billing them.
Assets Reports
For including in your asset report the specific fields we are having in the Azure Reservations, you must use the "Display More Fields" option. In the pop-up window, you must select the "Microsoft Azure Reserved Instances" product type for the system to load all the Azure Reservations related fields.
Also, after the selection of the "Microsoft Azure Reserved Instances" product type for the system to load all the Azure Reservations related fields, you can enable the Billing Frequency in order to include it in your Azure Reservations asset report, as exemplified in the following image.
For including in your report only the Azure Reservation assets, you must define a condition that the product type is the reserved instances product type. Using this condition the report will include only Azure Reservation assets.
For including in your report only the Azure Reservation assets that have either the "Monthly" or the "One-Time" Billing Frequency, you must define a condition that the product type is the Reserved Instances product type and the "Billing Frequency" is one of the two mentioned above. Using this condition the report will include only Azure Reservation assets with whichever Billing Frequency you have chosen to be displayed.
Invoices Reports
For creating a report that will include only the Azure Reservation charges you must do the following:
- In the "Reports Column" step you should select the "Display Name" field of the invoice item object. Since all Azure Reservations in our system are billed using the generic Azure Reservation product, you should use this field for including in your report the Microsoft SKU title for each purchase.
- In the "Reports Criteria" step define a condition for loading only the Azure Reservation invoice items. Such condition is that the product type is the reserved instances product type.
Invoice Print-out
For displaying correctly in your invoice print-out the Azure Reservation SKU title, you should use the "Display name" field instead of the "Description" field.
You need to add the merge field {#InvoiceLines.InvDisplayName#} as one of the available values for the "Description" column.
In the above screenshot we have set as the value of the "Description" column the merge fields:
{#InvoiceLines.Name#} {#InvoiceLines.InvDisplayName#}
This combination works because all non Azure Reservation invoice item have a value only for the "name" property, but the Azure Reservation items have value only for the "InvDisplayName" property. Using this combination your Azure Reservation invoices will include the Microsoft SKU title as the invoice item description.