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

Query: cost_and_usage_actual_cost_by_service_dashboard_total_services

Usage

powerpipe query azure_cost_and_usage_insights.query.cost_and_usage_actual_cost_by_service_dashboard_total_services

SQL

select
'Services' as label,
count(distinct consumed_service) as value
from
azure_cost_and_usage_actual
where
('all' in ($1) or subscription_id in $1);

Params

ArgsNameDefaultDescriptionVariable
$1subscription_ids

    Dashboards

    The query is used in the dashboards: