View ocum.qtreelivelistdtoview | Generated by SchemaSpy |
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`)))