View ocum.qtreecapacityutilizationreportview 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
clusterId bigint 19 0
clusterName varchar 255
vserverId bigint 19 0
vserverName varchar 255
volumeId bigint 19 0
volumeName varchar 255
qtreeId bigint 19  √  null
qtreeName varchar 255  √  null
status varchar 12  √  null
quotaType varchar 10  √  null
quotaUserName text 65535  √  null
quotaId bigint 19  √  null
diskUsed bigint 19  √  null
diskHardLimit bigint 19  √  null
diskSoftLimit bigint 19  √  null
diskThreshold bigint 19  √  null
diskHardLimitUnlimited tinyint 3  √  null
diskSoftLimitUnlimited tinyint 3  √  null
diskThresholdUnlimited tinyint 3  √  null
fileUsed bigint 19  √  null
fileSoftLimit bigint 19  √  null
fileHardLimit bigint 19  √  null
fileUsedUnlimited tinyint 3  √  null
fileHardLimitUnlimited tinyint 3  √  null
fileSoftLimitUnlimited tinyint 3  √  null
isQuotaSet bigint 19 0
diskTotal bigint 19  √  null
diskUsedPercent decimal 30,4  √  null
fileUsedPercent decimal 26,4  √  null
clusterFqdn varchar 255  √  null
healthStatus int 10  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventorycluster`.`objid` AS `clusterId`,`inventorycluster`.`name` AS `clusterName`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`name` AS `volumeName`,`inventoryqtree`.`objid` AS `qtreeId`,`inventoryqtree`.`name` AS `qtreeName`,`inventoryqtree`.`status` AS `status`,(case when (`inventoryqtreequota`.`qtreeId` is not null) then 'TREE' else 'NONE' end) AS `quotaType`,(case when (`inventoryqtreequota`.`qtreeId` is not null) then '' else NULL end) AS `quotaUserName`,`inventoryqtreequota`.`objid` AS `quotaId`,`inventoryqtreequota`.`diskUsed` AS `diskUsed`,`inventoryqtreequota`.`diskLimit` AS `diskHardLimit`,`inventoryqtreequota`.`softDiskLimit` AS `diskSoftLimit`,`inventoryqtreequota`.`threshold` AS `diskThreshold`,`inventoryqtreequota`.`diskLimitUnlimited` AS `diskHardLimitUnlimited`,`inventoryqtreequota`.`softDiskLimitUnlimited` AS `diskSoftLimitUnlimited`,`inventoryqtreequota`.`thresholdUnlimited` AS `diskThresholdUnlimited`,`inventoryqtreequota`.`fileUsed` AS `fileUsed`,`inventoryqtreequota`.`softFileLimit` AS `fileSoftLimit`,`inventoryqtreequota`.`fileLimit` 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`,`ocum`.`cluster`.`fqdn` AS `clusterFqdn`,`ocum`.`qtree`.`healthStatus` AS `healthStatus` from ((((((`netapp_model_view`.`qtree` `inventoryqtree` join `ocum`.`qtree` on((`ocum`.`qtree`.`id` = `inventoryqtree`.`objid`))) join `netapp_model_view`.`volume` `inventoryvolume` on((`inventoryvolume`.`objid` = `inventoryqtree`.`volumeId`))) join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryqtree`.`vserverId`))) join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryqtree`.`clusterId`))) left join `netapp_model_view`.`qtree_quota` `inventoryqtreequota` on((`inventoryqtreequota`.`qtreeId` = `inventoryqtree`.`objid`))) join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`))) union all select `inventorycluster`.`objid` AS `clusterId`,`inventorycluster`.`name` AS `clusterName`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`name` AS `volumeName`,`ocum`.`userquota`.`qtree_id` AS `qtreeId`,`inventoryqtree`.`name` AS `qtreeName`,`inventoryqtree`.`status` AS `status`,`inventoryuserquota`.`quotaType` AS `quotaType`,`ocum`.`userquota`.`name` AS `quotaUserName`,`inventoryuserquota`.`objid` AS `quotaId`,`inventoryuserquota`.`diskUsed` AS `diskUsed`,`inventoryuserquota`.`diskLimit` AS `diskHardLimit`,`inventoryuserquota`.`softDiskLimit` AS `diskSoftLimit`,`inventoryuserquota`.`threshold` AS `diskThreshold`,`inventoryuserquota`.`diskLimitUnlimited` AS `diskHardLimitUnlimited`,`inventoryuserquota`.`softDiskLimitUnlimited` AS `diskSoftLimitUnlimited`,`inventoryuserquota`.`thresholdUnlimited` AS `diskThresholdUnlimited`,`inventoryuserquota`.`fileUsed` AS `fileUsed`,`inventoryuserquota`.`softFileLimit` AS `fileSoftLimit`,`inventoryuserquota`.`fileLimit` AS `fileHardLimit`,`inventoryuserquota`.`fileUsedUnlimited` AS `fileUsedUnlimited`,`inventoryuserquota`.`fileLimitUnlimited` AS `fileHardLimitUnlimited`,`inventoryuserquota`.`softFileLimitUnlimited` AS `fileSoftLimitUnlimited`,(`inventoryuserquota`.`qtreeId` is not null) AS `isQuotaSet`,(case when (`inventoryuserquota`.`diskLimitUnlimited` = 1) then `inventoryvolume`.`sizeTotal` else `na_intKBytesToBytes`(`inventoryuserquota`.`diskLimit`) end) AS `diskTotal`,(case when (`inventoryuserquota`.`diskLimitUnlimited` = 1) then (((`inventoryuserquota`.`diskUsed` * 1024) / `inventoryvolume`.`sizeTotal`) * 100) 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`,`ocum`.`cluster`.`fqdn` AS `clusterFqdn`,`ocum`.`qtree`.`healthStatus` AS `healthStatus` from (((((((`netapp_model_view`.`user_quota` `inventoryuserquota` join `ocum`.`userquota` on((`ocum`.`userquota`.`id` = `inventoryuserquota`.`objid`))) join `netapp_model_view`.`volume` `inventoryvolume` on((`inventoryvolume`.`objid` = `inventoryuserquota`.`volumeId`))) join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryuserquota`.`vserverId`))) join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryuserquota`.`clusterId`))) left join `netapp_model_view`.`qtree` `inventoryqtree` on((`inventoryqtree`.`objid` = `ocum`.`userquota`.`qtree_id`))) left join `ocum`.`qtree` on((`ocum`.`qtree`.`id` = `inventoryqtree`.`objid`))) join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`)))
 
Possibly Referenced Tables/Views: