turbot/azure

steampipe plugin install azuresteampipe plugin install azure
On This Page
Get Involved

Table: azure_network_interface

A network interface enables an Azure Virtual Machine to communicate with internet, Azure, and on-premises resources.

Examples

Basic IP address info

select
name,
ip ->> 'name' as config_name,
ip -> 'properties' ->> 'privateIPAddress' as private_ip_address,
ip -> 'properties' ->> 'privateIPAddressVersion' as private_ip_address_version,
ip -> 'properties' ->> 'privateIPAllocationMethod' as private_ip_address_allocation_method
from
azure_network_interface
cross join jsonb_array_elements(ip_configurations) as ip;

Find all network interfaces with private IPs that are in a given subnet (10.66.0.0/16)

select
name,
ip ->> 'name' as config_name,
ip -> 'properties' ->> 'privateIPAddress' as private_ip_address
from
azure_network_interface
cross join jsonb_array_elements(ip_configurations) as ip
where
ip -> 'properties' ->> 'privateIPAddress' = '10.66.0.0/16';

Security groups attached to each network interface

select
name,
split_part(network_security_group_id, '/', 8) as security_groups
from
azure_network_interface;

.inspect azure_network_interface

Azure Network Interface

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
applied_dns_serversjsonbA list of applied dns servers
dns_serversjsonbA collection of DNS servers IP addresses
enable_accelerated_networkingbooleanIndicates whether the network interface is accelerated networking enabled
enable_ip_forwardingbooleanIndicates whether IP forwarding is enabled on this network interface
etagtextAn unique read-only string that changes whenever the resource is updated
hosted_workloadsjsonbA collection of references to linked BareMetal resources
idtextContains ID to identify a network interface uniquely
internal_dns_name_labeltextRelative DNS name for this NIC used for internal communications between VMs in the same virtual network
internal_domain_name_suffixtextContains domain name suffix for the network interface
internal_fqdntextFully qualified DNS name supporting internal communications between VMs in the same virtual network
ip_configurationsjsonbA list of IPConfigurations of the network interface
is_primarybooleanIndicates whether this is a primary network interface on a virtual machine
mac_addresstextThe MAC address of the network interface
nametextThe friendly name that identifies the network interface
network_security_group_idtextThe reference to the NetworkSecurityGroup resource
provisioning_statetextProvidsioning state of the network interface resource
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
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
tap_configurationsjsonbA collection of TapConfigurations of the network interface
titletextTitle of the resource.
typetextThe resource type of the network interface
virtual_machine_idtextThe reference to a virtual machine