Skip to main content

vw_node_types

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

Overview​

Namevw_node_types
TypeView
Idazure.service_fabric_managed_clusters.vw_node_types

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,
tags as tags,
systemData as system_data,
sku as sku,
JSON_EXTRACT(properties, '$.isPrimary') as "is_primary",
JSON_EXTRACT(properties, '$.vmInstanceCount') as "vm_instance_count",
JSON_EXTRACT(properties, '$.dataDiskSizeGB') as "data_disk_size_gb",
JSON_EXTRACT(properties, '$.dataDiskType') as "data_disk_type",
JSON_EXTRACT(properties, '$.dataDiskLetter') as "data_disk_letter",
JSON_EXTRACT(properties, '$.placementProperties') as "placement_properties",
JSON_EXTRACT(properties, '$.capacities') as "capacities",
JSON_EXTRACT(properties, '$.applicationPorts') as "application_ports",
JSON_EXTRACT(properties, '$.ephemeralPorts') as "ephemeral_ports",
JSON_EXTRACT(properties, '$.vmSize') as "vm_size",
JSON_EXTRACT(properties, '$.vmImagePublisher') as "vm_image_publisher",
JSON_EXTRACT(properties, '$.vmImageOffer') as "vm_image_offer",
JSON_EXTRACT(properties, '$.vmImageSku') as "vm_image_sku",
JSON_EXTRACT(properties, '$.vmImageVersion') as "vm_image_version",
JSON_EXTRACT(properties, '$.vmSecrets') as "vm_secrets",
JSON_EXTRACT(properties, '$.vmExtensions') as "vm_extensions",
JSON_EXTRACT(properties, '$.vmManagedIdentity') as "vm_managed_identity",
JSON_EXTRACT(properties, '$.isStateless') as "is_stateless",
JSON_EXTRACT(properties, '$.multiplePlacementGroups') as "multiple_placement_groups",
JSON_EXTRACT(properties, '$.frontendConfigurations') as "frontend_configurations",
JSON_EXTRACT(properties, '$.networkSecurityRules') as "network_security_rules",
JSON_EXTRACT(properties, '$.additionalDataDisks') as "additional_data_disks",
JSON_EXTRACT(properties, '$.enableEncryptionAtHost') as "enable_encryption_at_host",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.enableAcceleratedNetworking') as "enable_accelerated_networking",
JSON_EXTRACT(properties, '$.useDefaultPublicLoadBalancer') as "use_default_public_load_balancer",
JSON_EXTRACT(properties, '$.useTempDataDisk') as "use_temp_data_disk",
JSON_EXTRACT(properties, '$.enableOverProvisioning') as "enable_over_provisioning",
JSON_EXTRACT(properties, '$.zones') as "zones",
JSON_EXTRACT(properties, '$.isSpotVM') as "is_spot_vm",
JSON_EXTRACT(properties, '$.hostGroupId') as "host_group_id",
JSON_EXTRACT(properties, '$.useEphemeralOSDisk') as "use_ephemeral_os_disk",
JSON_EXTRACT(properties, '$.spotRestoreTimeout') as "spot_restore_timeout",
JSON_EXTRACT(properties, '$.evictionPolicy') as "eviction_policy",
JSON_EXTRACT(properties, '$.vmImageResourceId') as "vm_image_resource_id",
JSON_EXTRACT(properties, '$.subnetId') as "subnet_id",
JSON_EXTRACT(properties, '$.vmSetupActions') as "vm_setup_actions",
JSON_EXTRACT(properties, '$.securityType') as "security_type",
JSON_EXTRACT(properties, '$.secureBootEnabled') as "secure_boot_enabled",
JSON_EXTRACT(properties, '$.enableNodePublicIP') as "enable_node_public_ip",
JSON_EXTRACT(properties, '$.enableNodePublicIPv6') as "enable_node_public_ipv6",
JSON_EXTRACT(properties, '$.vmSharedGalleryImageId') as "vm_shared_gallery_image_id",
JSON_EXTRACT(properties, '$.natGatewayId') as "nat_gateway_id",
JSON_EXTRACT(properties, '$.natConfigurations') as "nat_configurations",
JSON_EXTRACT(properties, '$.vmImagePlan') as "vm_image_plan",
JSON_EXTRACT(properties, '$.serviceArtifactReferenceId') as "service_artifact_reference_id",
JSON_EXTRACT(properties, '$.dscpConfigurationId') as "dscp_configuration_id",
JSON_EXTRACT(properties, '$.additionalNetworkInterfaceConfigurations') as "additional_network_interface_configurations",
JSON_EXTRACT(properties, '$.computerNamePrefix') as "computer_name_prefix",
JSON_EXTRACT(properties, '$.vmApplications') as "vm_applications",
subscriptionId,
resourceGroupName,
clusterName,
nodeTypeName
FROM azure.service_fabric_managed_clusters.node_types
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND clusterName = 'replace-me';