Cost analysis export

Cost analysis export

Introduction

As an organization that is customer of anDREa, you would like to have access to the costs that are generated by the resources (VMs, OSDisks etc.) in your subscription. The Cost analysis tab is available in the Azure Portal for tenant-mandated employees. It is fairly simple to export subscription-wide costs to a .csv or Excel file. However, you would still need to manually split these costs in resources. Microsoft Azure now offers an overview per resource group and even per resource. Below you can find an explanation on where to find this overview.

Cost analysis

Alert
Be aware that the costs per resource overview is an Azure preview function. These may disappear or be changed.
  1. Log in to the Azure Portal. You're most likely in the role of support member, so you will need to log in with your organizational account, not your @mydre.org account!
  2. In the Azure Portal, navigate to Subscriptions.
  3. Select your tenant-owned subscription.
  4. In the left menu, navigate to Cost Analysis.

  1. At the top, select Cost by resource followed by Resources (preview).

  1. At the top you can select the months and the view (Resources, Resource groups, Subscriptions etc.). The most handy overview for billing would be resources or resource groups. The resources overview also includes tags such as cost center.

  1. At the top select download to download an export in .csv or Excel for internal billing within the own organization.
Info
The export can also be automated to a workspace storage account, for instance monthly costs can be exported to the storage account of choice. Your institution must have shared subscription in place in order for this to work.

Notes
When cost and usage data becomes available in Cost Management, it gets retained for at least seven years. Only the last 13 months are available from the Azure portal under Cost Management portal under Exports. It's also available in the Cost Details API. To retrieve historical data that is older than 13 months, use the Exports REST API.

This is a suggestion for your internal planning: consider running a script every six months to update Cost Management, especially if you're looking for data beyond the past 13 months.

    • Related Articles

    • CIA (BIV) Classification

      First version: 2022-03-29 Last updated: 2023-11-06 Last change(s): Added the 'wrong Accountable' threat and mitigation under Threats and Vulnerability Analysis. Summary CIA stands for Confidentiality (Vertrouwelijkheid), Integrity of data ...
    • 20220713 Report Azure White Box Security Audit

      Version: 2022-07-14 Introduction anDREa has a Pentest Program program as part of the commitment to protect the security of its business information. At least once a year we request an external party to do the pentest and a white box security audit. ...
    • Security Manifesto

      First version: 2021-04-15 Last updated: 2024-01-24 Last change: Replacing 'Azure DRE' with 'myDRE' ; replaced 'Owner' with 'Accountable or Privileged Member' Introduction anDREa is committed to protecting the security of its business information in ...
    • Clause 4 Context of the organisation

      Version: 3.0 Valid until: 2025-04-12 Classification: Low Version Management Version Author(s) Change(s) Date approved 1.0 Stefan van Aalst Edward Robinson Initiation document 2022-05-23 1.1 Edward Robinson Additions/changes as part of the periodic ...
    • Clause 6 Planning

      Version: 3.0 Valid until: 2025-04-16 Classification: Low Version Management Version Author(s) Change(s) Date approved 1.0 Stefan van Aalst Edward Robinson Initiation document 2022-05-20 1.1 Edward Robinson Additions/changes as part of the periodic ...