turbot/oci

steampipe plugin install ocisteampipe plugin install oci
On This Page
Get Involved

Table: oci_identity_network_source

A network source is a set of defined IP addresses. The IP addresses can be public IP addresses or IP addresses from VCNs within your tenancy. After you create the network source, you can reference it in policy or in your tenancy's authentication settings to control access based on the originating IP address.

Examples

Basic info

select
name,
id,
lifecycle_state,
time_created
from
oci_identity_network_source;

List inactive network sources

select
name,
id,
lifecycle_state
from
oci_identity_network_source
where
lifecycle_state = 'INACTIVE';

List network sources that include public IP addresses

select
name,
id,
public_source_list
from
oci_identity_network_source
where
jsonb_array_length(public_source_list) > 0;

Get allowed VCN OCIDs and IP range pairs for each network source

select
name,
id,
vsl ->> 'ipRanges' as ip_ranges,
vsl ->> 'vcnId' as vcn_id
from
oci_identity_network_source,
jsonb_array_elements(virtual_source_list) as vsl;

.inspect oci_identity_network_source

OCI Identity Network Source

NameTypeDescription
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.
descriptiontextThe description you assign to the network source.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the network source.
inactive_statusbigintThe detailed status of INACTIVE lifecycleState.
lifecycle_statetextThe network source object's current state.
nametextThe name you assign to the network source during creation.
public_source_listjsonbA list of allowed public IP addresses and CIDR ranges.
servicesjsonbA list of services allowed to make on-behalf-of requests.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneDate and time the etwork source was created.
titletextTitle of the resource.
virtual_source_listjsonbA list of allowed VCN OCID and IP range pairs.