View ocum.igrouplivelistdtoview 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 Locally unique object identifier. ZAPIs: igroup-get-iter.initiator-group-info
igroupName varchar 255 Textual name
igroupType varchar 255  √  null Raw value of type of initiators in this group.
osType varchar 255  √  null OS type of the initiator group
vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverName varchar 255 Textual name
vserverHealthStatus int 10
mappedLunIdentifier text 65535  √  null
portSetName varchar 255  √  null Textual name
lifMappedIgroupCount varchar 278  √  null
initiatorMappedIgroupCount bigint 19  √  0
lunMappedIgroupCount bigint 19  √  0

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventoryigroup`.`objid` AS `id`,`inventoryigroup`.`name` AS `igroupName`,`inventoryigroup`.`typeRaw` AS `igroupType`,`inventoryigroup`.`osType` AS `osType`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`ocum`.`vserver`.`healthStatus` AS `vserverHealthStatus`,`luncountperigrouplistdtoview`.`mappedLunIdentifier` AS `mappedLunIdentifier`,`lifcountperigrouplistdtoview`.`portSetName` AS `portSetName`,(case when isnull(`lifcountperigrouplistdtoview`.`portSetName`) then 'ALL' else concat(`lifcountperigrouplistdtoview`.`portSetName`,'(',`lifcountperigrouplistdtoview`.`LIFMappingCount`,')') end) AS `lifMappedIgroupCount`,`initiatorcountperigroupdtoview`.`initiatorMappedIgroup` AS `initiatorMappedIgroupCount`,`luncountperigrouplistdtoview`.`LUNMappedIgroup` AS `lunMappedIgroupCount` from ((((((`netapp_model_view`.`igroup` `inventoryigroup` left join `netapp_model_view`.`portset_to_igroup` `inventoryportigroup` on((`inventoryportigroup`.`igroupId` = `inventoryigroup`.`objid`))) left join `ocum`.`lifcountperigrouplistdtoview` on((`lifcountperigrouplistdtoview`.`igroupId` = `inventoryigroup`.`objid`))) left join `ocum`.`initiatorcountperigroupdtoview` on((`initiatorcountperigroupdtoview`.`igroupId` = `inventoryigroup`.`objid`))) left join `ocum`.`luncountperigrouplistdtoview` on((`luncountperigrouplistdtoview`.`igroupId` = `inventoryigroup`.`objid`))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryigroup`.`vserverId`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`)))
 
Possibly Referenced Tables/Views: