Skip to main content

vw_tomcat_web_servers_controllers

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

Overview​

Namevw_tomcat_web_servers_controllers
TypeView
Idazure.migrate.vw_tomcat_web_servers_controllers

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.services') as "services",
JSON_EXTRACT(properties, '$.catalinaHome') as "catalina_home",
JSON_EXTRACT(properties, '$.jvmVersion') as "jvm_version",
JSON_EXTRACT(properties, '$.sessionPersistenceMechanism') as "session_persistence_mechanism",
JSON_EXTRACT(properties, '$.isClusteringPresent') as "is_clustering_present",
JSON_EXTRACT(properties, '$.isMemoryRealmPresent') as "is_memory_realm_present",
JSON_EXTRACT(properties, '$.isSessionTrackingPresent') as "is_session_tracking_present",
JSON_EXTRACT(properties, '$.isAccessLogValvePresent') as "is_access_log_valve_present",
JSON_EXTRACT(properties, '$.maxMemoryUsageInMb') as "max_memory_usage_in_mb",
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, '$.operatingSystemDetails') as "operating_system_details",
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.tomcat_web_servers_controllers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = 'replace-me' AND webAppSiteName = 'replace-me';