vw_diagnostics_site_detectors

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

Overview

Name	vw_diagnostics_site_detectors
Type	View
Id	azure.app_service.vw_diagnostics_site_detectors

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,
diagnosticCategory,
detectorName
FROM azure.app_service.diagnostics_site_detectors
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = '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,
diagnosticCategory,
detectorName
FROM azure.app_service.diagnostics_site_detectors
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = 'replace-me' AND diagnosticCategory = 'replace-me';