vw_updates

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

Overview

Name	vw_updates
Type	View
Id	azure_stack.azure_stack_hci.vw_updates

Fields

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

SQL Definition

Sqlite3

SELECT
location as location,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.installedDate') as "installed_date",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.prerequisites') as "prerequisites",
JSON_EXTRACT(properties, '$.componentVersions') as "component_versions",
JSON_EXTRACT(properties, '$.rebootRequired') as "reboot_required",
JSON_EXTRACT(properties, '$.healthState') as "health_state",
JSON_EXTRACT(properties, '$.healthCheckResult') as "health_check_result",
JSON_EXTRACT(properties, '$.healthCheckDate') as "health_check_date",
JSON_EXTRACT(properties, '$.packagePath') as "package_path",
JSON_EXTRACT(properties, '$.packageSizeInMb') as "package_size_in_mb",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.publisher') as "publisher",
JSON_EXTRACT(properties, '$.releaseLink') as "release_link",
JSON_EXTRACT(properties, '$.availabilityType') as "availability_type",
JSON_EXTRACT(properties, '$.packageType') as "package_type",
JSON_EXTRACT(properties, '$.additionalProperties') as "additional_properties",
JSON_EXTRACT(properties, '$.updateStateProperties') as "update_state_properties",
subscriptionId,
resourceGroupName,
clusterName,
updateName
FROM azure_stack.azure_stack_hci.updates
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND clusterName = 'replace-me';

Postgres

SELECT
location as location,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.installedDate') as "installed_date",
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.state') as "state",
json_extract_path_text(properties, '$.prerequisites') as "prerequisites",
json_extract_path_text(properties, '$.componentVersions') as "component_versions",
json_extract_path_text(properties, '$.rebootRequired') as "reboot_required",
json_extract_path_text(properties, '$.healthState') as "health_state",
json_extract_path_text(properties, '$.healthCheckResult') as "health_check_result",
json_extract_path_text(properties, '$.healthCheckDate') as "health_check_date",
json_extract_path_text(properties, '$.packagePath') as "package_path",
json_extract_path_text(properties, '$.packageSizeInMb') as "package_size_in_mb",
json_extract_path_text(properties, '$.displayName') as "display_name",
json_extract_path_text(properties, '$.version') as "version",
json_extract_path_text(properties, '$.publisher') as "publisher",
json_extract_path_text(properties, '$.releaseLink') as "release_link",
json_extract_path_text(properties, '$.availabilityType') as "availability_type",
json_extract_path_text(properties, '$.packageType') as "package_type",
json_extract_path_text(properties, '$.additionalProperties') as "additional_properties",
json_extract_path_text(properties, '$.updateStateProperties') as "update_state_properties",
subscriptionId,
resourceGroupName,
clusterName,
updateName
FROM azure_stack.azure_stack_hci.updates
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND clusterName = 'replace-me';