turbot/azure_insights

Query: cosmosdb_mongo_collection_for_cosmosdb_mongo_database

Usage

powerpipe query azure_insights.query.cosmosdb_mongo_collection_for_cosmosdb_mongo_database

SQL

select
lower(c.id) as collection_id
from
azure_cosmosdb_mongo_database as d
join azure_cosmosdb_mongo_collection as c
on c.database_name = d.name
and c.account_name = (select account_name from azure_cosmosdb_mongo_database where lower(id) = $1)
where
lower(d.id) = $1
and d.subscription_id = split_part($1, '/', 3);