Query: compute_snapshot_age_table

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