Query: sql_server_inventory_table

select
  s.name as "Name",
  s.state as "State",
  s.version as "Version",
  s.administrator_login as "Administrator Login",
  s.minimal_tls_version as "Minimal TLS Version",
  s.public_network_access as "Public Network Access",
  s.fully_qualified_domain_name as "Fully Qualified Domain Name",
  jsonb_array_length(s.firewall_rules) as "Firewall Rules",
  jsonb_array_length(s.virtual_network_rules) as "Virtual Network Rules",
  s.tags as "Tags",
  lower(s.id) as "ID",
  sub.title as "Subscription",
  s.subscription_id as "Subscription ID",
  s.resource_group as "Resource Group",
  s.region as "Region"
from
  azure_sql_server as s,
  azure_subscription as sub
where
  sub.subscription_id = s.subscription_id
order by
  s.name;