steampipe plugin install azure

Table: azure_compute_virtual_machine_scale_set_network_interface - Query Azure Compute Virtual Machine Scale Sets Network Interfaces using SQL

A Network Interface within Azure Compute Virtual Machine Scale Sets is a virtual network interface card (NIC) attached to a Virtual Machine Scale Set in Azure. It provides the interconnection between a Virtual Machine Scale Set and the underlying Azure virtual network. Each Network Interface can have one or more IP configurations associated with it.

Table Usage Guide

The azure_compute_virtual_machine_scale_set_network_interface table provides insights into the network interfaces associated with Azure Compute Virtual Machine Scale Sets. As a network administrator, you can use this table to explore details about each network interface, including its IP configurations, subnet information, and associated scale set. This can be particularly useful for managing network connectivity and troubleshooting network-related issues within your Azure Compute Virtual Machine Scale Sets.

Examples

Basic info

Explore the status and location of your Azure virtual machine scale sets to gain insights into their deployment and management. This is useful for assessing the distribution and provisioning of your resources across different regions and groups.

select
name,
id,
scale_set_name,
provisioning_state,
region,
resource_group
from
azure_compute_virtual_machine_scale_set_network_interface;
select
name,
id,
scale_set_name,
provisioning_state,
region,
resource_group
from
azure_compute_virtual_machine_scale_set_network_interface;

List network interfaces with IP forwarding rule enabled

Determine the areas in which IP forwarding is enabled on network interfaces for better control and management of network traffic. This is particularly useful in scenarios where data packets need to be redirected or rerouted for specific purposes.

select
name,
id,
enable_ip_forwarding,
scale_set_name
from
azure_compute_virtual_machine_scale_set_network_interface
where
enable_ip_forwarding;
select
name,
id,
enable_ip_forwarding,
scale_set_name
from
azure_compute_virtual_machine_scale_set_network_interface
where
enable_ip_forwarding = 1;

List network interfaces with accelerated networking enabled

Explore which network interfaces are utilizing accelerated networking within your Azure virtual machine scale sets. This information can be useful for optimizing network performance and troubleshooting connectivity issues.

select
name,
id,
enable_accelerated_networking,
scale_set_name
from
azure_compute_virtual_machine_scale_set_network_interface
where
enable_accelerated_networking;
select
name,
id,
enable_accelerated_networking,
scale_set_name
from
azure_compute_virtual_machine_scale_set_network_interface
where
enable_accelerated_networking = 1;

Get scale set virtual machine details for scale set network interface

This query helps to map network interfaces to their corresponding virtual machines within a specified scale set. It's particularly useful for managing and monitoring network traffic and performance across multiple instances within a scale set.

select
i.name as name,
i.id as id,
v.instance_id as instance_id,
v.scale_set_name as scale_set_name,
v.sku_name as vm_sku_name
from
azure_compute_virtual_machine_scale_set_network_interface as i,
azure_compute_virtual_machine_scale_set_vm as v
where
i.virtual_machine ->> 'id' = v.id;
select
i.name as name,
i.id as id,
v.instance_id as instance_id,
v.scale_set_name as scale_set_name,
v.sku_name as vm_sku_name
from
azure_compute_virtual_machine_scale_set_network_interface as i,
azure_compute_virtual_machine_scale_set_vm as v
where
json_extract(i.virtual_machine, '$.id') = v.id;

Schema for azure_compute_virtual_machine_scale_set_network_interface

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
dns_settingsjsonbThe DNS settings in network interface.
enable_accelerated_networkingbooleanIf the network interface has accelerated networking enabled.
enable_ip_forwardingbooleanIndicates whether IP forwarding is enabled on this network interface.
hosted_workloadsjsonbA list of references to linked BareMetal resources.
idtextThe unique ID identifying the resource in a subscription.
ip_configurationsjsonbA list of IP configurations of the network interface.
mac_addresstextThe MAC address of the network interface.
nametextName of the scale set network interface.
network_security_groupjsonbThe reference to the NetworkSecurityGroup resource.
primarybooleanWhether this is a primary network interface on a virtual machine.
private_endpointjsonbA reference to the private endpoint to which the network interface is linked.
provisioning_statetextThe provisioning state of the network interface resource. Possible values include: 'Succeeded', 'Updating', 'Deleting', 'Failed'.
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
resource_guidtextThe resource GUID property of the network interface resource.
scale_set_nametextName of the scale set.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe type of the resource in Azure.
virtual_machinejsonbThe reference to a virtual machine.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_compute_virtual_machine_scale_set_network_interface