Query: guardrails_control_alert_oldest

select
  id,
  workspace,
  control_type_trunk_title as "Control Title",
  resource_trunk_title as "Resource Trunk Title",
  now()::date - update_timestamp::date as "Age in Days",
  _ctx ->> 'connection_name' as "Connection Name"
from
  guardrails_control
where
  state = 'alarm'
order by
  "Age in Days" desc;