steampipe plugin install ocisteampipe plugin install oci

Table: oci_core_local_peering_gateway - Query OCI Core Local Peering Gateways using SQL

A Local Peering Gateway (LPG) in Oracle Cloud Infrastructure (OCI) is a regional object that represents a local VCN peering relationship. It allows the peering of VCNs in the same region, enabling the VCNs to function as a single, unified network without routing traffic over the internet or through a router. The LPG is a key component of the VCN peering architecture within OCI, facilitating the exchange of private network traffic between VCNs.

Table Usage Guide

The oci_core_local_peering_gateway table provides insights into Local Peering Gateways within Oracle Cloud Infrastructure's Core Services. As a network administrator, explore gateway-specific details through this table, including associated VCNs, lifecycle states, and associated metadata. Utilize it to uncover information about peering gateways, such as those associated with specific VCNs, the lifecycle state of each gateway, and the verification of peering relationships.

Examples

Basic info

Explore the status of local peering gateways within your Oracle Cloud Infrastructure network to manage and optimize connections between virtual cloud networks. This is vital for ensuring smooth data transfer and maintaining network performance.

select
  name,
  id,
  vcn_id,
  lifecycle_state
from
  oci_core_local_peering_gateway;

select
  name,
  id,
  vcn_id,
  lifecycle_state
from
  oci_core_local_peering_gateway;

List available LPGs

Discover the segments that have local peering gateways in an available state, enabling you to manage and optimize network connectivity within your virtual cloud network.

select
  name,
  id,
  vcn_id,
  lifecycle_state
from
  oci_core_local_peering_gateway
where
  lifecycle_state = 'AVAILABLE';

select
  name,
  id,
  vcn_id,
  lifecycle_state
from
  oci_core_local_peering_gateway
where
  lifecycle_state = 'AVAILABLE';

List LPGs which are not connected to any peer

Explore which Local Peering Gateways (LPGs) are not connected to any peer. This can help in identifying isolated network segments, which could be a potential security risk or a misconfiguration.

select
  name,
  id,
  vcn_id,
  lifecycle_state
from
  oci_core_local_peering_gateway
where
  peering_status = 'NEW';

select
  name,
  id,
  vcn_id,
  lifecycle_state
from
  oci_core_local_peering_gateway
where
  peering_status = 'NEW';

Query examples

Schema for oci_core_local_peering_gateway

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
compartment_id	text	=	The OCID of the compartment in Tenant in which the resource is located.
defined_tags	jsonb		Defined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources.
freeform_tags	jsonb		Free-form tags for resource. This tags can be applied by any user with permissions on the resource.
id	text	=	The LPG's Oracle ID
is_cross_tenancy_peering	boolean		Whether the VCN at the other end of the peering is in a different tenancy.
lifecycle_state	text		The LPG's current lifecycle state.
name	text		A user-friendly name. Does not have to be unique, and it's changeable.
peer_advertised_cidr	cidr		The smallest aggregate CIDR that contains all the CIDR routes advertised by the VCN at the other end of the peering from this LPG.
peer_advertised_cidr_details	jsonb		The specific ranges of IP addresses available on or via the VCN at the other end of the peering from this LPG.
peering_status	text		Whether the LPG is peered with another LPG.
peering_status_details	text		Additional information regarding the peering status.
region	text		The OCI region in which the resource is located.
route_table_id	text		The OCID of the route table the LPG is using.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
tenant_id	text	=, !=, ~~, ~~, !~~, !~~	The OCID of the Tenant in which the resource is located.
tenant_name	text		The name of the Tenant in which the resource is located.
time_created	timestamp with time zone		The date and time the LPG was created.
title	text		Title of the resource.
vcn_id	text	=	The OCID of the VCN that uses the LPG.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- oci

You can pass the configuration to the command with the --config argument:

steampipe_export_oci --config '<your_config>' oci_core_local_peering_gateway