View ocum.qtreelivelistdtoview 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: qtree-list-iter.qtree-info
name varchar 255  √  null
healthStatus int 10
volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumeName varchar 255 Textual name
volumeHealthStatus int 10
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 Reference to the qtree to which this quota applies
diskUsed bigint 19  √  null
diskHardLimit bigint 19  √  null
diskSoftLimit bigint 19  √  null
diskThreshold bigint 19  √  null
diskHardLimitUnlimited bit 0  √  1 True if there is no disk limit
diskSoftLimitUnlimited bit 0  √  1 True if there is no soft disk limit
diskThresholdUnlimited bit 0  √  1 True if there is no threshold limit
fileUsed bigint 19  √  null Current number of files used by the quota target
fileSoftLimit bigint 19  √  null
fileHardLimit bigint 19  √  null
fileUsedUnlimited bit 0  √  1 True if there is no limit for file used
fileHardLimitUnlimited bit 0  √  1 True if there is no file limit
fileSoftLimitUnlimited bit 0  √  1 True if there is no soft file limit
isQuotaSet int 10 0
diskTotal bigint 19  √  null
diskUsedPercent decimal 30,4  √  null
fileUsedPercent decimal 26,4  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventoryqtree`.`objid` AS `id`,`inventoryqtree`.`name` AS `name`,`ocum`.`qtree`.`healthStatus` AS `healthStatus`,`inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`name` AS `volumeName`,`ocum`.`volume`.`healthStatus` AS `volumeHealthStatus`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`ocum`.`vserver`.`healthStatus` AS `vserverHealthStatus`,`inventoryqtreequota`.`qtreeId` AS `qtreeId`,(`inventoryqtreequota`.`diskUsed` * 1024) AS `diskUsed`,(case when (`inventoryqtreequota`.`diskLimit` = 0) then NULL else (`inventoryqtreequota`.`diskLimit` * 1024) end) AS `diskHardLimit`,(case when (`inventoryqtreequota`.`softDiskLimit` = 0) then NULL else (`inventoryqtreequota`.`softDiskLimit` * 1024) end) AS `diskSoftLimit`,(case when (`inventoryqtreequota`.`threshold` = 0) then NULL else (`inventoryqtreequota`.`threshold` * 1024) end) AS `diskThreshold`,`inventoryqtreequota`.`diskLimitUnlimited` AS `diskHardLimitUnlimited`,`inventoryqtreequota`.`softDiskLimitUnlimited` AS `diskSoftLimitUnlimited`,`inventoryqtreequota`.`thresholdUnlimited` AS `diskThresholdUnlimited`,`inventoryqtreequota`.`fileUsed` AS `fileUsed`,(case when (`inventoryqtreequota`.`softFileLimit` = 0) then NULL else `inventoryqtreequota`.`softFileLimit` end) AS `fileSoftLimit`,(case when (`inventoryqtreequota`.`fileLimit` = 0) then NULL else `inventoryqtreequota`.`fileLimit` end) AS `fileHardLimit`,`inventoryqtreequota`.`fileUsedUnlimited` AS `fileUsedUnlimited`,`inventoryqtreequota`.`fileLimitUnlimited` AS `fileHardLimitUnlimited`,`inventoryqtreequota`.`softFileLimitUnlimited` AS `fileSoftLimitUnlimited`,(`inventoryqtreequota`.`qtreeId` is not null) AS `isQuotaSet`,(case when (`inventoryqtreequota`.`diskLimitUnlimited` = 1) then `inventoryvolume`.`sizeTotal` else (`inventoryqtreequota`.`diskLimit` * 1024) end) AS `diskTotal`,(case when (`inventoryqtreequota`.`diskLimitUnlimited` = 1) then (((`inventoryqtreequota`.`diskUsed` * 1024) / `inventoryvolume`.`sizeTotal`) * 100) else ((`inventoryqtreequota`.`diskUsed` / `inventoryqtreequota`.`diskLimit`) * 100) end) AS `diskUsedPercent`,(case when (`inventoryqtreequota`.`fileLimitUnlimited` = 1) then NULL else ((`inventoryqtreequota`.`fileUsed` / `inventoryqtreequota`.`fileLimit`) * 100) end) AS `fileUsedPercent` from ((((((`netapp_model_view`.`qtree` `inventoryqtree` straight_join `ocum`.`qtree` on((`ocum`.`qtree`.`id` = `inventoryqtree`.`objid`))) straight_join `netapp_model_view`.`volume` `inventoryvolume` on((`inventoryvolume`.`objid` = `inventoryqtree`.`volumeId`))) straight_join `ocum`.`volume` on((`ocum`.`volume`.`id` = `inventoryvolume`.`objid`))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryqtree`.`vserverId`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`))) left join `netapp_model_view`.`qtree_quota` `inventoryqtreequota` on((`inventoryqtreequota`.`qtreeId` = `inventoryqtree`.`objid`)))
 
Possibly Referenced Tables/Views: