interface_details

Detailed information and stats of network interfaces.

Table schema

Name Type Description
interface TEXT Interface name
mac TEXT MAC of interface (optional)
type INTEGER Interface type (includes virtual)
mtu INTEGER Network MTU
metric INTEGER Metric based on the speed of the interface
flags INTEGER Flags (netdevice) for the device
ipackets BIGINT Input packets
opackets BIGINT Output packets
ibytes BIGINT Input bytes
obytes BIGINT Output bytes
ierrors BIGINT Input errors
oerrors BIGINT Output errors
idrops BIGINT Input drops
odrops BIGINT Output drops
collisions BIGINT Packet Collisions detected
last_change BIGINT Time of last device modification (optional)
friendly_name TEXT The friendly display name of the interface.
description TEXT Short description of the object—a one-line string.
manufacturer TEXT Name of the network adapter’s manufacturer.
connection_id TEXT Name of the network connection as it appears in the Network Connections Control Panel program.
connection_status TEXT State of the network adapter connection to the network.
enabled INTEGER Indicates whether the adapter is enabled or not.
physical_adapter INTEGER Indicates whether the adapter is a physical or a logical adapter.
speed INTEGER Estimate of the current bandwidth in bits per second.
dhcp_enabled INTEGER If TRUE, the dynamic host configuration protocol (DHCP) server automatically assigns an IP address to the computer system when establishing a network connection.
dhcp_lease_expires TEXT Expiration date and time for a leased IP address that was assigned to the computer by the dynamic host configuration protocol (DHCP) server.
dhcp_lease_obtained TEXT Date and time the lease was obtained for the IP address assigned to the computer by the dynamic host configuration protocol (DHCP) server.
dhcp_server TEXT IP address of the dynamic host configuration protocol (DHCP) server.
dns_domain TEXT Organization name followed by a period and an extension that indicates the type of organization, such as ‘microsoft.com’.
dns_domain_suffix_search_order TEXT Array of DNS domain suffixes to be appended to the end of host names during name resolution.
dns_host_name TEXT Host name used to identify the local computer for authentication by some utilities.
dns_server_search_order TEXT Array of server IP addresses to be used in querying for DNS servers.

Query examples

select interface, mac, type, idrops as input_drops from interface_details;
select interface, mac, type, flags, (1<<8) as promisc_flag from interface_details where (flags & promisc_flag) > 0;
select interface, mac, type, flags, (1<<3) as loopback_flag from interface_details where (flags & loopback_flag) > 0;