View opm.storage_service_level_view | Generated by SchemaSpy |
View Definition:
select `s`.`id` AS `id`,`s`.`uuid` AS `uuid`,`s`.`name` AS `name`,`s`.`description` AS `description`,`s`.`peakIopsPerTB` AS `peakIopsPerTB`,`s`.`expectedIopsPerTB` AS `expectedIopsPerTB`,`s`.`absoluteMinIops` AS `absoluteMinIops`,`s`.`expectedLatency` AS `expectedLatency`,`s`.`peakIopsAllocationPolicy` AS `peakIopsAllocationPolicy`,`s`.`conformancePolicyUuid` AS `conformancePolicyUuid`,`s`.`systemDefined` AS `systemDefined`,`s`.`createTime` AS `createTime`,`s`.`updateTime` AS `updateTime`,sum(coalesce(`netapp_model`.`lun`.`sizeUsed`,`vol`.`sizeUsed`,0)) AS `usedCapacity`,count(`wpm`.`storageServiceLevelId`) AS `workloadCount` from (((`opm`.`storage_service_level` `s` left join `opm`.`workload_provision_mapping` `wpm` on((`wpm`.`storageServiceLevelId` = `s`.`id`))) left join `netapp_model`.`volume` `vol` on(((`vol`.`objid` = `wpm`.`workloadId`) and (`wpm`.`workloadType` = 13)))) left join `netapp_model`.`lun` on(((`netapp_model`.`lun`.`objid` = `wpm`.`workloadId`) and (`wpm`.`workloadType` = 6)))) group by `s`.`name`
Possibly Referenced Tables/Views: