Table: openstack_fip

A floating IP is an IP address in a public network that can be attached to an instance to make it publicly accessible. Only one floating IP address can be attached to an instance.

Examples

Basic floating IP info

select
  id,
  description,
  floating_ip,
  port_id,
  fixed_ip,
  updated_at,
  created_at,
  project_id,
  status,
  router_id
from
  openstack_fip;

Floating IP by ID

select
  id,
  description,
  floating_ip,
  port_id,
  fixed_ip,
  updated_at,
  created_at,
  project_id,
  status,
  router_id
from
  openstack_fip
where
  id = 'ccb677bb-d54f-4af9-8127-48ad87c76f74';

Floating IPs created in the last 30 days

select
  id,
  description,
  floating_ip,
  port_id,
  fixed_ip,
  updated_at,
  created_at,
  project_id,
  status,
  router_id
from
  openstack_fip
where
  date_part(
    'day',
    current_date :: timestamp - created_at :: timestamp
  ) <= 30;

Floating IPs updated in the last 90 days

select
  id,
  description,
  floating_ip,
  port_id,
  fixed_ip,
  updated_at,
  created_at,
  project_id,
  status,
  router_id
from
  openstack_fip
where
  date_part(
    'day',
    current_date :: timestamp - updated_at :: timestamp
  ) <= 90;

All active floating IPs

select
  id,
  description,
  floating_ip,
  port_id,
  fixed_ip,
  updated_at,
  created_at,
  project_id,
  status,
  router_id
from
  openstack_fip
where
  status = 'ACTIVE';

Schema for openstack_fip

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone		CreatedAt contains an ISO-8601 timestamp of when the floating ip was created.
description	text		Description for the floating IP instance.
fixed_ip	text		FixedIP is the specific IP address of the internal port which should be associated with the floating IP.
floating_ip	text		FloatingIP is the address of the floating IP on the external network.
floating_network_id	text		FloatingNetworkID is the UUID of the external network where the floating IP is to be created.
id	text	=	ID is the unique identifier for the floating IP instance.
port_id	text		PortID is the UUID of the port on an internal network that is associated with the floating IP.
project_id	text		ProjectID is the project owner of the floating IP.
router_id	text		RouterID is the ID of the router used for this floating IP.
status	text		Status is the condition of the API resource.
tags	text		Tags optionally set via extensions/attributestags.
tenant_id	text		TenantID is the project owner of the floating IP. Only admin users can specify a project identifier other than its own.
updated_at	timestamp with time zone		UpdatedAt contains an ISO-8601 timestamp of when the state of the floating ip last changed.