View ocum_report_birt.qtreecapacityutilization 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
qtreeId bigint 19 0
qtreeName varchar 255  √  null
volumeId bigint 19 0
VolumeName varchar 255
volumeTotalSize bigint 19  √  null
VserverName varchar 255
clusterName varchar 255
quotaUserName varchar 255  √  null
quotaId bigint 19  √  null
quotaType varchar 10  √  null
diskLimit bigint 19  √  null
diskUsed bigint 19  √  null
fileLimit bigint 19  √  null
fileUsed bigint 19  √  null
softDiskLimit bigint 19  √  null
softFileLimit bigint 19  √  null
diskLimitUnlimited tinyint 3  √  null
fileLimitUnlimited tinyint 3  √  null
softDiskLimitUnlimited tinyint 3  √  null
softFileLimitUnlimited tinyint 3  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `qtree0`.`objid` AS `qtreeId`,`qtree0`.`name` AS `qtreeName`,`qtree0`.`volumeId` AS `volumeId`,`volume0`.`name` AS `VolumeName`,NULL AS `volumeTotalSize`,`vserver0`.`name` AS `VserverName`,`cluster0`.`name` AS `clusterName`,NULL AS `quotaUserName`,NULL AS `quotaId`,NULL AS `quotaType`,NULL AS `diskLimit`,NULL AS `diskUsed`,NULL AS `fileLimit`,NULL AS `fileUsed`,NULL AS `softDiskLimit`,NULL AS `softFileLimit`,NULL AS `diskLimitUnlimited`,NULL AS `fileLimitUnlimited`,NULL AS `softDiskLimitUnlimited`,NULL AS `softFileLimitUnlimited` from (((`netapp_model_view`.`qtree` `qtree0` join `netapp_model_view`.`volume` `volume0` on((`volume0`.`objid` = `qtree0`.`volumeId`))) join `netapp_model_view`.`vserver` `vserver0` on((`vserver0`.`objid` = `qtree0`.`vserverId`))) join `netapp_model_view`.`cluster` `cluster0` on((`cluster0`.`objid` = `qtree0`.`clusterId`))) where ((`qtree0`.`qtreeIdentifier` <> 0) and (not(`qtree0`.`objid` in (select distinct `qtree_quota`.`qtreeId` from `netapp_model_view`.`qtree_quota`))) and (not(`qtree0`.`objid` in (select distinct `user_quota`.`qtreeId` from `netapp_model_view`.`user_quota`)))) union select `qtree1`.`objid` AS `qtreeId`,`qtree1`.`name` AS `qtreeName`,`qtree1`.`volumeId` AS `volumeId`,`volume1`.`name` AS `VolumeName`,`volume1`.`sizeTotal` AS `volumeTotalSize`,`vserver1`.`name` AS `VserverName`,`cluster1`.`name` AS `clusterName`,'' AS `quotaUserName`,`qtree_quota`.`objid` AS `quotaId`,'TREE' AS `quotaType`,`qtree_quota`.`diskLimit` AS `diskLimit`,`qtree_quota`.`diskUsed` AS `diskUsed`,`qtree_quota`.`fileLimit` AS `fileLimit`,`qtree_quota`.`fileUsed` AS `fileUsed`,`qtree_quota`.`softDiskLimit` AS `softDiskLimit`,`qtree_quota`.`softFileLimit` AS `softFileLimit`,`qtree_quota`.`diskLimitUnlimited` AS `diskLimitUnlimited`,`qtree_quota`.`fileLimitUnlimited` AS `fileLimitUnlimited`,`qtree_quota`.`softDiskLimitUnlimited` AS `softDiskLimitUnlimited`,`qtree_quota`.`softFileLimitUnlimited` AS `softFileLimitUnlimited` from ((((`netapp_model_view`.`qtree` `qtree1` join `netapp_model_view`.`qtree_quota` on((`qtree1`.`objid` = `qtree_quota`.`qtreeId`))) join `netapp_model_view`.`volume` `volume1` on((`volume1`.`objid` = `qtree1`.`volumeId`))) join `netapp_model_view`.`vserver` `vserver1` on((`vserver1`.`objid` = `qtree1`.`vserverId`))) join `netapp_model_view`.`cluster` `cluster1` on((`cluster1`.`objid` = `qtree1`.`clusterId`))) where (`qtree1`.`qtreeIdentifier` <> 0) union select `qtree2`.`objid` AS `qtreeId`,`qtree2`.`name` AS `qtreeName`,`qtree2`.`volumeId` AS `volumeId`,`volume2`.`name` AS `VolumeName`,`volume2`.`sizeTotal` AS `volumeTotalSize`,`vserver2`.`name` AS `VserverName`,`cluster2`.`name` AS `clusterName`,`quota_user`.`quotaUserName` AS `quotaUserName`,`user_quota`.`objid` AS `quotaId`,`user_quota`.`quotaType` AS `quotaType`,`user_quota`.`diskLimit` AS `diskLimit`,`user_quota`.`diskUsed` AS `diskUsed`,`user_quota`.`fileLimit` AS `fileLimit`,`user_quota`.`fileUsed` AS `fileUsed`,`user_quota`.`softDiskLimit` AS `softDiskLimit`,`user_quota`.`softFileLimit` AS `softFileLimit`,`user_quota`.`diskLimitUnlimited` AS `diskLimitUnlimited`,`user_quota`.`fileLimitUnlimited` AS `fileLimitUnlimited`,`user_quota`.`softDiskLimitUnlimited` AS `softDiskLimitUnlimited`,`user_quota`.`softFileLimitUnlimited` AS `softFileLimitUnlimited` from (((((`netapp_model_view`.`qtree` `qtree2` join `netapp_model_view`.`user_quota` on((`qtree2`.`objid` = `user_quota`.`qtreeId`))) left join `netapp_model_view`.`quota_user` on((`quota_user`.`userQuotaId` = `user_quota`.`objid`))) join `netapp_model_view`.`volume` `volume2` on((`volume2`.`objid` = `qtree2`.`volumeId`))) join `netapp_model_view`.`vserver` `vserver2` on((`vserver2`.`objid` = `qtree2`.`vserverId`))) join `netapp_model_view`.`cluster` `cluster2` on((`cluster2`.`objid` = `qtree2`.`clusterId`))) where (`qtree2`.`qtreeIdentifier` <> 0)