sql_run_as_accounts_controllers

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

Overview

Name	sql_run_as_accounts_controllers
Type	Resource
Id	azure.migrate.sql_run_as_accounts_controllers

Fields

vw_sql_run_as_accounts_controllers

Name	Datatype	Description
accountName	text	field from the properties object
appliance_name	text	field from the properties object
created_timestamp	text	field from the properties object
credential_type	text	field from the properties object
display_name	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
sqlSiteName	text	field from the properties object
subscriptionId	text	field from the properties object
updated_timestamp	text	field from the properties object

sql_run_as_accounts_controllers

Name	Datatype	Description
properties	object	Class for run as account properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, siteName, sqlSiteName, subscriptionId	Get a SqlRunAsAccount
list_by_sql_site	SELECT	resourceGroupName, siteName, sqlSiteName, subscriptionId	List SqlRunAsAccount resources by SqlSite

SELECT examples

List SqlRunAsAccount resources by SqlSite

vw_sql_run_as_accounts_controllers

SELECT
accountName,
appliance_name,
created_timestamp,
credential_type,
display_name,
provisioning_state,
resourceGroupName,
siteName,
sqlSiteName,
subscriptionId,
updated_timestamp
FROM azure.migrate.vw_sql_run_as_accounts_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';

sql_run_as_accounts_controllers

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