Query: compute_disk_encryption_details

select
  e.name as "Name",
  e.encryption_type as "Encryption Type",
  v.name as "Key Vault Name",
  lower(v.id) as "Key Vault ID",
  lower(k.key_id) as "Key ID",
  k.name as "Key Name",
  e.id as "ID"
from
  azure_compute_disk_encryption_set as e
  left join azure_compute_snapshot as s on lower(s.disk_encryption_set_id) = lower(e.id)
  left join azure_key_vault as v on lower(v.id) = lower(e.active_key_source_vault_id)
  left join azure_key_vault_key_version as k on lower(k.key_uri_with_version) = lower(e.active_key_url)
where
  lower(s.id) = $1
  and s.subscription_id = split_part($1, '/', 3);