Question

How to compare resource usage between the data in the Microsoft Azure Cloud and the data stored in Odin Automation, as shown to end customers in CCP v2.

Answer

Export report from Microsoft

As a service provider, you can compare per-tenant resource usage by fetching the data from Microsoft Partner Center. Use the following steps:

  • Sign in to Microsoft Partner Center under your CSP credentials

  • Go to Dashboard > Billing

  • Download the reconciliation report for the required time frame

This report consists of two parts: 'Summary' and 'Daily Usage'

Total cost of Azure CSP resources can be found in the Summary part only, so export this part into a single file and separate it to columns, using comma as a column separator.

Small Excel hint:

Note that some resources can contain comma in its names, so such commas should not be column separators. To avoid problems with such commas you can use MS Excel functionality:

Select the whole first column, then Data > Text to columns > Delimited > select only Comma checkbox and specify "as Text qualifier"

With such option Excel does not treat commas inside of double quotes as a column separator.

Extracting subscription usage

When you have separated Summary part of the csv file to columns you should filter it for required subscription. Select any cell of the first row and then press Data > Filter.

Every column will get its filter. Use the filter of 'Subscription name' column to filter rows for the required subscription only.

When it is done, you will get the final report for the required subscription.

Calculating Microsoft costs

Column 'PostTaxTotal' is the final cost of the resource for the whole Microsoft billing period. MS Billing period is specified for every resource in columns 'ChargeStartDate' and 'ChargeEndDate' and can vary for different resources. However, in most cases, it is the same for all subscription resources. So, if billing period is the same, you can sum 'PostTaxTotal' to find out the total cost of Azure CSP resources for the subscription that Microsoft billed its CSP partner for the mentioned MS billing period.

Calculating Odin costs

To compare this value with one we see in CCPv2 reports:

Go to CCPv2 > Azure > View usage report > 'Summary usage for custom period' > select billing period same as the Microsoft one

You will get 'Total Consumed Amount' in the end of the report page.

This is the value that OA Azure reseller or provider has billed its end customer. It is not equal to the value that Microsoft billed its CSP Partner. To compare MS and CCPv2 values you should multiply the value obtained from csv file by 'reseller markup' that Provider specified for its reseller in OA and by 'retail markup' that reseller specified for the end customer (see Azure CSP Integration Guide to find details about 'reseller markup' and 'retail markup').

When you multiply the MS value to the required OA markups you should get the value almost equal to the one obtained from CCP v2 report (the difference will be in few hours).

Internal content