vw_device_groups

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

Overview

Name	vw_device_groups
Type	View
Id	azure.sphere.vw_device_groups

Fields

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

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.osFeedType') as "os_feed_type",
JSON_EXTRACT(properties, '$.updatePolicy') as "update_policy",
JSON_EXTRACT(properties, '$.allowCrashDumpsCollection') as "allow_crash_dumps_collection",
JSON_EXTRACT(properties, '$.regionalDataBoundary') as "regional_data_boundary",
JSON_EXTRACT(properties, '$.hasDeployment') as "has_deployment",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
catalogName,
productName,
deviceGroupName
FROM azure.sphere.device_groups
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND catalogName = 'replace-me' AND productName = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.osFeedType') as "os_feed_type",
json_extract_path_text(properties, '$.updatePolicy') as "update_policy",
json_extract_path_text(properties, '$.allowCrashDumpsCollection') as "allow_crash_dumps_collection",
json_extract_path_text(properties, '$.regionalDataBoundary') as "regional_data_boundary",
json_extract_path_text(properties, '$.hasDeployment') as "has_deployment",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
catalogName,
productName,
deviceGroupName
FROM azure.sphere.device_groups
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND catalogName = 'replace-me' AND productName = 'replace-me';