Query: app_service_web_app_configuration

select
  configuration -> 'properties' ->> 'loadBalancing' as "Load Balancing",
  configuration -> 'properties' ->> 'linuxFxVersion' as "Linux App Framework and version",
  configuration -> 'properties' ->> 'numberOfWorkers' as "Workers",
  configuration -> 'properties' ->> 'preWarmedInstanceCount' as "Pre-warmed Instances",
  case when (configuration -> 'properties' ->> 'alwaysOn')::boolean then 'Enabled' else 'Disabled' end as "Always On",
  case when (configuration -> 'properties' ->> 'autoHealEnabled')::boolean then 'Enabled' else 'Disabled' end as "Auto Heal",
  case when (configuration -> 'properties' ->> 'detailedErrorLoggingEnabled')::boolean then 'Enabled' else 'Disabled' end as "Detailed Error Logging",
  case when (configuration -> 'properties' ->> 'http20Enabled')::boolean then 'Enabled' else 'Disabled' end as "HTTP 20",
  case when (configuration -> 'properties' ->> 'httpLoggingEnabled')::boolean then 'Enabled' else 'Disabled' end as "HTTP Logging",
  case when (configuration -> 'properties' ->> 'localMySqlEnabled')::boolean then 'Enabled' else 'Disabled' end as "Local MySQL",
  configuration -> 'properties' ->> 'logsDirectorySizeLimit' as "HTTP Logs Directory Size Limit",
  configuration -> 'properties' ->> 'managedPipelineMode' as "Managed Pipeline Mode",
  case when (configuration -> 'properties' ->> 'remoteDebuggingEnabled')::boolean then 'Enabled' else 'Disabled' end as "Remote Debugging",
  case when (configuration -> 'properties' ->> 'requestTracingEnabled')::boolean then 'Enabled' else 'Disabled' end as "Request Tracing"
from
  azure_app_service_web_app
where
  lower(id) = $1;