Skip to main content

vw_agent_pools

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

Overview​

Namevw_agent_pools
TypeView
Idazure.nexus.vw_agent_pools

Fields​

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

SQL Definition​

SELECT
location as location,
extendedLocation as extended_location,
tags as tags,
JSON_EXTRACT(properties, '$.administratorConfiguration') as "administrator_configuration",
JSON_EXTRACT(properties, '$.agentOptions') as "agent_options",
JSON_EXTRACT(properties, '$.attachedNetworkConfiguration') as "attached_network_configuration",
JSON_EXTRACT(properties, '$.availabilityZones') as "availability_zones",
JSON_EXTRACT(properties, '$.count') as "count",
JSON_EXTRACT(properties, '$.detailedStatus') as "detailed_status",
JSON_EXTRACT(properties, '$.detailedStatusMessage') as "detailed_status_message",
JSON_EXTRACT(properties, '$.kubernetesVersion') as "kubernetes_version",
JSON_EXTRACT(properties, '$.labels') as "labels",
JSON_EXTRACT(properties, '$.mode') as "mode",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.taints') as "taints",
JSON_EXTRACT(properties, '$.upgradeSettings') as "upgrade_settings",
JSON_EXTRACT(properties, '$.vmSkuName') as "vm_sku_name",
subscriptionId,
resourceGroupName,
kubernetesClusterName,
agentPoolName
FROM azure.nexus.agent_pools
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND kubernetesClusterName = 'replace-me';