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

Query: cost_and_usage_actual_overview_dashboard_subscriptions_input

Usage

powerpipe query azure_cost_and_usage_insights.query.cost_and_usage_actual_overview_dashboard_subscriptions_input

SQL

select 'all' as value, 'All' as label
union all
select
subscription_id as value,
subscription_name as label
from
azure_cost_and_usage_actual
where
subscription_id is not null and subscription_id != ''
and subscription_name is not null and subscription_name != ''
group by
subscription_id,
subscription_name
order by
label;