Dashboard: Azure Cost and Usage Actual: Overview

This dashboard answers the following questions:

What is the total cost across all subscriptions?
What currency is used for cost calculations?
How has the cost trended monthly and daily?
What are the top 10 most expensive subscriptions, resource groups, services, and resources?

This dashboard contains 2 cards and 1 input.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/tailpipe-mod-azure-cost-and-usage-insights

Start the Powerpipe server:

powerpipe server

Open http://localhost:9033 in your browser and select Azure Cost and Usage Actual: Overview dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run azure_cost_and_usage_insights.dashboard.cost_and_usage_actual_overview_dashboard --share

Queries

This dashboard uses the the following queries:

select
  strftime(date_trunc('day', date), '%Y-%m-%d') as "Date",
  round(sum(cost_in_billing_currency), 2) as "Total Cost"
from
  azure_cost_and_usage_actual
where
  ('all' in ($1) or subscription_id in $1)
group by
  date_trunc('day', date)
order by
  date_trunc('day', date);

{
  "$1": "subscription_ids"
}

Dashboard: Azure Cost and Usage Actual: Overview

Usage

Queries

Tags