Query: compute_disk_inventory_table

select
  d.name as "Name",
  d.disk_state as "State",
  d.disk_size_gb as "Size (GB)",
  d.sku_name as "SKU",
  d.managed_by as "Managed By",
  d.encryption_settings_collection_enabled as "Encryption Enabled",
  d.os_type as "OS Type",
  d.network_access_policy as "Network Access",
  d.public_network_access as "Public Access",
  d.tags as "Tags",
  lower(d.id) as "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;