Control: Network Load Balancer with Missing Backend

powerpipe control run azure_thrifty.control.network_load_balancer_with_missing_backend

powerpipe login
powerpipe control run azure_thrifty.control.network_load_balancer_with_missing_backend --share

select
  r.id as resource,
  case
    when r.backend_address_pool_id is null then 'alarm'
    else 'ok'
  end as status,
  case
    when r.backend_address_pool_id is null then r.name || ' in load balancer ' || r.load_balancer_name || ' has no backend pool configured.'
    else r.name || ' has backend pool configured.'
  end as reason
  
  , r.resource_group
  , display_name as subscription
from
  azure_lb_rule as r,
  azure_subscription as sub
where
  sub.subscription_id = r.subscription_id;