Skip to main content

vw_sap_application_server_instances

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

Overview​

Namevw_sap_application_server_instances
TypeView
Idazure_isv.sap_workloads.vw_sap_application_server_instances

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.instanceNo') as "instance_no",
JSON_EXTRACT(properties, '$.subnet') as "subnet",
JSON_EXTRACT(properties, '$.hostname') as "hostname",
JSON_EXTRACT(properties, '$.kernelVersion') as "kernel_version",
JSON_EXTRACT(properties, '$.kernelPatch') as "kernel_patch",
JSON_EXTRACT(properties, '$.ipAddress') as "ip_address",
JSON_EXTRACT(properties, '$.gatewayPort') as "gateway_port",
JSON_EXTRACT(properties, '$.icmHttpPort') as "icm_http_port",
JSON_EXTRACT(properties, '$.icmHttpsPort') as "icm_https_port",
JSON_EXTRACT(properties, '$.loadBalancerDetails') as "load_balancer_details",
JSON_EXTRACT(properties, '$.vmDetails') as "vm_details",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.health') as "health",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.errors') as "errors",
subscriptionId,
resourceGroupName,
sapVirtualInstanceName,
applicationInstanceName
FROM azure_isv.sap_workloads.sap_application_server_instances
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND sapVirtualInstanceName = 'replace-me';