View netapp_model_view.iscsi_security_entry Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
objid bigint 19 Locally unique object identifier. ZAPIs: iscsi-initiator-auth-get-iter.iscsi-security-entry-info
uuid varchar 255 Globally unique ID of the security entry. Equal to "{clusterUUID}.{VserverUUID}.{initiatorNodeName}.{security}". Not returned from ZAPI
resourceKey varchar 512
clusterId bigint 19
vserverId bigint 19
authenticationType enum 10  √  null Authentication type
initiator varchar 255  √  null Name of initiator
outboundUserName varchar 255  √  null Outbound CHAP user name, returned only if auth-type is CHAP, and outbound authentication is set for initiator.
username varchar 255  √  null Inbound CHAP user name, returned only if auth-type is CHAP.
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`iscsi_security_entry`.`objid` AS `objid`,`netapp_model`.`iscsi_security_entry`.`uuid` AS `uuid`,`netapp_model`.`iscsi_security_entry`.`resourceKey` AS `resourceKey`,`netapp_model`.`iscsi_security_entry`.`clusterId` AS `clusterId`,`netapp_model`.`iscsi_security_entry`.`vserverId` AS `vserverId`,`netapp_model`.`iscsi_security_entry`.`authenticationType` AS `authenticationType`,`netapp_model`.`iscsi_security_entry`.`initiator` AS `initiator`,`netapp_model`.`iscsi_security_entry`.`outboundUserName` AS `outboundUserName`,`netapp_model`.`iscsi_security_entry`.`username` AS `username`,`netapp_model`.`iscsi_security_entry`.`createtime` AS `createTime`,`netapp_model`.`iscsi_security_entry`.`updatetime` AS `updateTime` from `netapp_model`.`iscsi_security_entry` where (`netapp_model`.`iscsi_security_entry`.`objState` = 'LIVE')