vw_diagnostics_site_detector_slots

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

Overview

Name	vw_diagnostics_site_detector_slots
Type	View
Id	azure.app_service.vw_diagnostics_site_detector_slots

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
kind as kind,
type as type,
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.rank') as "rank",
JSON_EXTRACT(properties, '$.isEnabled') as "is_enabled",
subscriptionId,
resourceGroupName,
siteName,
slot,
diagnosticCategory,
detectorName
FROM azure.app_service.diagnostics_site_detector_slots
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = 'replace-me' AND slot = 'replace-me' AND diagnosticCategory = 'replace-me';

Postgres

SELECT
id as id,
name as name,
kind as kind,
type as type,
json_extract_path_text(properties, '$.displayName') as "display_name",
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.rank') as "rank",
json_extract_path_text(properties, '$.isEnabled') as "is_enabled",
subscriptionId,
resourceGroupName,
siteName,
slot,
diagnosticCategory,
detectorName
FROM azure.app_service.diagnostics_site_detector_slots
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = 'replace-me' AND slot = 'replace-me' AND diagnosticCategory = 'replace-me';