Query: app_service_web_app_diagnostic_logs_configuration

select
  diagnostic_logs_configuration -> 'properties' -> 'applicationLogs' -> 'azureBlobStorage' ->> 'level' as "Application logging (Blob)",
  diagnostic_logs_configuration -> 'properties' -> 'applicationLogs' -> 'azureTableStorage' ->> 'level' as "Application logging (Table)",
  diagnostic_logs_configuration -> 'properties' -> 'applicationLogs' -> 'fileSystem' ->> 'level' as "Application logging (Filesystem)",
  case
    when (
      diagnostic_logs_configuration -> 'properties' -> 'detailedErrorMessages' -> 'enabled'
    ) :: boolean then 'Enabled'
    else 'Disabled'
  end as "Detailed Error Messages",
  case
    when (
      diagnostic_logs_configuration -> 'properties' -> 'failedRequestsTracing' -> 'enabled'
    ) :: boolean then 'Enabled'
    else 'Disabled'
  end as "Failed Requests Tracing",
  case
    when (
      diagnostic_logs_configuration -> 'properties' -> 'httpLogs' -> 'azureBlobStorage' -> 'enabled'
    ) :: boolean then 'Enabled'
    else 'Disabled'
  end as "Web server logging (Storage)",
  case
    when (
      diagnostic_logs_configuration -> 'properties' -> 'httpLogs' -> 'fileSystem' -> 'enabled'
    ) :: boolean then 'Enabled'
    else 'Disabled'
  end as "Web server logging (Filesystem)"
from
  azure_app_service_web_app
where
  lower(id) = $1;