Query: network_security_group_unused_status

select
  status,
  count(*)
from
  (
    select
      case
        when (
          subnets is null
          and network_interfaces is null
        ) then 'unassociated'
        else 'associated'
      end status
    from
      azure_network_security_group
  ) as n
group by
  status
order by
  status;