3a.1.84. VNIC Attachments (OCI360_VNIC_ATTACHS) 3a.1.84. VNIC Attachments (OCI360_VNIC_ATTACHS)
| # | ID | VNIC_ID | VLAN_TAG | NIC_INDEX | SUBNET_ID | INSTANCE_ID | DISP | TIME_CREATED | COMPARTMENT_ID | LIFECYCL | AVAILABILITY_DOMAIN |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.vnicattachment.oc1.iad.000000000000000000000000000000000000000000000000000000000707 | ocid1.vnic.oc1.iad.000000000000000000000000000000000000000000000000000000000706 | 171 | 0 | ocid1.subnet.oc1.iad.000000000000000000000000000000000000000000000000000000000675 | ocid1.instance.oc1.iad.000000000000000000000000000000000000000000000000000000000575 | 2020-05-20T14:54:11.809000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | ATTACHED | CYtq:US-ASHBURN-AD-3 |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
VNIC_ID VARCHAR2(128)
VLAN_TAG NUMBER
NIC_INDEX NUMBER
SUBNET_ID VARCHAR2(128)
INSTANCE_ID VARCHAR2(128)
DISPLAY_NAME VARCHAR2(4)
TIME_CREATED VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
LIFECYCLE_STATE VARCHAR2(8)
AVAILABILITY_DOMAIN VARCHAR2(32)
SELECT t1.*
FROM OCI360_VNIC_ATTACHS t1
WHERE substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';
1 rows selected.