turbot/azure_insights

Query: cosmosdb_account_database_count

Usage

powerpipe query azure_insights.query.cosmosdb_account_database_count

SQL

select
'Databases' as label,
count(*) as value
from
azure_cosmosdb_account a,
azure_cosmosdb_mongo_database d
where
a.name = d.account_name
and lower(a.id) = $1
and a.subscription_id = split_part($1, '/', 3);

Dashboards

The query is used in the dashboards: