Query: network_express_route_circuit_global_reach

select
  'Global Reach' as label,
  case when global_reach_enabled then 'Enabled' else 'Disabled' end as value,
  case when global_reach_enabled then 'ok' else 'alert' end as type
from
  azure_express_route_circuit
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);