View ocum.userquotalivelistdtoview 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: quota-report-iter.quota
healthStatus int 10
quota varchar 1024  √  null
quotaType enum 10  √  null Type of quota
quotaSource varchar 255  √  null
qtreeId bigint 19  √  null
qtreeName varchar 255  √  null
qtreeHealthStatus int 10  √  null
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
diskUsed bigint 19  √  null
diskHardLimit bigint 19  √  null
diskSoftLimit bigint 19  √  null
diskThreshold bigint 19  √  null
diskThresholdUnlimited bit 0 1 True if there is no threshold limit
diskHardLimitUnlimited bit 0 1 True if there is no disk limit
diskSoftLimitUnlimited bit 0 1 True if there is no soft disk limit
fileUsed bigint 19  √  null Current number of files used by the quota target
fileSoftLimit bigint 19  √  null Soft file limit, in number of files, for the quota target
fileHardLimit bigint 19  √  null Maximum number of files allowed for the quota target
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
diskTotal bigint 19  √  null
diskUsedPercent decimal 26,4  √  null
fileUsedPercent decimal 26,4  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventoryuserquota`.`objid` AS `id`,`ocum`.`userquota`.`healthStatus` AS `healthStatus`,`ocum`.`userquota`.`name` AS `quota`,`inventoryuserquota`.`quotaType` AS `quotaType`,(case when (`ocum`.`userquota`.`qtree_id` is not null) then (`inventoryqtree`.`name` collate utf8mb4_unicode_ci) else convert(`inventoryvolume`.`name` using utf8mb4) end) AS `quotaSource`,`ocum`.`userquota`.`qtree_id` AS `qtreeId`,`inventoryqtree`.`name` AS `qtreeName`,`ocum`.`qtree`.`healthStatus` AS `qtreeHealthStatus`,`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`,`na_intKBytesToBytes`(`inventoryuserquota`.`diskUsed`) AS `diskUsed`,`na_intKBytesToBytes`(`inventoryuserquota`.`diskLimit`) AS `diskHardLimit`,`na_intKBytesToBytes`(`inventoryuserquota`.`softDiskLimit`) AS `diskSoftLimit`,`na_intKBytesToBytes`(`inventoryuserquota`.`threshold`) AS `diskThreshold`,`inventoryuserquota`.`thresholdUnlimited` AS `diskThresholdUnlimited`,`inventoryuserquota`.`diskLimitUnlimited` AS `diskHardLimitUnlimited`,`inventoryuserquota`.`softDiskLimitUnlimited` AS `diskSoftLimitUnlimited`,`inventoryuserquota`.`fileUsed` AS `fileUsed`,`inventoryuserquota`.`softFileLimit` AS `fileSoftLimit`,`inventoryuserquota`.`fileLimit` AS `fileHardLimit`,`inventoryuserquota`.`fileUsedUnlimited` AS `fileUsedUnlimited`,`inventoryuserquota`.`fileLimitUnlimited` AS `fileHardLimitUnlimited`,`inventoryuserquota`.`softFileLimitUnlimited` AS `fileSoftLimitUnlimited`,(case when (`inventoryuserquota`.`diskLimitUnlimited` = 1) then NULL else `na_intKBytesToBytes`(`inventoryuserquota`.`diskLimit`) end) AS `diskTotal`,(case when (`inventoryuserquota`.`diskLimitUnlimited` = 1) then NULL else ((`inventoryuserquota`.`diskUsed` / `inventoryuserquota`.`diskLimit`) * 100) end) AS `diskUsedPercent`,(case when (`inventoryuserquota`.`fileLimitUnlimited` = 1) then NULL else ((`inventoryuserquota`.`fileUsed` / `inventoryuserquota`.`fileLimit`) * 100) end) AS `fileUsedPercent` from (((((((`netapp_model_view`.`user_quota` `inventoryuserquota` straight_join `ocum`.`userquota` on((`ocum`.`userquota`.`id` = `inventoryuserquota`.`objid`))) straight_join `netapp_model_view`.`volume` `inventoryvolume` on((`inventoryvolume`.`objid` = `inventoryuserquota`.`volumeId`))) straight_join `ocum`.`volume` on((`ocum`.`volume`.`id` = `inventoryvolume`.`objid`))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryuserquota`.`vserverId`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`))) left join `netapp_model_view`.`qtree` `inventoryqtree` on((`inventoryqtree`.`objid` = `ocum`.`userquota`.`qtree_id`))) left join `ocum`.`qtree` on((`ocum`.`qtree`.`id` = `inventoryqtree`.`objid`)))
 
Possibly Referenced Tables/Views: