3a.1.100. Public IPs (OCI360_PUBLICIPS) 3a.1.100. Public IPs (OCI360_PUBLICIPS)
| # | ID | SCOPE | LIFETIME | IP_ADDRESS | DEFINED_TAGS$ORACLE_TAGS$CREATEDBY | DEFINED_TAGS$ORACLE_TAGS$CREATED | DISPLAY_NAME | TIME_CREATED | FREEFORM_TAGS$VCN | PRIVATE_IP_ID | COMPARTMENT_ID | LIFECYCL | ASSIGNED_ENTITY_ID | AVAILABILITY_DOMAIN | ASSIGNED_ENTITY_ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.publicip.oc1.iad.000000000000000000000000000000000000000000000000000000000621 | REGION | EPHEMERAL | 150.136.X.X | oracleidentitycloudservice/[email protected] | 2020-04-28T22:27:43.262Z | IP for NAT gateway: ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000588 | 2020-04-28T22:27:43.284000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ASSIGNED | ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000588 | NAT_GATEWAY | |||
| 2 | ocid1.publicip.oc1.iad.000000000000000000000000000000000000000000000000000000000622 | REGION | EPHEMERAL | 150.136.X.X | oracleidentitycloudservice/[email protected] | 2020-04-28T22:28:11.830Z | IP for NAT gateway: ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000587 | 2020-04-28T22:28:11.859000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ASSIGNED | ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000587 | NAT_GATEWAY | |||
| 3 | ocid1.publicip.oc1.iad.000000000000000000000000000000000000000000000000000000000623 | REGION | EPHEMERAL | 150.136.X.X | oracleidentitycloudservice/[email protected] | 2020-04-24T22:06:37.386Z | IP for NAT gateway: ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000586 | 2020-04-24T22:06:37.410000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ASSIGNED | ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000586 | NAT_GATEWAY | |||
| 4 | ocid1.publicip.oc1.iad.000000000000000000000000000000000000000000000000000000000620 | REGION | EPHEMERAL | 150.136.X.X | oracleidentitycloudservice/[email protected] | 2020-04-18T22:34:43.521Z | IP for NAT gateway: ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000585 | 2020-04-18T22:34:43.548000+00:00 | VCN-2020-04-18T22:34:13 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000227 | ASSIGNED | ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000585 | NAT_GATEWAY | ||
| 5 | ocid1.publicip.oc1.iad.000000000000000000000000000000000000000000000000000000000624 | AVAILABILITY_DOMAIN | EPHEMERAL | 150.136.X.X | oracleidentitycloudservice/[email protected] | 2020-05-20T14:54:00.704Z | publicip20200520145411 | 2020-05-20T14:54:11.682000+00:00 | ocid1.privateip.oc1.iad.000000000000000000000000000000000000000000000000000000000596 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | ASSIGNED | ocid1.privateip.oc1.iad.000000000000000000000000000000000000000000000000000000000596 | CYtq:US-ASHBURN-AD-3 | PRIVATE_IP |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
SCOPE VARCHAR2(32)
LIFETIME VARCHAR2(16)
IP_ADDRESS VARCHAR2(16)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(128)
TIME_CREATED VARCHAR2(32)
FREEFORM_TAGS$VCN VARCHAR2(32)
PRIVATE_IP_ID VARCHAR2(128)
COMPARTMENT_ID VARCHAR2(128)
LIFECYCLE_STATE VARCHAR2(8)
ASSIGNED_ENTITY_ID VARCHAR2(128)
AVAILABILITY_DOMAIN VARCHAR2(32)
ASSIGNED_ENTITY_TYPE VARCHAR2(16)
SELECT t1.*
FROM OCI360_PUBLICIPS t1
WHERE substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';
5 rows selected.