vw_sql_virtual_machine_groups

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

Overview

Name	vw_sql_virtual_machine_groups
Type	View
Id	azure.sql_vm.vw_sql_virtual_machine_groups

Fields

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

SQL Definition

Sqlite3

SELECT
location as location,
tags as tags,
systemData as system_data,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.sqlImageOffer') as "sql_image_offer",
JSON_EXTRACT(properties, '$.sqlImageSku') as "sql_image_sku",
JSON_EXTRACT(properties, '$.scaleType') as "scale_type",
JSON_EXTRACT(properties, '$.clusterManagerType') as "cluster_manager_type",
JSON_EXTRACT(properties, '$.clusterConfiguration') as "cluster_configuration",
JSON_EXTRACT(properties, '$.wsfcDomainProfile') as "wsfc_domain_profile",
subscriptionId,
resourceGroupName,
sqlVirtualMachineGroupName
FROM azure.sql_vm.sql_virtual_machine_groups
WHERE subscriptionId = 'replace-me';

Postgres

SELECT
location as location,
tags as tags,
systemData as system_data,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.sqlImageOffer') as "sql_image_offer",
json_extract_path_text(properties, '$.sqlImageSku') as "sql_image_sku",
json_extract_path_text(properties, '$.scaleType') as "scale_type",
json_extract_path_text(properties, '$.clusterManagerType') as "cluster_manager_type",
json_extract_path_text(properties, '$.clusterConfiguration') as "cluster_configuration",
json_extract_path_text(properties, '$.wsfcDomainProfile') as "wsfc_domain_profile",
subscriptionId,
resourceGroupName,
sqlVirtualMachineGroupName
FROM azure.sql_vm.sql_virtual_machine_groups
WHERE subscriptionId = 'replace-me';