sql_servers_controllers

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

Overview

Name	sql_servers_controllers
Type	Resource
Id	azure.migrate.sql_servers_controllers

Fields

vw_sql_servers_controllers

Name	Datatype	Description
created_timestamp	text	field from the properties object
edition	text	field from the properties object
engine_edition	text	field from the properties object
errors	text	field from the properties object
host_name	text	field from the properties object
hydrated_run_as_account_id	text	field from the properties object
hyperthread_ratio	text	field from the properties object
is_clustered	text	field from the properties object
is_deleted	text	field from the properties object
is_high_availability_enabled	text	field from the properties object
logical_cpu_count	text	field from the properties object
machine_arm_ids	text	field from the properties object
machine_overview_list	text	field from the properties object
max_server_memory_in_use_in_mb	text	field from the properties object
num_of_logins	text	field from the properties object
number_of_ag_databases	text	field from the properties object
number_of_user_databases	text	field from the properties object
physical_cpu_count	text	field from the properties object
port_number	text	field from the properties object
product_support_status	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
run_as_account_id	text	field from the properties object
siteName	text	field from the properties object
sqlServerName	text	field from the properties object
sqlSiteName	text	field from the properties object
sql_fci_properties	text	field from the properties object
sql_server_name	text	field from the properties object
sql_start_time	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
sum_of_user_databases_size_in_mb	text	field from the properties object
tags	text	field from the properties object
temp_db_size_in_mb	text	field from the properties object
updated_timestamp	text	field from the properties object
version	text	field from the properties object
visible_online_core_count	text	field from the properties object

sql_servers_controllers

Name	Datatype	Description
properties	object	Class for SQL Server properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, siteName, sqlServerName, sqlSiteName, subscriptionId	Gets the sql server.
list_by_sql_site	SELECT	resourceGroupName, siteName, sqlSiteName, subscriptionId	Gets the sql servers.
update	UPDATE	resourceGroupName, siteName, sqlServerName, sqlSiteName, subscriptionId	Updates the sql server tags.

SELECT examples

Gets the sql servers.

vw_sql_servers_controllers

SELECT
created_timestamp,
edition,
engine_edition,
errors,
host_name,
hydrated_run_as_account_id,
hyperthread_ratio,
is_clustered,
is_deleted,
is_high_availability_enabled,
logical_cpu_count,
machine_arm_ids,
machine_overview_list,
max_server_memory_in_use_in_mb,
num_of_logins,
number_of_ag_databases,
number_of_user_databases,
physical_cpu_count,
port_number,
product_support_status,
provisioning_state,
resourceGroupName,
run_as_account_id,
siteName,
sqlServerName,
sqlSiteName,
sql_fci_properties,
sql_server_name,
sql_start_time,
status,
subscriptionId,
sum_of_user_databases_size_in_mb,
tags,
temp_db_size_in_mb,
updated_timestamp,
version,
visible_online_core_count
FROM azure.migrate.vw_sql_servers_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';

sql_servers_controllers

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

UPDATE example

Updates a sql_servers_controllers resource.

/*+ update */
UPDATE azure.migrate.sql_servers_controllers
SET 
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlServerName = '{{ sqlServerName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';