turbot/azure_insights

Query: key_vault_keys_for_cosmosdb_account

Usage

powerpipe query azure_insights.query.key_vault_keys_for_cosmosdb_account

SQL

select
lower(k.id) as key_vault_key_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);