Skip to main content

vw_managed_clusters

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

Overview​

Namevw_managed_clusters
TypeView
Idazure.service_fabric_managed_clusters.vw_managed_clusters

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
etag as etag,
systemData as system_data,
sku as sku,
JSON_EXTRACT(properties, '$.dnsName') as "dns_name",
JSON_EXTRACT(properties, '$.fqdn') as "fqdn",
JSON_EXTRACT(properties, '$.ipv4Address') as "ipv4_address",
JSON_EXTRACT(properties, '$.clusterId') as "cluster_id",
JSON_EXTRACT(properties, '$.clusterState') as "cluster_state",
JSON_EXTRACT(properties, '$.clusterCertificateThumbprints') as "cluster_certificate_thumbprints",
JSON_EXTRACT(properties, '$.clientConnectionPort') as "client_connection_port",
JSON_EXTRACT(properties, '$.httpGatewayConnectionPort') as "http_gateway_connection_port",
JSON_EXTRACT(properties, '$.adminUserName') as "admin_user_name",
JSON_EXTRACT(properties, '$.adminPassword') as "admin_password",
JSON_EXTRACT(properties, '$.loadBalancingRules') as "load_balancing_rules",
JSON_EXTRACT(properties, '$.allowRdpAccess') as "allow_rdp_access",
JSON_EXTRACT(properties, '$.networkSecurityRules') as "network_security_rules",
JSON_EXTRACT(properties, '$.clients') as "clients",
JSON_EXTRACT(properties, '$.azureActiveDirectory') as "azure_active_directory",
JSON_EXTRACT(properties, '$.fabricSettings') as "fabric_settings",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.clusterCodeVersion') as "cluster_code_version",
JSON_EXTRACT(properties, '$.clusterUpgradeMode') as "cluster_upgrade_mode",
JSON_EXTRACT(properties, '$.clusterUpgradeCadence') as "cluster_upgrade_cadence",
JSON_EXTRACT(properties, '$.addonFeatures') as "addon_features",
JSON_EXTRACT(properties, '$.enableAutoOSUpgrade') as "enable_auto_os_upgrade",
JSON_EXTRACT(properties, '$.zonalResiliency') as "zonal_resiliency",
JSON_EXTRACT(properties, '$.applicationTypeVersionsCleanupPolicy') as "application_type_versions_cleanup_policy",
JSON_EXTRACT(properties, '$.enableIpv6') as "enable_ipv6",
JSON_EXTRACT(properties, '$.subnetId') as "subnet_id",
JSON_EXTRACT(properties, '$.ipTags') as "ip_tags",
JSON_EXTRACT(properties, '$.ipv6Address') as "ipv6_address",
JSON_EXTRACT(properties, '$.enableServicePublicIP') as "enable_service_public_ip",
JSON_EXTRACT(properties, '$.auxiliarySubnets') as "auxiliary_subnets",
JSON_EXTRACT(properties, '$.serviceEndpoints') as "service_endpoints",
JSON_EXTRACT(properties, '$.zonalUpdateMode') as "zonal_update_mode",
JSON_EXTRACT(properties, '$.useCustomVnet') as "use_custom_vnet",
JSON_EXTRACT(properties, '$.publicIPPrefixId') as "public_ip_prefix_id",
JSON_EXTRACT(properties, '$.publicIPv6PrefixId') as "public_ipv6_prefix_id",
JSON_EXTRACT(properties, '$.ddosProtectionPlanId') as "ddos_protection_plan_id",
JSON_EXTRACT(properties, '$.upgradeDescription') as "upgrade_description",
JSON_EXTRACT(properties, '$.httpGatewayTokenAuthConnectionPort') as "http_gateway_token_auth_connection_port",
JSON_EXTRACT(properties, '$.enableHttpGatewayExclusiveAuthMode') as "enable_http_gateway_exclusive_auth_mode",
JSON_EXTRACT(properties, '$.autoGeneratedDomainNameLabelScope') as "auto_generated_domain_name_label_scope",
JSON_EXTRACT(properties, '$.customFqdn') as "custom_fqdn",
subscriptionId,
resourceGroupName,
clusterName
FROM azure.service_fabric_managed_clusters.managed_clusters
WHERE subscriptionId = 'replace-me';