turbot/azure_insights

Query: key_vault_vaults_for_cosmosdb_account

Usage

powerpipe query azure_insights.query.key_vault_vaults_for_cosmosdb_account

SQL

select
lower(split_part(k.id, '/keys/', 1)) as key_vault_id
from
azure_cosmosdb_account a,
azure_key_vault_key k
where
a.key_vault_key_uri = k.key_uri
and lower(a.id) = $1
and a.subscription_id = split_part($1, '/', 3);