3b.1.104. Security Lists - Egress (OCI360_SECLISTS) 3b.1.104. Security Lists - Egress (OCI360_SECLISTS)
| # | DISPLAY_NAME | VCN_NAME | COMPARTMENT_NAME | TIME_CREATED | LIFECYCLE_STATE | DESTINATION | DESTINATION_TYPE | PROT | SOURCE_PORT_RANGE_MIN | SOURCE_PORT_RANGE_MAX | DESTINATION_PORT_RANGE_MIN | DESTINATION_PORT_RANGE_MAX | I | ICMP_TYPE | IS_STATE | ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Default Security List for vcn_test | vcn_test | Test | 2020-04-18T22:34:41.379000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | all | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000652 | ||||||
| 2 | Security List for Private Subnet-vcn_test | vcn_test | Test | 2020-04-18T22:34:42.609000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | all | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000656 | ||||||
| 3 | Default Security List for vcn-20200428-1946 | vcn-20200428-1946 | compt_dev_app | 2020-04-28T22:46:27.221000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | all | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000647 | ||||||
| 4 | Default Security List for vcn_dev | vcn_dev | compt_ss_net | 2020-04-24T20:22:04.149000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | all | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000661 | ||||||
| 5 | sl_subnet_dev_dmz | vcn_dev | compt_ss_net | 2020-04-28T22:29:28.894000+00:00 | AVAILABLE | all-iad-services-in-oracle-services-network | SERVICE_CIDR_BLOCK | 6 | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000655 | ||||||
| 6 | sl_subnet_dev_dmz | vcn_dev | compt_ss_net | 2020-04-28T22:29:28.894000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | 6 | 80 | 80 | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000655 | ||||
| 7 | sl_subnet_dev_dmz | vcn_dev | compt_ss_net | 2020-04-28T22:29:28.894000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | 6 | 22 | 22 | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000655 | ||||
| 8 | sl_subnet_dev_dmz | vcn_dev | compt_ss_net | 2020-04-28T22:29:28.894000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | 6 | 443 | 443 | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000655 | ||||
| 9 | Default Security List for vcn_hml | vcn_hml | compt_ss_net | 2020-04-24T20:22:43.254000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | all | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000653 | ||||||
| 10 | Default Security List for vcn_hub | vcn_hub | compt_ss_net | 2020-04-24T20:21:45.910000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | all | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000654 | ||||||
| 11 | sl_subnet_hub_dmz | vcn_hub | compt_ss_net | 2020-04-24T20:28:30.218000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | 1 | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000648 | ||||||
| 12 | sl_subnet_hub_dmz | vcn_hub | compt_ss_net | 2020-04-24T20:28:30.218000+00:00 | AVAILABLE | 10.100.8.0/24 | CIDR_BLOCK | 6 | 22 | 22 | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000648 | ||||
| 13 | Default Security List for vcn_prd | vcn_prd | compt_ss_net | 2020-04-24T20:22:24.296000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | all | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000651 | ||||||
| 14 | sl_subnet_prd_dmz | vcn_prd | compt_ss_net | 2020-04-24T22:10:07.804000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | all | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000660 | ||||||
| 15 | Default Security List for vcn_ss | vcn_ss | compt_ss_net | 2020-04-24T20:24:12.262000+00:00 | AVAILABLE | 0.0.0.0/0 | CIDR_BLOCK | all | false | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000649 |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
VCN_ID VARCHAR2(128)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(64)
TIME_CREATED VARCHAR2(32)
FREEFORM_TAGS$VCN VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
LIFECYCLE_STATE VARCHAR2(16)
EGRESS_SECURITY_RULES$PROTOCOL VARCHAR2(4)
EGRESS_SECURITY_RULES$DESCRIPTION VARCHAR2(32)
EGRESS_SECURITY_RULES$DESTINATION VARCHAR2(64)
EGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MAX NUMBER
EGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MIN NUMBER
EGRESS_SECURITY_RULES$IS_STATELESS VARCHAR2(8)
EGRESS_SECURITY_RULES$DESTINATION_TYPE VARCHAR2(32)
INGRESS_SECURITY_RULES$SOURCE VARCHAR2(16)
INGRESS_SECURITY_RULES$PROTOCOL VARCHAR2(2)
INGRESS_SECURITY_RULES$DESCRIPTION VARCHAR2(8)
INGRESS_SECURITY_RULES$SOURCE_TYPE VARCHAR2(16)
INGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MAX NUMBER
INGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MIN NUMBER
INGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MAX NUMBER
INGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MIN NUMBER
INGRESS_SECURITY_RULES$ICMP_OPTIONS$CODE VARCHAR2(4)
INGRESS_SECURITY_RULES$ICMP_OPTIONS$TYPE NUMBER
INGRESS_SECURITY_RULES$IS_STATELESS VARCHAR2(8)
EGRESS_SECURITY_RULES$ICMP_OPTIONS$CODE VARCHAR2(1)
EGRESS_SECURITY_RULES$ICMP_OPTIONS$TYPE NUMBER(1)
EGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MAX NUMBER(1)
EGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MIN NUMBER(1)
EGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MAX NUMBER(1)
EGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MIN NUMBER(1)
EGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MAX NUMBER(1)
EGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MIN NUMBER(1)
INGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MAX NUMBER(1)
INGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MIN NUMBER(1)
INGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MAX NUMBER(1)
INGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MIN NUMBER(1)
SELECT ts.DISPLAY_NAME,
tvcn.DISPLAY_NAME VCN_NAME,
tcomp.NAME COMPARTMENT_NAME,
ts.TIME_CREATED,
ts.LIFECYCLE_STATE,
ts."EGRESS_SECURITY_RULES$DESTINATION" DESTINATION,
ts."EGRESS_SECURITY_RULES$DESTINATION_TYPE" DESTINATION_TYPE,
ts."EGRESS_SECURITY_RULES$PROTOCOL" PROTOCOL,
ts."EGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MIN" SOURCE_PORT_RANGE_MIN,
ts."EGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MAX" SOURCE_PORT_RANGE_MAX,
ts."EGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MIN" DESTINATION_PORT_RANGE_MIN,
ts."EGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MAX" DESTINATION_PORT_RANGE_MAX,
ts."EGRESS_SECURITY_RULES$ICMP_OPTIONS$CODE" ICMP_CODE,
ts."EGRESS_SECURITY_RULES$ICMP_OPTIONS$TYPE" ICMP_TYPE,
ts."EGRESS_SECURITY_RULES$IS_STATELESS" IS_STATELESS,
ts.ID
FROM OCI360_SECLISTS ts,
OCI360_VCNS tvcn,
OCI360_COMPARTMENTS tcomp
WHERE ts.COMPARTMENT_ID = tcomp.ID
AND ts.VCN_ID = tvcn.ID
AND ts."EGRESS_SECURITY_RULES$DESTINATION_TYPE" is not null
AND ts."EGRESS_SECURITY_RULES$PROTOCOL"!='17'
AND substr(ts.id,instr(ts.id,'.',1,3)+1,instr(ts.id,'.',1,4)-instr(ts.id,'.',1,3)-1) = 'iad'
UNION ALL
SELECT ts.DISPLAY_NAME,
tvcn.DISPLAY_NAME VCN_NAME,
tcomp.NAME COMPARTMENT_NAME,
ts.TIME_CREATED,
ts.LIFECYCLE_STATE,
ts."EGRESS_SECURITY_RULES$DESTINATION" DESTINATION,
ts."EGRESS_SECURITY_RULES$DESTINATION_TYPE" DESTINATION_TYPE,
ts."EGRESS_SECURITY_RULES$PROTOCOL" PROTOCOL,
ts."EGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MIN" SOURCE_PORT_RANGE_MIN,
ts."EGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MAX" SOURCE_PORT_RANGE_MAX,
ts."EGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MIN" DESTINATION_PORT_RANGE_MIN,
ts."EGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MAX" DESTINATION_PORT_RANGE_MAX,
ts."EGRESS_SECURITY_RULES$ICMP_OPTIONS$CODE" ICMP_CODE,
ts."EGRESS_SECURITY_RULES$ICMP_OPTIONS$TYPE" ICMP_TYPE,
ts."EGRESS_SECURITY_RULES$IS_STATELESS" IS_STATELESS,
ts.ID
FROM OCI360_SECLISTS ts,
OCI360_VCNS tvcn,
OCI360_COMPARTMENTS tcomp
WHERE ts.COMPARTMENT_ID = tcomp.ID
AND ts.VCN_ID = tvcn.ID
AND ts."EGRESS_SECURITY_RULES$DESTINATION_TYPE" is not null
AND ts."EGRESS_SECURITY_RULES$PROTOCOL"='17'
AND substr(ts.id,instr(ts.id,'.',1,3)+1,instr(ts.id,'.',1,4)-instr(ts.id,'.',1,3)-1) = 'iad'
ORDER BY COMPARTMENT_NAME,VCN_NAME,DISPLAY_NAME,LIFECYCLE_STATE,PROTOCOL;
15 rows selected.