Table: openstack_port

A port is a connection point for attaching a single device, such as the NIC of a server, to a network. The port also describes the associated network configuration, such as the MAC and IP addresses to be used on that port.

Examples

Basic port info

select
  name,
  description,
  status,
  id,
  mac_address,
  fixed_ips,
  project_id,
  device_owner,
  security_groups,
  created_at
from
  openstack_port;

Port by ID

select
  name,
  description,
  status,
  id,
  mac_address,
  fixed_ips,
  project_id,
  device_owner,
  security_groups,
  created_at
from
  openstack_port
where
  id = '07df44e6-b45b-49e8-b701-303a6f33615d';

Ports created in the last 30 days

select
  name,
  description,
  id,
  mac_address,
  fixed_ips,
  project_id,
  device_owner,
  security_groups,
  created_at
from
  openstack_port
where
  date_part(
    'day',
    current_date :: timestamp - created_at :: timestamp
  ) <= 30;

All active ports

select
  name,
  description,
  id,
  mac_address,
  fixed_ips,
  project_id,
  device_owner,
  security_groups,
  created_at
from
  openstack_port
where
  status = 'ACTIVE';

Schema for openstack_port

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
admin_state_up	boolean		Administrative state of port. If false (down), port does not forward packets.
allowed_address_pairs	jsonb		Identifies the list of IP addresses the port will recognize/accept.
created_at	timestamp with time zone		CreatedAt contains an ISO-8601 timestamp of when the port was created.
description	text		Describes the port.
device_id	text		Identifies the device (e.g., virtual server) using this port.
device_owner	text		Identifies the entity (e.g.: dhcp agent) using this port.
fixed_ips	jsonb		Specifies IP addresses for the port thus associating the port itself with the subnets where the IP addresses are picked from.
id	text	=	UUID for the port.
mac_address	text		Mac address to use on this port.
name	text		Human-readable name for the port. Might not be unique.
network_id	text		Network that this port is associated with.
project_id	text		ProjectID is the project owner of the port.
revision_number	bigint		RevisionNumber optionally set via extensions/standard-attr-revisions.
security_groups	jsonb		Specifies the IDs of any security groups associated with a port.
status	text		Indicates whether network is currently operational. Possible values include `ACTIVE', `DOWN', `BUILD', or `ERROR'. Plug-ins might define additional values.
tags	text		Tags optionally set via extensions/attributestags.
tenant_id	text		TenantID is the project owner of the port.
updated_at	timestamp with time zone		UpdatedAt contains an ISO-8601 timestamp of when the state of the port last changed.