Azure Cost and Usage Actual: Cost by Resource GroupAzure Cost and Usage Actual: Cost by ServiceAzure Cost and Usage Actual: Cost by SubscriptionAzure Cost and Usage Actual: Cost by TagAzure Cost and Usage Actual: Overview
Dashboard: Azure Cost and Usage Actual: Cost by Resource Group
This dashboard answers the following questions:
- What is the total cost across selected subscriptions?
- How many resource groups are being analyzed?
- How is cost distributed across different resource groups?
- How have resource group costs trended over time?
This dashboard contains 3 cards, 1 input and 1 table.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe 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 Resource Group dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run azure_cost_and_usage_insights.dashboard.cost_and_usage_actual_cost_by_resource_group_dashboard --share
Queries
This dashboard uses the the following queries:
select strftime(date_trunc('month', date), '%b %Y') as "Month", resource_group_name as "Resource Group", round(sum(cost_in_billing_currency), 2) as "Total Cost"from azure_cost_and_usage_actualwhere ('all' in ($1) or subscription_id in $1)group by date_trunc('month', date), resource_group_nameorder by date_trunc('month', date), sum(cost_in_billing_currency) desc;
{ "$1": "subscription_ids"}