microsoft azure source microsoft

Managing multiple subscriptions for Azure isn’t something many consider difficult until they actually have to do it. Keeping track of resource usage, activity, and pricing wasn’t an easy job when doing it the old way.

Thankfully, the Developer Experience team have come up with a good solution for everyone. Utilizing the PowerBI dashboard, the AUBI Portal can automatically retrieve usage data from the last three years.

Additionally, every day at midnight (UTC) the system will retrieve the previous day’s usage and billing. The results are records that keep up to date on a daily basis without any user input.

Azure-Billing-Portal-Screenshot-Github

The dashboard allows users to filter data using differing parameters, including services, subscriptions, sub-services and more.

Full Features

The GitHub page notes list all of the services involved:

  • “One public website called Registration where any user can provide access to the site and register their Azure subscriptions.
  • One website called Dashboard, where only authenticated users can see the list of registered subscriptions and trigger a job to re-generate up to date billing data in case of any inconsistency.
  • One AzureSQL Server to hold billing and usage data for all registered subscriptions.
  • One Azure Storage Queue to hold “generate data” requests.
  • One schedule base (every UTC night) running webjob that is triggered once a day to create “generate data” request for each registered subscription.
  • One continuous running webjob to process requests that are waiting in the Azure Storage Queue.
  • PowerBi dashboard for data visualization of all or per subscription Azure service billing and usage details like service unit, quantity, usage duration, etc.”

Before the data can be accessed, all the users with an active Azure subscription need to register their product through the provided registration website. To do this, they need their Microsoft ID and the subscription’s domain name.

A complete how-to guide for installation is available, while the resources themselves can be found on the main GitHub page.