Query: network_security_group_inventory_table

select
  n.name as "Name",
  n.provisioning_state as "Provisioning State",
  jsonb_array_length(n.security_rules) as "Security Rules",
  jsonb_array_length(n.default_security_rules) as "Default Security Rules",
  jsonb_array_length(n.network_interfaces) as "Network Interfaces",
  jsonb_array_length(n.subnets) as "Subnets",
  jsonb_array_length(n.flow_logs) as "Flow Logs",
  n.tags as "Tags",
  lower(n.id) as "ID",
  sub.title as "Subscription",
  n.subscription_id as "Subscription ID",
  n.resource_group as "Resource Group",
  n.region as "Region"
from
  azure_network_security_group as n,
  azure_subscription as sub
where
  sub.subscription_id = n.subscription_id
order by
  n.name;