View ocum.lunlivelistdtoview 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: lun-get-iter.lun-info
name varchar 255  √  null
healthStatus int 10
isOnline bit 0  √  null Is LUN online?
volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumeName varchar 255 Textual name
volumeHealthStatus int 10
lunSize bigint 19  √  null Size of the LUN in bytes
isThinProvision int 10  √  null
serialNumber varchar 255  √  null Serial number of the LUN
isMapped bit 0  √  null Is the LUN mapped to any initiator?
osType varchar 255  √  null The OS type of the LUN
mappedLunIdentifier text 65535  √  null
container varchar 511  √  null
vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverName varchar 255 Textual name
vserverHealthStatus int 10
qtreeId bigint 19  √  null Locally unique object identifier. ZAPIs: qtree-list-iter.qtree-info
qtreeName varchar 255  √  null
qtreeHealthStatus int 10  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

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: