Query: compute_disk_encryption_report

select
  d.name as "Name",
  d.unique_id as "Unique ID",
  lower(d.id) as "ID",
  d.encryption_type as "Encryption Type",
  d.encryption_disk_encryption_set_id as "Disk Encryption Set ID",
  sub.title as "Subscription",
  d.subscription_id as "Subscription ID",
  d.resource_group as "Resource Group",
  d.region as "Region"
from
  azure_compute_disk as d,
  azure_subscription as sub
where
  sub.subscription_id = d.subscription_id
order by
  d.name;