View opm.provisioning_policy_view | Generated by SchemaSpy |
View Definition:
select `p`.`id` AS `id`,`p`.`uuid` AS `uuid`,`p`.`name` AS `name`,`p`.`description` AS `description`,`p`.`spaceThinProvisioned` AS `spaceThinProvisioned`,`p`.`deduplication` AS `deduplication`,`p`.`compression` AS `compression`,`p`.`systemDefined` AS `systemDefined`,`p`.`createTime` AS `createTime`,`p`.`updateTime` AS `updateTime`,count(`w`.`provisioningPolicyId`) AS `workloadCount` from (`opm`.`provisioning_policy` `p` left join `opm`.`workload_provision_mapping` `w` on((`w`.`provisioningPolicyId` = `p`.`id`))) group by `p`.`name`
Possibly Referenced Tables/Views: