View ocum.igrouplivelistdtoview | Generated by SchemaSpy |
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: