Skip to main content

vw_devices

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

Overview​

Namevw_devices
TypeView
Idazure.data_box_edge.vw_devices

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
sku as sku,
etag as etag,
identity as identity,
kind as kind,
systemData as system_data,
JSON_EXTRACT(properties, '$.systemData') as "system_data",
JSON_EXTRACT(properties, '$.dataBoxEdgeDeviceStatus') as "data_box_edge_device_status",
JSON_EXTRACT(properties, '$.serialNumber') as "serial_number",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.modelDescription') as "model_description",
JSON_EXTRACT(properties, '$.deviceType') as "device_type",
JSON_EXTRACT(properties, '$.friendlyName') as "friendly_name",
JSON_EXTRACT(properties, '$.culture') as "culture",
JSON_EXTRACT(properties, '$.deviceModel') as "device_model",
JSON_EXTRACT(properties, '$.deviceSoftwareVersion') as "device_software_version",
JSON_EXTRACT(properties, '$.deviceLocalCapacity') as "device_local_capacity",
JSON_EXTRACT(properties, '$.timeZone') as "time_zone",
JSON_EXTRACT(properties, '$.deviceHcsVersion') as "device_hcs_version",
JSON_EXTRACT(properties, '$.configuredRoleTypes') as "configured_role_types",
JSON_EXTRACT(properties, '$.nodeCount') as "node_count",
JSON_EXTRACT(properties, '$.resourceMoveDetails') as "resource_move_details",
JSON_EXTRACT(properties, '$.edgeProfile') as "edge_profile",
JSON_EXTRACT(properties, '$.dataResidency') as "data_residency",
JSON_EXTRACT(properties, '$.kubernetesWorkloadProfile') as "kubernetes_workload_profile",
subscriptionId,
resourceGroupName,
deviceName
FROM azure.data_box_edge.devices
WHERE subscriptionId = 'replace-me';