Skip to main content

master_sites_controllers

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

Overview

Namemaster_sites_controllers
TypeResource
Idazure.migrate.master_sites_controllers

Fields

The following fields are returned by SELECT queries:

ARM operation completed successfully.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, siteNameGet a MasterSite
list_by_resource_groupselectsubscriptionId, resourceGroupNameGet all the sites in the resource group.
list_by_subscriptionselectsubscriptionIdList MasterSite resources by subscription ID
createinsertsubscriptionId, resourceGroupName, siteNameMethod to create or update a site.
updateupdatesubscriptionId, resourceGroupName, siteNameMethod to update an existing site.
deletedeletesubscriptionId, resourceGroupName, siteNameMethod to delete a site.
error_summaryexecsubscriptionId, resourceGroupName, siteNameMethod to get error summary from master site for an appliance.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
siteNamestringSite name
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Get a MasterSite

SELECT
location,
properties,
tags
FROM azure.migrate.master_sites_controllers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND siteName = '{{ siteName }}' -- required
;

INSERT examples

Method to create or update a site.

INSERT INTO azure.migrate.master_sites_controllers (
data__properties,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
siteName
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ siteName }}'
RETURNING
location,
properties,
tags
;

UPDATE examples

Method to update an existing site.

UPDATE azure.migrate.master_sites_controllers
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND siteName = '{{ siteName }}' --required
RETURNING
location,
properties,
tags;

DELETE examples

Method to delete a site.

DELETE FROM azure.migrate.master_sites_controllers
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND siteName = '{{ siteName }}' --required
;

Lifecycle Methods

Method to get error summary from master site for an appliance.

EXEC azure.migrate.master_sites_controllers.error_summary 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@siteName='{{ siteName }}' --required
@@json=
'{
"applianceName": "{{ applianceName }}"
}'
;