View netapp_model_view.qos_policy_group | Generated by SchemaSpy |
View Definition:
select `pg`.`objid` AS `objid`,`pg`.`UUID` AS `uuid`,`pg`.`resourceKey` AS `resourceKey`,`pg`.`clusterId` AS `clusterId`,`pgv`.`vserverId` AS `vserverId`,`pg`.`policyGroup` AS `policyGroup`,`pg`.`pgIdentifier` AS `pgIdentifier`,`pg`.`policyGroupClass` AS `policyGroupClass`,`pg`.`policyGroupClassRaw` AS `policyGroupClassRaw`,`pg`.`maxThroughput` AS `maxThroughput`,`pg`.`minThroughput` AS `minThroughput`,`pg`.`isShared` AS `isShared`,`pg`.`isAdaptive` AS `isAdaptive`,`pg`.`minIOPsAllocation` AS `minIOPsAllocation`,`pg`.`enforceFloor` AS `enforceFloor`,`pg`.`allocation` AS `allocation`,`pg`.`minAllocation` AS `minAllocation`,`pg`.`blockSize` AS `blockSize`,`pg`.`capacityUnit` AS `capacityUnit`,`pg`.`createtime` AS `createTime`,`pg`.`updatetime` AS `updateTime` from (`netapp_model`.`qos_policy_group` `pg` left join `netapp_model`.`qos_policy_group_vserver_relationship` `pgv` on((`pg`.`objid` = `pgv`.`objid`))) where (`pg`.`objState` = 'LIVE')