vw_virtual_machine_scale_set_rolling_upgrades_latest

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

Overview

Name	vw_virtual_machine_scale_set_rolling_upgrades_latest
Type	View
Id	azure.compute.vw_virtual_machine_scale_set_rolling_upgrades_latest

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
JSON_EXTRACT(properties, '$.policy') as "policy",
JSON_EXTRACT(properties, '$.runningStatus') as "running_status",
JSON_EXTRACT(properties, '$.progress') as "progress",
JSON_EXTRACT(properties, '$.error') as "error",
subscriptionId,
resourceGroupName,
vmScaleSetName
FROM azure.compute.virtual_machine_scale_set_rolling_upgrades_latest
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND vmScaleSetName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
json_extract_path_text(properties, '$.policy') as "policy",
json_extract_path_text(properties, '$.runningStatus') as "running_status",
json_extract_path_text(properties, '$.progress') as "progress",
json_extract_path_text(properties, '$.error') as "error",
subscriptionId,
resourceGroupName,
vmScaleSetName
FROM azure.compute.virtual_machine_scale_set_rolling_upgrades_latest
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND vmScaleSetName = 'replace-me';