Skip to main content

server_sites_controllers

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

Overview

Nameserver_sites_controllers
TypeResource
Idazure.migrate.server_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 ServerSiteResource
list_by_resource_groupselectsubscriptionId, resourceGroupNameList ServerSiteResource resources by resource group
list_by_subscriptionselectsubscriptionIdList ServerSiteResource resources by subscription ID
createinsertsubscriptionId, resourceGroupName, siteNameCreate a ServerSiteResource
updateupdatesubscriptionId, resourceGroupName, siteNameUpdate a ServerSiteResource
deletedeletesubscriptionId, resourceGroupName, siteNameDelete a ServerSiteResource
compute_error_summaryexecsubscriptionId, resourceGroupName, siteNameGet the error summary for a server site.
computeusageexecsubscriptionId, resourceGroupName, siteNameGet a serve site usage.
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.
refresh_siteexecsubscriptionId, resourceGroupName, siteNameOperation to refresh a site
summaryexecsubscriptionId, resourceGroupName, siteNameMethod to get site usage.

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 ServerSiteResource

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

INSERT examples

Create a ServerSiteResource

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

UPDATE examples

Update a ServerSiteResource

UPDATE azure.migrate.server_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

Delete a ServerSiteResource

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

Lifecycle Methods

Get the error summary for a server site.

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