turbot/azure_insights

Query: compute_disk_encryption_sets_for_key_vault_key

Usage

powerpipe query azure_insights.query.compute_disk_encryption_sets_for_key_vault_key

SQL

select
lower(s.id) as disk_encryption_set_id
from
azure_key_vault_key_version as v
left join azure_compute_disk_encryption_set as s on s.active_key_url = v.key_uri_with_version
where
s.id is not null
and lower(split_part(v.id, '/versions', 1)) = $1;