turbot/azure_insights

Query: cosmosdb_account_input

Usage

powerpipe query azure_insights.query.cosmosdb_account_input

SQL

select
a.title as label,
lower(a.id) as value,
json_build_object(
'subscription', sub.display_name,
'resource_group', a.resource_group,
'region', a.region
) as tags
from
azure_cosmosdb_account as a,
azure_subscription as sub
where
lower(a.subscription_id) = lower(sub.subscription_id)
order by
a.title;