vw_virtual_machine_scale_set_extensions
Creates, updates, deletes, gets or lists a vw_virtual_machine_scale_set_extensions
resource.
Overview
Name | vw_virtual_machine_scale_set_extensions |
Type | View |
Id | azure.compute.vw_virtual_machine_scale_set_extensions |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
id as id,
name as name,
type as type,
JSON_EXTRACT(properties, '$.forceUpdateTag') as "force_update_tag",
JSON_EXTRACT(properties, '$.publisher') as "publisher",
JSON_EXTRACT(properties, '$.type') as "type",
JSON_EXTRACT(properties, '$.typeHandlerVersion') as "type_handler_version",
JSON_EXTRACT(properties, '$.autoUpgradeMinorVersion') as "auto_upgrade_minor_version",
JSON_EXTRACT(properties, '$.enableAutomaticUpgrade') as "enable_automatic_upgrade",
JSON_EXTRACT(properties, '$.settings') as "settings",
JSON_EXTRACT(properties, '$.protectedSettings') as "protected_settings",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.provisionAfterExtensions') as "provision_after_extensions",
JSON_EXTRACT(properties, '$.suppressFailures') as "suppress_failures",
JSON_EXTRACT(properties, '$.protectedSettingsFromKeyVault') as "protected_settings_from_key_vault",
subscriptionId,
resourceGroupName,
vmScaleSetName,
vmssExtensionName
FROM azure.compute.virtual_machine_scale_set_extensions
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND vmScaleSetName = 'replace-me';
SELECT
id as id,
name as name,
type as type,
json_extract_path_text(properties, '$.forceUpdateTag') as "force_update_tag",
json_extract_path_text(properties, '$.publisher') as "publisher",
json_extract_path_text(properties, '$.type') as "type",
json_extract_path_text(properties, '$.typeHandlerVersion') as "type_handler_version",
json_extract_path_text(properties, '$.autoUpgradeMinorVersion') as "auto_upgrade_minor_version",
json_extract_path_text(properties, '$.enableAutomaticUpgrade') as "enable_automatic_upgrade",
json_extract_path_text(properties, '$.settings') as "settings",
json_extract_path_text(properties, '$.protectedSettings') as "protected_settings",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.provisionAfterExtensions') as "provision_after_extensions",
json_extract_path_text(properties, '$.suppressFailures') as "suppress_failures",
json_extract_path_text(properties, '$.protectedSettingsFromKeyVault') as "protected_settings_from_key_vault",
subscriptionId,
resourceGroupName,
vmScaleSetName,
vmssExtensionName
FROM azure.compute.virtual_machine_scale_set_extensions
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND vmScaleSetName = 'replace-me';