sites_controllers

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

Overview

Name	sites_controllers
Type	Resource
Id	azure.migrate.sites_controllers

Fields

vw_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
e_tag	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.

sites_controllers

Name	Datatype	Description
eTag	string	If 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.
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 VmwareSite
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Get all the vmware sites in the resource group.
list_by_subscription	SELECT	subscriptionId	Get all the vmware sites in the subscription.
create	INSERT	resourceGroupName, siteName, subscriptionId	Create a VmwareSite
delete	DELETE	resourceGroupName, siteName, subscriptionId	Delete a VmwareSite
update	UPDATE	resourceGroupName, siteName, subscriptionId	Update a VmwareSite
compute_error_summary	EXEC	resourceGroupName, siteName, subscriptionId	Method to get site error summary.
computeusage	EXEC	resourceGroupName, siteName, subscriptionId	Method to get site error summary.
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.
export_machines	EXEC	resourceGroupName, siteName, subscriptionId	Method to generate report containing
machine and the deep discovery of the application installed in the machine.
summary	EXEC	resourceGroupName, siteName, subscriptionId	Method to get site usage/summary.

SELECT examples

Get all the vmware sites in the subscription.

vw_sites_controllers

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

sites_controllers

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.migrate.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: eTag
      value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a sites_controllers resource.

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

DELETE example

Deletes the specified sites_controllers resource.

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