Table: openstack_network

A network contains one or more subnets.

Examples

Basic network info

select
  name,
  description,
  status,
  subnets,
  created_at,
  updated_at,
  project_id,
  shared
from
  openstack_network;

Network by ID

select
  name,
  description,
  status,
  subnets,
  created_at,
  updated_at,
  project_id,
  shared
from
  openstack_network
where
  id = '4d33bcfe-215d-44e9-8986-93033a20789f';

All active networks

select
  name,
  description,
  subnets,
  created_at,
  updated_at,
  project_id,
  shared
from
  openstack_network
where
  status = 'ACTIVE';

All shared networks

select
  name,
  description,
  status,
  subnets,
  created_at,
  updated_at,
  project_id,
  shared
from
  openstack_network
where
  shared = true;

All networks created in the last 30 days

select
  name,
  description,
  status,
  subnets,
  created_at,
  updated_at,
  project_id,
  shared
from
  openstack_network
where
  date_part(
    'day',
    current_date :: timestamp - created_at :: timestamp
  ) <= 30;

All networks updated in the last 90 days

select
  name,
  description,
  status,
  subnets,
  created_at,
  updated_at,
  project_id,
  shared
from
  openstack_network
where
  date_part(
    'day',
    current_date :: timestamp - updated_at :: timestamp
  ) <= 90;

Schema for openstack_network

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
admin_state_up	boolean		The administrative state of network. If false (down), the network does not forward packets.
availability_zone_hints	text		Availability zone hints groups network nodes that run services like DHCP, L3, FW, and others. Used to make network resources highly available.
created_at	timestamp with time zone		CreatedAt contains an ISO-8601 timestamp of when the network was created.
description	text		Description for the network.
id	text	=	UUID for the network.
name	text		Human-readable name for the network. Might not be unique.
project_id	text		ProjectID is the project owner of the network.
revision_number	bigint		RevisionNumber optionally set via extensions/standard-attr-revisions.
shared	boolean		Specifies whether the network resource can be accessed by any tenant.
status	text		Indicates whether network is currently operational. Possible values include `ACTIVE', `DOWN', `BUILD', or `ERROR'. Plug-ins might define additional values.
subnets	jsonb		Subnets associated with this network.
tags	jsonb		Tags optionally set via extensions/attributestags.
tenant_id	text		TenantID is the project owner of the network.
updated_at	timestamp with time zone		UpdatedAt contains an ISO-8601 timestamp of when the state of the network last changed.