Control: Unused private endpoints should be removed

powerpipe control run azure_thrifty.control.network_private_endpoint_unused

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

select
  pe.id as resource,
  case
    when pe.private_link_service_connections is null then 'alarm'
    else 'ok'
  end as status,
  case
    when pe.private_link_service_connections is null then pe.name || ' has no service connections.'
    else pe.name || ' has service connections.'
  end as reason
  
  , pe.resource_group
  , display_name as subscription
from
  azure_private_endpoint as pe,
  azure_subscription as sub
where
  sub.subscription_id = pe.subscription_id;