Query: compute_disk_status

select
  'Status' as label,
  disk_state as value,
  case when disk_state = 'Attached' then 'ok' else 'alert' end as type
from
  azure_compute_disk
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);