View netapp_model_view.iscsi_session 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-session-get-iter.iscsi-session-list-entry-info
uuid varchar 255 Globally unique ID of the iSCSI Session. Equal to "{clusterUUID}.{VserverUUID}.{portalGroupName}.{targetSessionId}"
resourceKey varchar 512
clusterId bigint 19
targetPortalGroupId bigint 19
initiatorSessionId varchar 255  √  null ISID for this session selected by initiator represented as 6 hexadecimal octets separated by colons, for example: "40:01:37:00:00:00".
targetSessionId int 10  √  null The iSCSI session identifier assigned by the storage system
initiatorNodeName varchar 255  √  null Name of initiator. The initiator name must conform to RFC 3720, for example: "iqn.1987-06.com.initvendor1:appsrv.sn.2346"
initiatorAliasName varchar 255  √  null The user-friendly name assigned to initiator
maxConnections int 10  √  null Maximum number of connections for this session
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`iscsi_session`.`objid` AS `objid`,`netapp_model`.`iscsi_session`.`uuid` AS `uuid`,`netapp_model`.`iscsi_session`.`resourceKey` AS `resourceKey`,`netapp_model`.`iscsi_session`.`clusterId` AS `clusterId`,`netapp_model`.`iscsi_session`.`targetPortalGroupId` AS `targetPortalGroupId`,`netapp_model`.`iscsi_session`.`initiatorSessionId` AS `initiatorSessionId`,`netapp_model`.`iscsi_session`.`targetSessionId` AS `targetSessionId`,`netapp_model`.`iscsi_session`.`initiatorNodeName` AS `initiatorNodeName`,`netapp_model`.`iscsi_session`.`initiatorAliasName` AS `initiatorAliasName`,`netapp_model`.`iscsi_session`.`maxConnections` AS `maxConnections`,`netapp_model`.`iscsi_session`.`createtime` AS `createTime`,`netapp_model`.`iscsi_session`.`updatetime` AS `updateTime` from `netapp_model`.`iscsi_session` where (`netapp_model`.`iscsi_session`.`objState` = 'LIVE')