View netapp_model_view.qtree_quota | Generated by SchemaSpy |
View Definition:
select `netapp_model`.`qtree_quota`.`objid` AS `objid`,`netapp_model`.`qtree_quota`.`uuid` AS `uuid`,`netapp_model`.`qtree_quota`.`resourceKey` AS `resourceKey`,`netapp_model`.`qtree_quota`.`clusterId` AS `clusterId`,`netapp_model`.`qtree_quota`.`vserverId` AS `vserverId`,`netapp_model`.`qtree_quota`.`volumeId` AS `volumeId`,`netapp_model`.`qtree_quota`.`qtreeId` AS `qtreeId`,`netapp_model`.`qtree_quota`.`quotaTarget` AS `quotaTarget`,`netapp_model`.`qtree_quota`.`diskLimit` AS `diskLimit`,`netapp_model`.`qtree_quota`.`diskLimitUnlimited` AS `diskLimitUnlimited`,`netapp_model`.`qtree_quota`.`diskUsed` AS `diskUsed`,`netapp_model`.`qtree_quota`.`diskUsedUnlimited` AS `diskUsedUnlimited`,`netapp_model`.`qtree_quota`.`fileLimit` AS `fileLimit`,`netapp_model`.`qtree_quota`.`fileLimitUnlimited` AS `fileLimitUnlimited`,`netapp_model`.`qtree_quota`.`fileUsed` AS `fileUsed`,`netapp_model`.`qtree_quota`.`fileUsedUnlimited` AS `fileUsedUnlimited`,`netapp_model`.`qtree_quota`.`softDiskLimit` AS `softDiskLimit`,`netapp_model`.`qtree_quota`.`softDiskLimitUnlimited` AS `softDiskLimitUnlimited`,`netapp_model`.`qtree_quota`.`softFileLimit` AS `softFileLimit`,`netapp_model`.`qtree_quota`.`softFileLimitUnlimited` AS `softFileLimitUnlimited`,`netapp_model`.`qtree_quota`.`threshold` AS `threshold`,`netapp_model`.`qtree_quota`.`thresholdUnlimited` AS `thresholdUnlimited`,`netapp_model`.`qtree_quota`.`createtime` AS `createTime`,`netapp_model`.`qtree_quota`.`updatetime` AS `updateTime` from `netapp_model`.`qtree_quota` where (`netapp_model`.`qtree_quota`.`objState` = 'LIVE')