Dashboard: Azure Cost and Usage Actual: Cost by Subscription

This dashboard answers the following questions:

What is the total cost across selected subscriptions?
How many subscriptions are being analyzed?
How is cost distributed across different subscriptions?
How have subscription costs trended over time?

This dashboard contains 2 cards, 1 input and 1 table.

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: Cost by Subscription 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_cost_by_subscription_dashboard --share

Queries

This dashboard uses the the following queries:

select
  subscription_name as "Subscription",
  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
  subscription_name
order by
  sum(cost_in_billing_currency) desc;

{
  "$1": "subscription_ids"
}

Dashboard: Azure Cost and Usage Actual: Cost by Subscription

Usage

Queries

Tags