vw_virtual_machine_images

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

Overview

Name	vw_virtual_machine_images
Type	View
Id	azure.compute.vw_virtual_machine_images

Fields

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

SQL Definition

Sqlite3

SELECT
name as name,
location as location,
tags as tags,
extendedLocation as extended_location,
JSON_EXTRACT(properties, '$.plan') as "plan",
JSON_EXTRACT(properties, '$.osDiskImage') as "os_disk_image",
JSON_EXTRACT(properties, '$.dataDiskImages') as "data_disk_images",
JSON_EXTRACT(properties, '$.automaticOSUpgradeProperties') as "automatic_os_upgrade_properties",
JSON_EXTRACT(properties, '$.hyperVGeneration') as "hyper_v_generation",
JSON_EXTRACT(properties, '$.disallowed') as "disallowed",
JSON_EXTRACT(properties, '$.features') as "features",
JSON_EXTRACT(properties, '$.architecture') as "architecture",
JSON_EXTRACT(properties, '$.imageDeprecationStatus') as "image_deprecation_status",
subscriptionId,
location,
publisherName,
offer,
skus,
version,
edgeZone
FROM azure.compute.virtual_machine_images
WHERE subscriptionId = 'replace-me' AND location = 'replace-me' AND edgeZone = 'replace-me';

Postgres

SELECT
name as name,
location as location,
tags as tags,
extendedLocation as extended_location,
json_extract_path_text(properties, '$.plan') as "plan",
json_extract_path_text(properties, '$.osDiskImage') as "os_disk_image",
json_extract_path_text(properties, '$.dataDiskImages') as "data_disk_images",
json_extract_path_text(properties, '$.automaticOSUpgradeProperties') as "automatic_os_upgrade_properties",
json_extract_path_text(properties, '$.hyperVGeneration') as "hyper_v_generation",
json_extract_path_text(properties, '$.disallowed') as "disallowed",
json_extract_path_text(properties, '$.features') as "features",
json_extract_path_text(properties, '$.architecture') as "architecture",
json_extract_path_text(properties, '$.imageDeprecationStatus') as "image_deprecation_status",
subscriptionId,
location,
publisherName,
offer,
skus,
version,
edgeZone
FROM azure.compute.virtual_machine_images
WHERE subscriptionId = 'replace-me' AND location = 'replace-me' AND edgeZone = 'replace-me';