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