turbot/tailpipe-mod-azure-cost-and-usage-insights

Dashboard: Azure Cost and Usage Actual: Cost by Service

This dashboard answers the following questions:

  • What is the total cost across selected subscriptions?
  • How many Azure services are being used?
  • How is cost distributed across different Azure services?
  • How have service costs trended over time?
This dashboard contains 3 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 Service 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_service_dashboard --share

Queries

This dashboard uses the the following queries:
select
strftime(date_trunc('month', date), '%b %Y') as "Month",
consumed_service as "Service",
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('month', date),
consumed_service
order by
date_trunc('month', date),
sum(cost_in_billing_currency) desc;
{
"$1": "subscription_ids"
}

Tags