Query: app_service_web_app_inventory_table

select
  a.name as "Name",
  a.kind as "Kind",
  a.state as "State",
  a.enabled as "Enabled",
  a.https_only as "HTTPS Only",
  a.client_cert_enabled as "Client Cert Enabled",
  a.default_site_hostname as "Default Site Hostname",
  a.host_name_disabled as "Hostname Disabled",
  a.reserved as "Reserved",
  a.tags as "Tags",
  lower(a.id) as "ID",
  sub.title as "Subscription",
  a.subscription_id as "Subscription ID",
  a.resource_group as "Resource Group",
  a.region as "Region"
from
  azure_app_service_web_app as a,
  azure_subscription as sub
where
  sub.subscription_id = a.subscription_id
order by
  a.name;