Data Collection Guides

Both the Kostner Klarity and Kostner Save Services are based on the detailed usage data reports that are available in both Azure and AWS.

Downloading Azure Usage Reports

The steps needed to download usage data from Azure depends on the type of subscription you have:

See Microsoft’s guide to Downloading Azure billing data here


Regular Azure Customer

This is how most small and medium sized companies buy Azure Services

  1. Sign in to the Azure portal (portal.azure.com)
  2. Select your subscription from the Subscription page in the Azure portal as a user with access to invoices.
  3. Select Invoices.
  4. Click the download button of an invoice period you want to check – preferably the last three full months.
  5. Download the daily breakdown of consumed quantities and estimated charges by clicking Download in the Usage Detail window.
  6. Save one file per month.
  7. Repeat step 2-6 for all relevant subscriptions.

Enterprise Agreement (EA) Customer

This is how most large sized companies buy Azure Services

To view and download usage data as an EA customer, you must be an Enterprise Administrator, Account Owner, or Department Admin with the view charges policy enabled.

  1. Sign in to the Azure portal (portal.azure.com).
  2. Search for Cost Management + Billing.
  3. Select Usage + charges.
  4. Click Download.
  5. In Download Usage + Charges, under Usage Details Version 2, select Amortized charges (usage and purchases).
  6. Save one file per month


Microsoft Customer Agreement Customer

This is Microsoft’s most recent customer framework.

  1. Sign in to the Azure portal (portal.azure.com).
  2. Search for Cost Management + Billing.
  3. Select a billing profile.
  4. Select Invoices.
  5. In the invoice grid, find the row of the invoice corresponding to the usage you want to download.
  6. Click on the ellipsis (…) at the end of the row.
  7. In the download context menu, select Azure usage and charges.
  8. Repeat step 3-7 for all relevant biling profiles

Downloading AWS Usage Reports

In AWS Cost and Usage Reports have to be created first, before they can be downloaded. You have likely already done this, if not please follow this guide.

See AWS’ guide to Cost and Usage Reports here

Please pay close attention to following step 5!

  1. Sign in to the Billing and Cost Management console at https://console.aws.amazon.com/billing/home#/.
  2. On the navigation pane, choose Cost & Usage Reports.
  3. Choose Create report.
  4. For Report name, enter a name for your report.
  5. For Additional report details, select Include resource IDs to include the IDs of each individual resource in the report.
  6. For Data refresh settings, select whether you want the AWS Cost and Usage Reports to refresh if AWS applies refunds, credits, or support frees to your account after finalizing you bill. When a report refreshes, a new report is uploaded to Amazon S3.
  7. Choose Next.
  8. For S3 bucket, choose Configure.
  9. In the Configure S3 Bucket dialog box, do one of the following:
    1. Select an existing bucket from the drop down list and choose Next.
    1. Enter a bucket name and the Region where you want to create a new bucket and choose Next.
  10. Select I have confirmed that this policy is correct and choose Save.
  11. For Report path prefix, enter the report path prefix that you want prepended to the name of your report.
  12. For Time granularity, choose Hourly.
  13. For Report versioning, choose whether you want each version of the report to overwrite the previous version of the report or to be delivered in additional to the previous versions.
  14. For Enable report data integration for, select whether you want to upload your Cost and Usage Reports to Amazon Athena, Amazon Redshift, or Amazon QuickSight. The report is compressed in the following formats:
    1. Athena: parquet compression.
    1. Amazon Redshift or Amazon QuickSight: .gz compression.
  15. Choose Next.
  16. After you have reviewed the settings for your report, choose Review and Complete.