Azure Plan Reservations Reports
- Panagiotis Papanastasiou
A report for your Azure Plan Reservation(s) can be constructed either including in your report the asset records that are created for each Azure Plan 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 Plan Reservations, you must use the "Display More Fields" option. In the pop-up window, you must select the "Azure Plan Reserved Instances" product type for the system to load all the Azure Plan Reservations related fields.
Also, after the selection of the "Azure Plan Reserved Instances" product type for the system to load all the Azure Plan 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 Plan Reservation assets, you must define a condition that the product type is the "Azure Plan Reserved Instances" product type. Using this condition the report will include only Azure Plan Reservation assets.
For including in your report only the Azure Plan Reservation assets that have either the "Monthly" or the "One-Time" Billing Frequency, you must define a condition that the product type is the "Azure Plan Reserved Instances" product type and the "Billing Frequency" is one of the two mentioned previously. Using this condition the report will include only Azure Plan Reservation assets with whichever Billing Frequency you have chosen to be displayed.
Invoices Reports
For creating a report that will include only the Azure Plan 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 Plan Reservations in our system are billed using the generic Azure Plan 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 Plan 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 Plan 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 Plan Reservation invoice items have a value only for the "name" property, but the Azure Plan Reservation items have value only for the "InvDisplayName" property. Using this combination your Azure Plan Reservation invoices, will include the Microsoft SKU title as the invoice item description.