Skip to main content

vw_managed_clusters

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

Overview​

Namevw_managed_clusters
TypeView
Idazure.aks.vw_managed_clusters

Fields​

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

SQL Definition​

SELECT
location as location,
sku as sku,
extendedLocation as extended_location,
identity as identity,
tags as tags,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.powerState') as "power_state",
JSON_EXTRACT(properties, '$.maxAgentPools') as "max_agent_pools",
JSON_EXTRACT(properties, '$.kubernetesVersion') as "kubernetes_version",
JSON_EXTRACT(properties, '$.currentKubernetesVersion') as "current_kubernetes_version",
JSON_EXTRACT(properties, '$.dnsPrefix') as "dns_prefix",
JSON_EXTRACT(properties, '$.fqdnSubdomain') as "fqdn_subdomain",
JSON_EXTRACT(properties, '$.fqdn') as "fqdn",
JSON_EXTRACT(properties, '$.privateFQDN') as "private_fqdn",
JSON_EXTRACT(properties, '$.azurePortalFQDN') as "azure_portal_fqdn",
JSON_EXTRACT(properties, '$.agentPoolProfiles') as "agent_pool_profiles",
JSON_EXTRACT(properties, '$.linuxProfile') as "linux_profile",
JSON_EXTRACT(properties, '$.windowsProfile') as "windows_profile",
JSON_EXTRACT(properties, '$.servicePrincipalProfile') as "service_principal_profile",
JSON_EXTRACT(properties, '$.addonProfiles') as "addon_profiles",
JSON_EXTRACT(properties, '$.podIdentityProfile') as "pod_identity_profile",
JSON_EXTRACT(properties, '$.oidcIssuerProfile') as "oidc_issuer_profile",
JSON_EXTRACT(properties, '$.nodeResourceGroup') as "node_resource_group",
JSON_EXTRACT(properties, '$.enableRBAC') as "enable_rbac",
JSON_EXTRACT(properties, '$.supportPlan') as "support_plan",
JSON_EXTRACT(properties, '$.enablePodSecurityPolicy') as "enable_pod_security_policy",
JSON_EXTRACT(properties, '$.networkProfile') as "network_profile",
JSON_EXTRACT(properties, '$.aadProfile') as "aad_profile",
JSON_EXTRACT(properties, '$.autoUpgradeProfile') as "auto_upgrade_profile",
JSON_EXTRACT(properties, '$.upgradeSettings') as "upgrade_settings",
JSON_EXTRACT(properties, '$.autoScalerProfile') as "auto_scaler_profile",
JSON_EXTRACT(properties, '$.apiServerAccessProfile') as "api_server_access_profile",
JSON_EXTRACT(properties, '$.diskEncryptionSetID') as "disk_encryption_set_id",
JSON_EXTRACT(properties, '$.identityProfile') as "identity_profile",
JSON_EXTRACT(properties, '$.privateLinkResources') as "private_link_resources",
JSON_EXTRACT(properties, '$.disableLocalAccounts') as "disable_local_accounts",
JSON_EXTRACT(properties, '$.httpProxyConfig') as "http_proxy_config",
JSON_EXTRACT(properties, '$.securityProfile') as "security_profile",
JSON_EXTRACT(properties, '$.storageProfile') as "storage_profile",
JSON_EXTRACT(properties, '$.ingressProfile') as "ingress_profile",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.workloadAutoScalerProfile') as "workload_auto_scaler_profile",
JSON_EXTRACT(properties, '$.azureMonitorProfile') as "azure_monitor_profile",
JSON_EXTRACT(properties, '$.serviceMeshProfile') as "service_mesh_profile",
JSON_EXTRACT(properties, '$.resourceUID') as "resource_uid",
JSON_EXTRACT(properties, '$.metricsProfile') as "metrics_profile",
subscriptionId,
resourceGroupName,
resourceName
FROM azure.aks.managed_clusters
WHERE subscriptionId = 'replace-me';