2a.35. Volume Attachments (OCI360_VOL_ATTACHS) 2a.35. Volume Attachments (OCI360_VOL_ATTACHS)
| # | ID | IQN | IPV4 | PORT | DEVICE | VOLUME_ID | CHAP | INSTANCE_ID | DISPLAY_NAME | IS_READ_ | IS_SHARE | TIME_CREATED | CHAP | COMPARTMENT_ID | ATTACHME | LIFECYCL | AVAILABILITY_DOMAIN | IS_PV_EN |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.volumeattachment.oc1.iad.000000000000000000000000000000000000000000000000000000000715 | iqn.2015-12.com.oracleiaas:ebb203f9-f6da-4179-8822-7d2298845377 | 169.254.2.4 | 3260 | /dev/oracleoci/oraclevdc | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000710 | ocid1.instance.oc1.iad.000000000000000000000000000000000000000000000000000000000575 | volumeattachment20200626193103 | false | false | 2020-06-26T19:31:03.658000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | iscsi | ATTACHED | CYtq:US-ASHBURN-AD-3 | false | ||
| 2 | ocid1.volumeattachment.oc1.iad.000000000000000000000000000000000000000000000000000000000713 | iqn.2015-12.com.oracleiaas:483609e2-ba21-40f7-af4e-4165829dddc1 | 169.254.2.2 | 3260 | /dev/oracleoci/oraclevdb | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000712 | ocid1.instance.oc1.iad.000000000000000000000000000000000000000000000000000000000575 | volumeattachment20200520150630 | false | false | 2020-05-20T15:06:31.142000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | iscsi | ATTACHED | CYtq:US-ASHBURN-AD-3 | false |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
IQN VARCHAR2(64)
IPV4 VARCHAR2(16)
PORT NUMBER
DEVICE VARCHAR2(32)
VOLUME_ID VARCHAR2(128)
CHAP_SECRET VARCHAR2(4)
INSTANCE_ID VARCHAR2(128)
DISPLAY_NAME VARCHAR2(32)
IS_READ_ONLY VARCHAR2(8)
IS_SHAREABLE VARCHAR2(8)
TIME_CREATED VARCHAR2(32)
CHAP_USERNAME VARCHAR2(4)
COMPARTMENT_ID VARCHAR2(128)
ATTACHMENT_TYPE VARCHAR2(8)
LIFECYCLE_STATE VARCHAR2(8)
AVAILABILITY_DOMAIN VARCHAR2(32)
IS_PV_ENCRYPTION_IN_TRANSIT_ENABLED VARCHAR2(8)
SELECT t1.*
FROM OCI360_VOL_ATTACHS t1;
2 rows selected.