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