Skip to main content

vw_configuration_snapshot_slots

Creates, updates, deletes, gets or lists a vw_configuration_snapshot_slots resource.

Overview​

Namevw_configuration_snapshot_slots
TypeView
Idazure.app_service.vw_configuration_snapshot_slots

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
id as id,
name as name,
kind as kind,
type as type,
JSON_EXTRACT(properties, '$.numberOfWorkers') as "number_of_workers",
JSON_EXTRACT(properties, '$.defaultDocuments') as "default_documents",
JSON_EXTRACT(properties, '$.netFrameworkVersion') as "net_framework_version",
JSON_EXTRACT(properties, '$.phpVersion') as "php_version",
JSON_EXTRACT(properties, '$.pythonVersion') as "python_version",
JSON_EXTRACT(properties, '$.nodeVersion') as "node_version",
JSON_EXTRACT(properties, '$.powerShellVersion') as "power_shell_version",
JSON_EXTRACT(properties, '$.linuxFxVersion') as "linux_fx_version",
JSON_EXTRACT(properties, '$.windowsFxVersion') as "windows_fx_version",
JSON_EXTRACT(properties, '$.requestTracingEnabled') as "request_tracing_enabled",
JSON_EXTRACT(properties, '$.requestTracingExpirationTime') as "request_tracing_expiration_time",
JSON_EXTRACT(properties, '$.remoteDebuggingEnabled') as "remote_debugging_enabled",
JSON_EXTRACT(properties, '$.remoteDebuggingVersion') as "remote_debugging_version",
JSON_EXTRACT(properties, '$.httpLoggingEnabled') as "http_logging_enabled",
JSON_EXTRACT(properties, '$.acrUseManagedIdentityCreds') as "acr_use_managed_identity_creds",
JSON_EXTRACT(properties, '$.acrUserManagedIdentityID') as "acr_user_managed_identity_id",
JSON_EXTRACT(properties, '$.logsDirectorySizeLimit') as "logs_directory_size_limit",
JSON_EXTRACT(properties, '$.detailedErrorLoggingEnabled') as "detailed_error_logging_enabled",
JSON_EXTRACT(properties, '$.publishingUsername') as "publishing_username",
JSON_EXTRACT(properties, '$.appSettings') as "app_settings",
JSON_EXTRACT(properties, '$.metadata') as "metadata",
JSON_EXTRACT(properties, '$.connectionStrings') as "connection_strings",
JSON_EXTRACT(properties, '$.machineKey') as "machine_key",
JSON_EXTRACT(properties, '$.handlerMappings') as "handler_mappings",
JSON_EXTRACT(properties, '$.documentRoot') as "document_root",
JSON_EXTRACT(properties, '$.scmType') as "scm_type",
JSON_EXTRACT(properties, '$.use32BitWorkerProcess') as "use32_bit_worker_process",
JSON_EXTRACT(properties, '$.webSocketsEnabled') as "web_sockets_enabled",
JSON_EXTRACT(properties, '$.alwaysOn') as "always_on",
JSON_EXTRACT(properties, '$.javaVersion') as "java_version",
JSON_EXTRACT(properties, '$.javaContainer') as "java_container",
JSON_EXTRACT(properties, '$.javaContainerVersion') as "java_container_version",
JSON_EXTRACT(properties, '$.appCommandLine') as "app_command_line",
JSON_EXTRACT(properties, '$.managedPipelineMode') as "managed_pipeline_mode",
JSON_EXTRACT(properties, '$.virtualApplications') as "virtual_applications",
JSON_EXTRACT(properties, '$.loadBalancing') as "load_balancing",
JSON_EXTRACT(properties, '$.experiments') as "experiments",
JSON_EXTRACT(properties, '$.limits') as "limits",
JSON_EXTRACT(properties, '$.autoHealEnabled') as "auto_heal_enabled",
JSON_EXTRACT(properties, '$.autoHealRules') as "auto_heal_rules",
JSON_EXTRACT(properties, '$.tracingOptions') as "tracing_options",
JSON_EXTRACT(properties, '$.vnetName') as "vnet_name",
JSON_EXTRACT(properties, '$.vnetRouteAllEnabled') as "vnet_route_all_enabled",
JSON_EXTRACT(properties, '$.vnetPrivatePortsCount') as "vnet_private_ports_count",
JSON_EXTRACT(properties, '$.cors') as "cors",
JSON_EXTRACT(properties, '$.push') as "push",
JSON_EXTRACT(properties, '$.apiDefinition') as "api_definition",
JSON_EXTRACT(properties, '$.apiManagementConfig') as "api_management_config",
JSON_EXTRACT(properties, '$.autoSwapSlotName') as "auto_swap_slot_name",
JSON_EXTRACT(properties, '$.localMySqlEnabled') as "local_my_sql_enabled",
JSON_EXTRACT(properties, '$.managedServiceIdentityId') as "managed_service_identity_id",
JSON_EXTRACT(properties, '$.xManagedServiceIdentityId') as "x_managed_service_identity_id",
JSON_EXTRACT(properties, '$.keyVaultReferenceIdentity') as "key_vault_reference_identity",
JSON_EXTRACT(properties, '$.ipSecurityRestrictions') as "ip_security_restrictions",
JSON_EXTRACT(properties, '$.ipSecurityRestrictionsDefaultAction') as "ip_security_restrictions_default_action",
JSON_EXTRACT(properties, '$.scmIpSecurityRestrictions') as "scm_ip_security_restrictions",
JSON_EXTRACT(properties, '$.scmIpSecurityRestrictionsDefaultAction') as "scm_ip_security_restrictions_default_action",
JSON_EXTRACT(properties, '$.scmIpSecurityRestrictionsUseMain') as "scm_ip_security_restrictions_use_main",
JSON_EXTRACT(properties, '$.http20Enabled') as "http20_enabled",
JSON_EXTRACT(properties, '$.minTlsVersion') as "min_tls_version",
JSON_EXTRACT(properties, '$.minTlsCipherSuite') as "min_tls_cipher_suite",
JSON_EXTRACT(properties, '$.scmMinTlsVersion') as "scm_min_tls_version",
JSON_EXTRACT(properties, '$.ftpsState') as "ftps_state",
JSON_EXTRACT(properties, '$.preWarmedInstanceCount') as "pre_warmed_instance_count",
JSON_EXTRACT(properties, '$.functionAppScaleLimit') as "function_app_scale_limit",
JSON_EXTRACT(properties, '$.elasticWebAppScaleLimit') as "elastic_web_app_scale_limit",
JSON_EXTRACT(properties, '$.healthCheckPath') as "health_check_path",
JSON_EXTRACT(properties, '$.functionsRuntimeScaleMonitoringEnabled') as "functions_runtime_scale_monitoring_enabled",
JSON_EXTRACT(properties, '$.websiteTimeZone') as "website_time_zone",
JSON_EXTRACT(properties, '$.minimumElasticInstanceCount') as "minimum_elastic_instance_count",
JSON_EXTRACT(properties, '$.azureStorageAccounts') as "azure_storage_accounts",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
subscriptionId,
resourceGroupName,
name,
slot,
snapshotId
FROM azure.app_service.configuration_snapshot_slots
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND name = 'replace-me' AND slot = 'replace-me' AND snapshotId = 'replace-me';