Skip to main content

vw_agent_pools

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

Overview​

Namevw_agent_pools
TypeView
Idazure.aks.vw_agent_pools

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
type as type,
JSON_EXTRACT(properties, '$.count') as "count",
JSON_EXTRACT(properties, '$.vmSize') as "vm_size",
JSON_EXTRACT(properties, '$.osDiskSizeGB') as "os_disk_size_gb",
JSON_EXTRACT(properties, '$.osDiskType') as "os_disk_type",
JSON_EXTRACT(properties, '$.kubeletDiskType') as "kubelet_disk_type",
JSON_EXTRACT(properties, '$.workloadRuntime') as "workload_runtime",
JSON_EXTRACT(properties, '$.vnetSubnetID') as "vnet_subnet_id",
JSON_EXTRACT(properties, '$.podSubnetID') as "pod_subnet_id",
JSON_EXTRACT(properties, '$.maxPods') as "max_pods",
JSON_EXTRACT(properties, '$.osType') as "os_type",
JSON_EXTRACT(properties, '$.osSKU') as "os_sku",
JSON_EXTRACT(properties, '$.maxCount') as "max_count",
JSON_EXTRACT(properties, '$.minCount') as "min_count",
JSON_EXTRACT(properties, '$.enableAutoScaling') as "enable_auto_scaling",
JSON_EXTRACT(properties, '$.scaleDownMode') as "scale_down_mode",
JSON_EXTRACT(properties, '$.type') as "type",
JSON_EXTRACT(properties, '$.mode') as "mode",
JSON_EXTRACT(properties, '$.orchestratorVersion') as "orchestrator_version",
JSON_EXTRACT(properties, '$.currentOrchestratorVersion') as "current_orchestrator_version",
JSON_EXTRACT(properties, '$.nodeImageVersion') as "node_image_version",
JSON_EXTRACT(properties, '$.upgradeSettings') as "upgrade_settings",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.powerState') as "power_state",
JSON_EXTRACT(properties, '$.availabilityZones') as "availability_zones",
JSON_EXTRACT(properties, '$.enableNodePublicIP') as "enable_node_public_ip",
JSON_EXTRACT(properties, '$.nodePublicIPPrefixID') as "node_public_ip_prefix_id",
JSON_EXTRACT(properties, '$.scaleSetPriority') as "scale_set_priority",
JSON_EXTRACT(properties, '$.scaleSetEvictionPolicy') as "scale_set_eviction_policy",
JSON_EXTRACT(properties, '$.spotMaxPrice') as "spot_max_price",
JSON_EXTRACT(properties, '$.tags') as "tags",
JSON_EXTRACT(properties, '$.nodeLabels') as "node_labels",
JSON_EXTRACT(properties, '$.nodeTaints') as "node_taints",
JSON_EXTRACT(properties, '$.proximityPlacementGroupID') as "proximity_placement_group_id",
JSON_EXTRACT(properties, '$.kubeletConfig') as "kubelet_config",
JSON_EXTRACT(properties, '$.linuxOSConfig') as "linux_os_config",
JSON_EXTRACT(properties, '$.enableEncryptionAtHost') as "enable_encryption_at_host",
JSON_EXTRACT(properties, '$.enableUltraSSD') as "enable_ultra_ssd",
JSON_EXTRACT(properties, '$.enableFIPS') as "enable_fips",
JSON_EXTRACT(properties, '$.gpuInstanceProfile') as "gpu_instance_profile",
JSON_EXTRACT(properties, '$.creationData') as "creation_data",
JSON_EXTRACT(properties, '$.capacityReservationGroupID') as "capacity_reservation_group_id",
JSON_EXTRACT(properties, '$.hostGroupID') as "host_group_id",
JSON_EXTRACT(properties, '$.networkProfile') as "network_profile",
JSON_EXTRACT(properties, '$.windowsProfile') as "windows_profile",
JSON_EXTRACT(properties, '$.securityProfile') as "security_profile",
subscriptionId,
resourceGroupName,
resourceName,
agentPoolName
FROM azure.aks.agent_pools
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND resourceName = 'replace-me';