Skip to main content

sites_controllers

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

Overview

Namesites_controllers
TypeResource
Idazure.migrate.sites_controllers

Fields

The following fields are returned by SELECT queries:

ARM operation completed successfully.

NameDatatypeDescription
eTagstringIf eTag is provided in the response body, it may also be provided as a header per the normal etag convention. Entity tags are used for comparing two or more entities from the same requested resource. HTTP/1.1 uses entity tags in the etag (section 14.19), If-Match (section 14.24), If-None-Match (section 14.26), and If-Range (section 14.27) header fields.
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 VmwareSite
list_by_resource_groupselectsubscriptionId, resourceGroupNameGet all the vmware sites in the resource group.
list_by_subscriptionselectsubscriptionIdGet all the vmware sites in the subscription.
createinsertsubscriptionId, resourceGroupName, siteNameCreate a VmwareSite
updateupdatesubscriptionId, resourceGroupName, siteNameUpdate a VmwareSite
deletedeletesubscriptionId, resourceGroupName, siteNameDelete a VmwareSite
compute_error_summaryexecsubscriptionId, resourceGroupName, siteNameMethod to get site error summary.
computeusageexecsubscriptionId, resourceGroupName, siteNameMethod to get site error summary.
export_applicationsexecsubscriptionId, resourceGroupName, siteNameMethod to generate report containing
machine and the deep discovery of the application installed in the machine.
export_machine_errorsexecsubscriptionId, resourceGroupName, siteNameMethod to generate report containing
machine and the errors encountered during guest discovery of the machine.
export_machinesexecsubscriptionId, resourceGroupName, siteNameMethod to generate report containing
machine and the deep discovery of the application installed in the machine.
summaryexecsubscriptionId, resourceGroupName, siteNameMethod to get site usage/summary.

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 VmwareSite

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

INSERT examples

Create a VmwareSite

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

UPDATE examples

Update a VmwareSite

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

DELETE examples

Delete a VmwareSite

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

Lifecycle Methods

Method to get site error summary.

EXEC azure.migrate.sites_controllers.compute_error_summary 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@siteName='{{ siteName }}' --required
;