Skip to main content

vw_interfaces_virtual_machine_scale_set_network_interfaces

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

Overview​

Namevw_interfaces_virtual_machine_scale_set_network_interfaces
TypeView
Idazure.network.vw_interfaces_virtual_machine_scale_set_network_interfaces

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
extendedLocation as extended_location,
etag as etag,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.virtualMachine') as "virtual_machine",
JSON_EXTRACT(properties, '$.networkSecurityGroup') as "network_security_group",
JSON_EXTRACT(properties, '$.privateEndpoint') as "private_endpoint",
JSON_EXTRACT(properties, '$.ipConfigurations') as "ip_configurations",
JSON_EXTRACT(properties, '$.tapConfigurations') as "tap_configurations",
JSON_EXTRACT(properties, '$.dnsSettings') as "dns_settings",
JSON_EXTRACT(properties, '$.macAddress') as "mac_address",
JSON_EXTRACT(properties, '$.primary') as "primary",
JSON_EXTRACT(properties, '$.vnetEncryptionSupported') as "vnet_encryption_supported",
JSON_EXTRACT(properties, '$.enableAcceleratedNetworking') as "enable_accelerated_networking",
JSON_EXTRACT(properties, '$.disableTcpStateTracking') as "disable_tcp_state_tracking",
JSON_EXTRACT(properties, '$.enableIPForwarding') as "enable_ip_forwarding",
JSON_EXTRACT(properties, '$.hostedWorkloads') as "hosted_workloads",
JSON_EXTRACT(properties, '$.dscpConfiguration') as "dscp_configuration",
JSON_EXTRACT(properties, '$.resourceGuid') as "resource_guid",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.workloadType') as "workload_type",
JSON_EXTRACT(properties, '$.nicType') as "nic_type",
JSON_EXTRACT(properties, '$.privateLinkService') as "private_link_service",
JSON_EXTRACT(properties, '$.migrationPhase') as "migration_phase",
JSON_EXTRACT(properties, '$.auxiliaryMode') as "auxiliary_mode",
JSON_EXTRACT(properties, '$.auxiliarySku') as "auxiliary_sku",
subscriptionId,
resourceGroupName,
virtualMachineScaleSetName,
virtualmachineIndex,
networkInterfaceName
FROM azure.network.interfaces_virtual_machine_scale_set_network_interfaces
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND virtualMachineScaleSetName = 'replace-me';