turbot/azure_insights

Query: key_vault_vaults_for_storage_account

Usage

powerpipe query azure_insights.query.key_vault_vaults_for_storage_account

SQL

select
lower(k.id) as vault_id
from
azure_storage_account as a,
azure_key_vault as k
where
a.encryption_key_vault_properties_key_vault_uri = trim(k.vault_uri, '/')
and lower(a.id) = $1
and a.subscription_id = split_part($1, '/', 3);