web_app_sites_controllers

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

Overview

Name	web_app_sites_controllers
Type	Resource
Id	azure.migrate.web_app_sites_controllers

Fields

vw_web_app_sites_controllers

Name	Datatype	Description
discovery_scenario	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
siteName	text	field from the properties object
site_appliance_properties_collection	text	field from the properties object
subscriptionId	text	field from the properties object
webAppSiteName	text	field from the properties object

web_app_sites_controllers

Name	Datatype	Description
properties	object	Class for Web app site properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, siteName, subscriptionId, webAppSiteName	Method to get a site.
list_by_master_site	SELECT	resourceGroupName, siteName, subscriptionId	Method to get all sites.
create	INSERT	resourceGroupName, siteName, subscriptionId, webAppSiteName	Method to create a WebApp site.
delete	DELETE	resourceGroupName, siteName, subscriptionId, webAppSiteName	Deletes the WebApp site.
update	UPDATE	resourceGroupName, siteName, subscriptionId, webAppSiteName	Method to update an existing site.
error_summary	EXEC	resourceGroupName, siteName, subscriptionId, webAppSiteName	MMethod to get error summary from web app site.
export_inventory	EXEC	resourceGroupName, siteName, subscriptionId, webAppSiteName	Method to generate report containing web app inventory.
refresh	EXEC	resourceGroupName, siteName, subscriptionId, webAppSiteName	Method to refresh a site.
summary	EXEC	resourceGroupName, siteName, subscriptionId, webAppSiteName	Method to get site usage/summary.

SELECT examples

Method to get all sites.

vw_web_app_sites_controllers

SELECT
discovery_scenario,
provisioning_state,
resourceGroupName,
service_endpoint,
siteName,
site_appliance_properties_collection,
subscriptionId,
webAppSiteName
FROM azure.migrate.vw_web_app_sites_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';

web_app_sites_controllers

SELECT
properties
FROM azure.migrate.web_app_sites_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: siteAppliancePropertiesCollection
          value:
            - - 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: discoveryScenario
          value: []
        - name: serviceEndpoint
          value: string
        - name: provisioningState
          value: []

UPDATE example

Updates a web_app_sites_controllers resource.

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

DELETE example

Deletes the specified web_app_sites_controllers resource.

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