sql_availability_groups_controllers

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

Overview

Name	sql_availability_groups_controllers
Type	Resource
Id	azure.migrate.sql_availability_groups_controllers

Fields

vw_sql_availability_groups_controllers

Name	Datatype	Description
availability_group_name	text	field from the properties object
availability_group_type	text	field from the properties object
availability_replicas	text	field from the properties object
cluster_name	text	field from the properties object
created_timestamp	text	field from the properties object
is_deleted	text	field from the properties object
is_multi_sub_net	text	field from the properties object
is_part_of_distributed_availability_group	text	field from the properties object
parent_replica_overview_list	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
siteName	text	field from the properties object
sqlAvailabilityGroupName	text	field from the properties object
sqlSiteName	text	field from the properties object
subscriptionId	text	field from the properties object
updated_timestamp	text	field from the properties object

sql_availability_groups_controllers

Name	Datatype	Description
properties	object	Class for SQL Server availability group properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, siteName, sqlAvailabilityGroupName, sqlSiteName, subscriptionId	Gets the sql availability group.
list_by_sql_site	SELECT	resourceGroupName, siteName, sqlSiteName, subscriptionId	Gets the sql availability groups.

SELECT examples

Gets the sql availability groups.

vw_sql_availability_groups_controllers

SELECT
availability_group_name,
availability_group_type,
availability_replicas,
cluster_name,
created_timestamp,
is_deleted,
is_multi_sub_net,
is_part_of_distributed_availability_group,
parent_replica_overview_list,
provisioning_state,
resourceGroupName,
siteName,
sqlAvailabilityGroupName,
sqlSiteName,
subscriptionId,
updated_timestamp
FROM azure.migrate.vw_sql_availability_groups_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';

sql_availability_groups_controllers

SELECT
properties
FROM azure.migrate.sql_availability_groups_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';