Query: compute_disk_age_table

select
  d.name as "Name",
  d.unique_id as "Unique ID",
  now()::date - d.time_created::date as "Age in Days",
  d.time_created as "Time Created",
  d.disk_state as "Disk State",
  sub.title as "Subscription",
  d.subscription_id as "Subscription ID",
  d.resource_group as "Resource Group",
  d.region as "Region",
  lower(d.id) as "ID"
from
  azure_compute_disk as d,
  azure_subscription as sub
where
  d.subscription_id = sub.subscription_id
order by
  d.time_created,
  d.name;