Skip to main content

vw_sql_availability_groups_controllers

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

Overview​

Namevw_sql_availability_groups_controllers
TypeView
Idazure.migrate.vw_sql_availability_groups_controllers

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.availabilityGroupName') as "availability_group_name",
JSON_EXTRACT(properties, '$.availabilityGroupType') as "availability_group_type",
JSON_EXTRACT(properties, '$.isMultiSubNet') as "is_multi_sub_net",
JSON_EXTRACT(properties, '$.clusterName') as "cluster_name",
JSON_EXTRACT(properties, '$.availabilityReplicas') as "availability_replicas",
JSON_EXTRACT(properties, '$.parentReplicaOverviewList') as "parent_replica_overview_list",
JSON_EXTRACT(properties, '$.isPartOfDistributedAvailabilityGroup') as "is_part_of_distributed_availability_group",
JSON_EXTRACT(properties, '$.isDeleted') as "is_deleted",
JSON_EXTRACT(properties, '$.createdTimestamp') as "created_timestamp",
JSON_EXTRACT(properties, '$.updatedTimestamp') as "updated_timestamp",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
siteName,
sqlSiteName,
sqlAvailabilityGroupName
FROM azure.migrate.sql_availability_groups_controllers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = 'replace-me' AND sqlSiteName = 'replace-me';