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;