steampipe plugin install oci

Table: oci_core_internet_gateway - Query OCI Core Internet Gateways using SQL

An OCI Core Internet Gateway is a virtual router that provides a path for traffic between your VCN and the internet. As a stateless gateway, it does not maintain information about the traffic that flows through it. It also does not perform Network Address Translation (NAT) or route table lookups.

Table Usage Guide

The oci_core_internet_gateway table provides insights into the Internet Gateways within Oracle Cloud Infrastructure (OCI). As a network engineer, explore gateway-specific details through this table, including its lifecycle state, availability domain, and associated metadata. Utilize it to uncover information about gateways, such as their attached VCNs, the time they were created, and whether they are enabled for internet traffic.

Examples

Basic info

Gain insights into the creation and lifecycle status of your internet gateway resources in Oracle Cloud Infrastructure. This is useful for managing and monitoring the state and duration of these resources in your network.

select
display_name,
id,
time_created,
lifecycle_state as state
from
oci_core_internet_gateway;
select
display_name,
id,
time_created,
lifecycle_state as state
from
oci_core_internet_gateway;

List disabled internet gateways

Identify instances where internet gateways are disabled to understand potential gaps in your network infrastructure. This can help in improving the security and reliability of your systems.

select
display_name,
id,
time_created,
is_enabled
from
oci_core_internet_gateway
where
not is_enabled;
select
display_name,
id,
time_created,
is_enabled
from
oci_core_internet_gateway
where
not is_enabled;

Schema for oci_core_internet_gateway

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
compartment_idtext=The OCID of the compartment in Tenant in which the resource is located.
defined_tagsjsonbDefined 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.
display_nametext=A user-friendly name.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtext=The internet gateway's Oracle ID (OCID).
is_enabledbooleanWhether the gateway is enabled.
lifecycle_statetext=The internet gateway's current state.
regiontextThe OCI region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The OCID of the Tenant in which the resource is located.
tenant_nametextThe name of the Tenant in which the resource is located.
time_createdtimestamp with time zoneThe date and time the internet gateway was created.
titletextTitle of the resource.
vcn_idtext=The OCID of the VCN the internet gateway belongs to.

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_internet_gateway