Skip to main content

vw_iis_web_servers_controllers

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

Overview​

Namevw_iis_web_servers_controllers
TypeView
Idazure.migrate.vw_iis_web_servers_controllers

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.configurationLocation') as "configuration_location",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.machineIds') as "machine_ids",
JSON_EXTRACT(properties, '$.webApplications') as "web_applications",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.serverFqdn') as "server_fqdn",
JSON_EXTRACT(properties, '$.runAsAccountId') as "run_as_account_id",
JSON_EXTRACT(properties, '$.isDeleted') as "is_deleted",
JSON_EXTRACT(properties, '$.createdTimestamp') as "created_timestamp",
JSON_EXTRACT(properties, '$.updatedTimestamp') as "updated_timestamp",
JSON_EXTRACT(properties, '$.serverType') as "server_type",
JSON_EXTRACT(properties, '$.errors') as "errors",
JSON_EXTRACT(properties, '$.applianceNames') as "appliance_names",
JSON_EXTRACT(properties, '$.hasErrors') as "has_errors",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
siteName,
webAppSiteName,
webServerName
FROM azure.migrate.iis_web_servers_controllers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = 'replace-me' AND webAppSiteName = 'replace-me';