vw_springbootservers
Creates, updates, deletes, gets or lists a vw_springbootservers resource.
Overview
| Name | vw_springbootservers |
| Type | View |
| Id | azure_extras.off_azure_springboot.vw_springbootservers |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
JSON_EXTRACT(properties, '$.port') as "port",
JSON_EXTRACT(properties, '$.server') as "server",
JSON_EXTRACT(properties, '$.fqdnAndIpAddressList') as "fqdn_and_ip_address_list",
JSON_EXTRACT(properties, '$.machineArmId') as "machine_arm_id",
JSON_EXTRACT(properties, '$.totalApps') as "total_apps",
JSON_EXTRACT(properties, '$.springBootApps') as "spring_boot_apps",
JSON_EXTRACT(properties, '$.errors') as "errors",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.labels') as "labels",
subscriptionId,
resourceGroupName,
siteName,
springbootserversName
FROM azure_extras.off_azure_springboot.springbootservers
WHERE subscriptionId = 'replace-me' AND siteName = 'replace-me';
SELECT
json_extract_path_text(properties, '$.port') as "port",
json_extract_path_text(properties, '$.server') as "server",
json_extract_path_text(properties, '$.fqdnAndIpAddressList') as "fqdn_and_ip_address_list",
json_extract_path_text(properties, '$.machineArmId') as "machine_arm_id",
json_extract_path_text(properties, '$.totalApps') as "total_apps",
json_extract_path_text(properties, '$.springBootApps') as "spring_boot_apps",
json_extract_path_text(properties, '$.errors') as "errors",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.labels') as "labels",
subscriptionId,
resourceGroupName,
siteName,
springbootserversName
FROM azure_extras.off_azure_springboot.springbootservers
WHERE subscriptionId = 'replace-me' AND siteName = 'replace-me';