Skip to main content

vw_images

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

Overview​

Namevw_images
TypeView
Idazure.lab_services.vw_images

Fields​

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

SQL Definition​

SELECT
systemData as system_data,
JSON_EXTRACT(properties, '$.enabledState') as "enabled_state",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.iconUrl') as "icon_url",
JSON_EXTRACT(properties, '$.author') as "author",
JSON_EXTRACT(properties, '$.osType') as "os_type",
JSON_EXTRACT(properties, '$.plan') as "plan",
JSON_EXTRACT(properties, '$.termsStatus') as "terms_status",
JSON_EXTRACT(properties, '$.offer') as "offer",
JSON_EXTRACT(properties, '$.publisher') as "publisher",
JSON_EXTRACT(properties, '$.sku') as "sku",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.sharedGalleryId') as "shared_gallery_id",
JSON_EXTRACT(properties, '$.availableRegions') as "available_regions",
JSON_EXTRACT(properties, '$.osState') as "os_state",
subscriptionId,
resourceGroupName,
labPlanName,
imageName
FROM azure.lab_services.images
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND labPlanName = 'replace-me';