Skip to main content

vw_virtual_machine_image_templates

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

Overview​

Namevw_virtual_machine_image_templates
TypeView
Idazure.image_builder.vw_virtual_machine_image_templates

Fields​

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

SQL Definition​

SELECT
location as location,
identity as identity,
tags as tags,
JSON_EXTRACT(properties, '$.source') as "source",
JSON_EXTRACT(properties, '$.customize') as "customize",
JSON_EXTRACT(properties, '$.optimize') as "optimize",
JSON_EXTRACT(properties, '$.validate') as "validate",
JSON_EXTRACT(properties, '$.distribute') as "distribute",
JSON_EXTRACT(properties, '$.errorHandling') as "error_handling",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.provisioningError') as "provisioning_error",
JSON_EXTRACT(properties, '$.lastRunStatus') as "last_run_status",
JSON_EXTRACT(properties, '$.buildTimeoutInMinutes') as "build_timeout_in_minutes",
JSON_EXTRACT(properties, '$.vmProfile') as "vm_profile",
JSON_EXTRACT(properties, '$.stagingResourceGroup') as "staging_resource_group",
JSON_EXTRACT(properties, '$.exactStagingResourceGroup') as "exact_staging_resource_group",
JSON_EXTRACT(properties, '$.autoRun') as "auto_run",
JSON_EXTRACT(properties, '$.managedResourceTags') as "managed_resource_tags",
subscriptionId,
resourceGroupName,
imageTemplateName
FROM azure.image_builder.virtual_machine_image_templates
WHERE subscriptionId = 'replace-me';