View ocum.initiatordtoviewlist 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
id bigint 19  √  null Locally unique object identifier. ZAPIs: igroup-get-iter.initiator-group-info.initiators.initiator-info
initiatorName varchar 255 Textual name
igroupMappedInitiatorCount bigint 19 0
initiatorType varchar 5
vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverName varchar 255 Textual name
vserverHealthStatus int 10

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select min(`inventoryinitiator`.`objid`) AS `id`,`inventoryinitiator`.`initiatorName` AS `initiatorName`,count(`inventoryinitiator`.`igroupId`) AS `igroupMappedInitiatorCount`,(case when ((strcmp(substring_index(`inventoryinitiator`.`initiatorName`,'.',1),'iqn') = 0) or (strcmp(substring_index(`inventoryinitiator`.`initiatorName`,'.',1),'eui') = 0)) then 'iscsi' else 'fcp' end) AS `initiatorType`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`ocum`.`vserver`.`healthStatus` AS `vserverHealthStatus` from ((`netapp_model_view`.`igroup_initiator` `inventoryinitiator` straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryinitiator`.`vserverId`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`))) group by `inventoryinitiator`.`initiatorName`,`inventoryinitiator`.`vserverId`
 
Possibly Referenced Tables/Views: