Azure and GCP Perimeter Security, CIS Updates, and Enhanced Plugins →

Plugins Docs Home

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

0Benchmarks

cost_and_usage_actual_cost_by_resource_group_dashboard_monthly_cost cost_and_usage_actual_cost_by_resource_group_dashboard_resource_group_costs cost_and_usage_actual_cost_by_resource_group_dashboard_subscriptions_input cost_and_usage_actual_cost_by_resource_group_dashboard_top_10_resource_groups cost_and_usage_actual_cost_by_resource_group_dashboard_total_cost cost_and_usage_actual_cost_by_resource_group_dashboard_total_resource_groups cost_and_usage_actual_cost_by_resource_group_dashboard_total_subscriptions cost_and_usage_actual_cost_by_service_dashboard_monthly_cost cost_and_usage_actual_cost_by_service_dashboard_service_costs cost_and_usage_actual_cost_by_service_dashboard_subscriptions_input cost_and_usage_actual_cost_by_service_dashboard_top_10_services cost_and_usage_actual_cost_by_service_dashboard_total_cost cost_and_usage_actual_cost_by_service_dashboard_total_services cost_and_usage_actual_cost_by_service_dashboard_total_subscriptions cost_and_usage_actual_cost_by_subscription_dashboard_cost_and_usage_actual_cost_by_subscription_details cost_and_usage_actual_cost_by_subscription_dashboard_monthly_cost_and_usage_actual_cost_by_subscription cost_and_usage_actual_cost_by_subscription_dashboard_subscriptions_input cost_and_usage_actual_cost_by_subscription_dashboard_total_cost cost_and_usage_actual_cost_by_subscription_dashboard_total_subscriptions cost_and_usage_actual_cost_by_tag_dashboard_monthly_cost cost_and_usage_actual_cost_by_tag_dashboard_subscriptions_input cost_and_usage_actual_cost_by_tag_dashboard_tag_key_input cost_and_usage_actual_cost_by_tag_dashboard_tag_value_costs cost_and_usage_actual_cost_by_tag_dashboard_top_10_tag_values cost_and_usage_actual_cost_by_tag_dashboard_total_cost cost_and_usage_actual_cost_by_tag_dashboard_total_subscriptions cost_and_usage_actual_overview_dashboard_daily_cost cost_and_usage_actual_overview_dashboard_monthly_cost cost_and_usage_actual_overview_dashboard_subscriptions_input cost_and_usage_actual_overview_dashboard_top_10_resource_groups cost_and_usage_actual_overview_dashboard_top_10_resources cost_and_usage_actual_overview_dashboard_top_10_services cost_and_usage_actual_overview_dashboard_top_10_subscriptions cost_and_usage_actual_overview_dashboard_total_cost cost_and_usage_actual_overview_dashboard_total_subscriptions

Query: cost_and_usage_actual_cost_by_service_dashboard_monthly_cost

Usage

powerpipe query azure_cost_and_usage_insights.query.cost_and_usage_actual_cost_by_service_dashboard_monthly_cost

Tags

folder = Hidden

SQL

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;

Params

Args	Name	Default	Description	Variable
$1	subscription_ids

Dashboards

The query is used in the dashboards:

Azure Cost and Usage Actual: Cost by Service