Skip to main content

web_app_discovery_site_data_sources_controllers

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

Overview

Nameweb_app_discovery_site_data_sources_controllers
TypeResource
Idazure.migrate.web_app_discovery_site_data_sources_controllers

Fields

NameDatatypeDescription
discoverySiteDataSourceNametextfield from the properties object
discovery_site_idtextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
siteNametextfield from the properties object
subscriptionIdtextfield from the properties object
webAppSiteNametextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTdiscoverySiteDataSourceName, resourceGroupName, siteName, subscriptionId, webAppSiteNameMethod to get a Web app data source in site.
list_by_web_app_siteSELECTresourceGroupName, siteName, subscriptionId, webAppSiteNameMethod to get all Web app data sources in site.
createINSERTdiscoverySiteDataSourceName, resourceGroupName, siteName, subscriptionId, webAppSiteNameMethod to create or update a Web app data source in site.
deleteDELETEdiscoverySiteDataSourceName, resourceGroupName, siteName, subscriptionId, webAppSiteNameMethod to delete a Web app data source in site.

SELECT examples

Method to get all Web app data sources in site.

SELECT
discoverySiteDataSourceName,
discovery_site_id,
provisioning_state,
resourceGroupName,
siteName,
subscriptionId,
webAppSiteName
FROM azure.migrate.vw_web_app_discovery_site_data_sources_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND webAppSiteName = '{{ webAppSiteName }}';

INSERT example

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

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

DELETE example

Deletes the specified web_app_discovery_site_data_sources_controllers resource.

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