View ocum.lunlivelistdtoview | Generated by SchemaSpy |
View Definition:
select `inventorylun`.`objid` AS `Id`,substring_index(`inventorylun`.`path`,'/',-(1)) AS `name`,`ocum`.`lun`.`healthStatus` AS `healthStatus`,`inventorylun`.`isOnline` AS `isOnline`,`inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`name` AS `volumeName`,`ocum`.`volume`.`healthStatus` AS `volumeHealthStatus`,`inventorylun`.`size` AS `lunSize`,(not(`inventorylun`.`isSpaceReservationEnabled`)) AS `isThinProvision`,`inventorylun`.`serialNumber` AS `serialNumber`,`inventorylun`.`isMapped` AS `isMapped`,`inventorylun`.`multiProtocolType` AS `osType`,`lunmapidperigroupdtoview`.`mappedLunIdentifier` AS `mappedLunIdentifier`,(case when (`inventoryqtree`.`name` = ' ') then convert(`inventoryvolume`.`name` using utf8mb4) else concat(convert(`inventoryvolume`.`name` using utf8mb4),'/',`inventoryqtree`.`name`) end) AS `container`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`ocum`.`vserver`.`healthStatus` AS `vserverHealthStatus`,`inventoryqtree`.`objid` AS `qtreeId`,`inventoryqtree`.`name` AS `qtreeName`,`ocum`.`qtree`.`healthStatus` AS `qtreeHealthStatus` from ((((((((`netapp_model_view`.`lun` `inventorylun` straight_join `ocum`.`lun` on((`ocum`.`lun`.`id` = `inventorylun`.`objid`))) left join `ocum`.`lunmapidperigroupdtoview` on((`lunmapidperigroupdtoview`.`lunId` = `inventorylun`.`objid`))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventorylun`.`vserverId`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`))) straight_join `netapp_model_view`.`volume` `inventoryvolume` on((`inventoryvolume`.`objid` = `inventorylun`.`volumeId`))) straight_join `ocum`.`volume` on((`ocum`.`volume`.`id` = `inventorylun`.`volumeId`))) left join `netapp_model_view`.`qtree` `inventoryqtree` on((`inventoryqtree`.`objid` = `inventorylun`.`qtreeId`))) left join `ocum`.`qtree` on((`ocum`.`qtree`.`id` = `inventoryqtree`.`objid`)))
Possibly Referenced Tables/Views: