turbot/azure_insights

Query: storage_storage_accounts_for_key_vault_key

Usage

powerpipe query azure_insights.query.storage_storage_accounts_for_key_vault_key

SQL

select
lower(s.id) as account_id
from
azure_storage_account as s
left join azure_key_vault_key_version as v on lower(
s.encryption_key_vault_properties_key_current_version_id
) = lower(v.key_uri_with_version)
where
lower(split_part(v.id, '/versions', 1)) = $1;