Query: app_service_web_app_overview

select
  name as "Name",
  default_site_hostname as "Default Site Hostname",
  cloud_environment as "Cloud Environment",
  case
    when enabled :: boolean then 'Online'
    else 'Offline'
  end as "Status",
  type as "Type",
  region as "Region",
  resource_group as "Resource Group",
  subscription_id as "Subscription ID",
  id as "ID"
from
  azure_app_service_web_app
where
  lower(id) = $1;