Skip to main content

vw_servers

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

Overview​

Namevw_servers
TypeView
Idazure.postgresql_hsc.vw_servers

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.serverEdition') as "server_edition",
JSON_EXTRACT(properties, '$.storageQuotaInMb') as "storage_quota_in_mb",
JSON_EXTRACT(properties, '$.vCores') as "v_cores",
JSON_EXTRACT(properties, '$.enableHa') as "enable_ha",
JSON_EXTRACT(properties, '$.enablePublicIpAccess') as "enable_public_ip_access",
JSON_EXTRACT(properties, '$.isReadOnly') as "is_read_only",
JSON_EXTRACT(properties, '$.administratorLogin') as "administrator_login",
JSON_EXTRACT(properties, '$.fullyQualifiedDomainName') as "fully_qualified_domain_name",
JSON_EXTRACT(properties, '$.role') as "role",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.haState') as "ha_state",
JSON_EXTRACT(properties, '$.availabilityZone') as "availability_zone",
JSON_EXTRACT(properties, '$.postgresqlVersion') as "postgresql_version",
JSON_EXTRACT(properties, '$.citusVersion') as "citus_version",
subscriptionId,
resourceGroupName,
clusterName,
serverName
FROM azure.postgresql_hsc.servers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND clusterName = 'replace-me';