server_sites_controllers

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

Overview

Name	server_sites_controllers
Type	Resource
Id	azure.migrate.server_sites_controllers

Fields

vw_server_sites_controllers

Name	Datatype	Description
agent_details	text	field from the properties object
appliance_name	text	field from the properties object
discovery_solution_id	text	field from the properties object
location	text	The geo-location where the resource lives
master_site_id	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
service_endpoint	text	field from the properties object
service_principal_identity_details	text	field from the properties object
siteName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

server_sites_controllers

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The properties of SiteResource
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, siteName, subscriptionId	Get a ServerSiteResource
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List ServerSiteResource resources by resource group
list_by_subscription	SELECT	subscriptionId	List ServerSiteResource resources by subscription ID
create	INSERT	resourceGroupName, siteName, subscriptionId	Create a ServerSiteResource
delete	DELETE	resourceGroupName, siteName, subscriptionId	Delete a ServerSiteResource
update	UPDATE	resourceGroupName, siteName, subscriptionId	Update a ServerSiteResource
compute_error_summary	EXEC	resourceGroupName, siteName, subscriptionId	Get the error summary for a server site.
computeusage	EXEC	resourceGroupName, siteName, subscriptionId	Get a serve site usage.
export_applications	EXEC	resourceGroupName, siteName, subscriptionId	Method to generate report containing
machine and the deep discovery of the application installed in the machine.
export_machine_errors	EXEC	resourceGroupName, siteName, subscriptionId	Method to generate report containing
machine and the errors encountered during guest discovery of the machine.
refresh_site	EXEC	resourceGroupName, siteName, subscriptionId	Operation to refresh a site
summary	EXEC	resourceGroupName, siteName, subscriptionId	Method to get site usage.

SELECT examples

List ServerSiteResource resources by subscription ID

vw_server_sites_controllers

SELECT
agent_details,
appliance_name,
discovery_solution_id,
location,
master_site_id,
provisioning_state,
resourceGroupName,
service_endpoint,
service_principal_identity_details,
siteName,
subscriptionId,
tags
FROM azure.migrate.vw_server_sites_controllers
WHERE subscriptionId = '{{ subscriptionId }}';

server_sites_controllers

SELECT
location,
properties,
tags
FROM azure.migrate.server_sites_controllers
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new server_sites_controllers resource.

All Properties

/*+ create */
INSERT INTO azure.migrate.server_sites_controllers (
resourceGroupName,
siteName,
subscriptionId,
properties,
tags,
location
)
SELECT 
'{{ resourceGroupName }}',
'{{ siteName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: masterSiteId
          value: string
        - name: servicePrincipalIdentityDetails
          value:
            - name: tenantId
              value: string
            - name: applicationId
              value: string
            - name: objectId
              value: string
            - name: audience
              value: string
            - name: aadAuthority
              value: string
            - name: rawCertData
              value: string
        - name: agentDetails
          value:
            - name: id
              value: string
            - name: version
              value: string
            - name: lastHeartBeatUtc
              value: string
            - name: keyVaultUri
              value: string
            - name: keyVaultId
              value: string
        - name: applianceName
          value: string
        - name: discoverySolutionId
          value: string
        - name: serviceEndpoint
          value: string
        - name: provisioningState
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a server_sites_controllers resource.

/*+ update */
UPDATE azure.migrate.server_sites_controllers
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified server_sites_controllers resource.

/*+ delete */
DELETE FROM azure.migrate.server_sites_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';