vw_services

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

Overview

Name	vw_services
Type	View
Id	azure_extras.windows_iot.vw_services

Fields

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

SQL Definition

Sqlite3

SELECT
location as location,
etag as etag,
tags as tags,
JSON_EXTRACT(properties, '$.notes') as "notes",
JSON_EXTRACT(properties, '$.startDate') as "start_date",
JSON_EXTRACT(properties, '$.quantity') as "quantity",
JSON_EXTRACT(properties, '$.billingDomainName') as "billing_domain_name",
JSON_EXTRACT(properties, '$.adminDomainName') as "admin_domain_name",
subscriptionId,
resourceGroupName,
deviceName
FROM azure_extras.windows_iot.services
WHERE subscriptionId = 'replace-me';

Postgres

SELECT
location as location,
etag as etag,
tags as tags,
json_extract_path_text(properties, '$.notes') as "notes",
json_extract_path_text(properties, '$.startDate') as "start_date",
json_extract_path_text(properties, '$.quantity') as "quantity",
json_extract_path_text(properties, '$.billingDomainName') as "billing_domain_name",
json_extract_path_text(properties, '$.adminDomainName') as "admin_domain_name",
subscriptionId,
resourceGroupName,
deviceName
FROM azure_extras.windows_iot.services
WHERE subscriptionId = 'replace-me';