oci360 3b.1.103. Security Lists - Ingress (OCI360_SECLISTS)


# DISPLAY_NAME VCN_NAME COMPARTMENT_NAME TIME_CREATED LIFECYCLE_STATE SOURCE SOURCE_TYPE PR SOURCE_PORT_RANGE_MIN SOURCE_PORT_RANGE_MAX DESTINATION_PORT_RANGE_MIN DESTINATION_PORT_RANGE_MAX ICMP 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 1         4 3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000652
2 Default Security List for vcn_test vcn_test Test 2020-04-18T22:34:41.379000+00:00 AVAILABLE 10.0.0.0/16 CIDR_BLOCK 1           3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000652
3 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 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000652
4 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 1         4 3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000656
5 Security List for Private Subnet-vcn_test vcn_test Test 2020-04-18T22:34:42.609000+00:00 AVAILABLE 10.0.0.0/16 CIDR_BLOCK 1           3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000656
6 Security List for Private Subnet-vcn_test vcn_test Test 2020-04-18T22:34:42.609000+00:00 AVAILABLE 10.0.0.0/16 CIDR_BLOCK 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000656
7 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 1         4 3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000647
8 Default Security List for vcn-20200428-1946 vcn-20200428-1946 compt_dev_app 2020-04-28T22:46:27.221000+00:00 AVAILABLE 10.0.0.0/16 CIDR_BLOCK 1           3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000647
9 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 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000647
10 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 1         4 3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000661
11 Default Security List for vcn_dev vcn_dev compt_ss_net 2020-04-24T20:22:04.149000+00:00 AVAILABLE 10.100.4.0/22 CIDR_BLOCK 1           3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000661
12 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 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000661
13 sl_subnet_dev_dmz vcn_dev compt_ss_net 2020-04-28T22:29:28.894000+00:00 AVAILABLE 179.218.X.X/32 CIDR_BLOCK 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000655
14 sl_subnet_dev_dmz vcn_dev compt_ss_net 2020-04-28T22:29:28.894000+00:00 AVAILABLE 179.218.X.X/32 CIDR_BLOCK 6     80 80     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000655
15 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 1         4 3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000653
16 Default Security List for vcn_hml vcn_hml compt_ss_net 2020-04-24T20:22:43.254000+00:00 AVAILABLE 10.100.12.0/22 CIDR_BLOCK 1           3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000653
17 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 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000653
18 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 1         4 3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000654
19 Default Security List for vcn_hub vcn_hub compt_ss_net 2020-04-24T20:21:45.910000+00:00 AVAILABLE 10.100.0.0/22 CIDR_BLOCK 1           3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000654
20 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 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000654
21 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
22 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 17     1194 1194     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000648
23 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 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000648
24 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 6     443 443     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000648
25 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 6     943 943     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000648
26 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 1         4 3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000651
27 Default Security List for vcn_prd vcn_prd compt_ss_net 2020-04-24T20:22:24.296000+00:00 AVAILABLE 10.100.8.0/22 CIDR_BLOCK 1           3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000651
28 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 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000651
29 sl_subnet_prd_app vcn_prd compt_ss_net 2020-04-24T22:09:41.874000+00:00 AVAILABLE 0.0.0.0/0 CIDR_BLOCK 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000658
30 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 6     22 22     false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000660
31 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 1         4 3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000649
32 Default Security List for vcn_ss vcn_ss compt_ss_net 2020-04-24T20:24:12.262000+00:00 AVAILABLE 10.100.16.0/22 CIDR_BLOCK 1           3 false ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000649
33 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 6     22 22     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."INGRESS_SECURITY_RULES$SOURCE"                                  SOURCE,
       ts."INGRESS_SECURITY_RULES$SOURCE_TYPE"                             SOURCE_TYPE,
       ts."INGRESS_SECURITY_RULES$PROTOCOL"                                PROTOCOL,
       ts."INGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MIN"       SOURCE_PORT_RANGE_MIN,
       ts."INGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MAX"       SOURCE_PORT_RANGE_MAX,
       ts."INGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MIN"  DESTINATION_PORT_RANGE_MIN,
       ts."INGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MAX"  DESTINATION_PORT_RANGE_MAX,
       ts."INGRESS_SECURITY_RULES$ICMP_OPTIONS$CODE"                       ICMP_CODE,
       ts."INGRESS_SECURITY_RULES$ICMP_OPTIONS$TYPE"                       ICMP_TYPE,
       ts."INGRESS_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."INGRESS_SECURITY_RULES$SOURCE_TYPE" is not null
AND    ts."INGRESS_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."INGRESS_SECURITY_RULES$SOURCE"                                  SOURCE,
       ts."INGRESS_SECURITY_RULES$SOURCE_TYPE"                             SOURCE_TYPE,
       ts."INGRESS_SECURITY_RULES$PROTOCOL"                                PROTOCOL,
       ts."INGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MIN"       SOURCE_PORT_RANGE_MIN,
       ts."INGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MAX"       SOURCE_PORT_RANGE_MAX,
       ts."INGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MIN"  DESTINATION_PORT_RANGE_MIN,
       ts."INGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MAX"  DESTINATION_PORT_RANGE_MAX,
       ts."INGRESS_SECURITY_RULES$ICMP_OPTIONS$CODE"                       ICMP_CODE,
       ts."INGRESS_SECURITY_RULES$ICMP_OPTIONS$TYPE"                       ICMP_TYPE,
       ts."INGRESS_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."INGRESS_SECURITY_RULES$SOURCE_TYPE" is not null
AND    ts."INGRESS_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;


33 rows selected.

oci360 (c) 2020, All rights reserved. oci360 v20.06 (2020-06-25) based on moat369 v2002 (2020-02-27). Timestamp: 2020-06-30T15:55:37