View ocum.volumeaggregatecapacitymappingview | Generated by SchemaSpy |
View Definition:
select `volumeaggregatemapping`.`styleExtendedRaw` AS `styleExtendedRaw`,`volumeaggregatemapping`.`volumeId` AS `volumeId`,group_concat(`volumeaggregatemapping`.`aggregateId` separator ',') AS `GROUP_CONCAT(volumeAggregateMapping.aggregateid)`,sum(`inventoryaggregate`.`sizeAvail`) AS `aggrSizeAvail` from (((select distinct `inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`aggregateId` AS `aggregateId`,`inventoryvolume`.`styleExtendedRaw` AS `styleExtendedRaw` from (`netapp_model`.`volume` `inventoryvolume` straight_join `ocum`.`volume` on(((`inventoryvolume`.`objid` = `ocum`.`volume`.`id`) and (`inventoryvolume`.`objState` = 'LIVE')))) where ((`inventoryvolume`.`aggregateId` is not null) and (`inventoryvolume`.`styleExtendedRaw` = 'flexgroup')) union select distinct `f`.`flexgroupId` AS `volumeId`,`inventoryvolume`.`aggregateId` AS `aggregateId`,'flexgroup' AS `styleExtendedRaw` from ((((select `v`.`objid` AS `objid`,`v`.`aggregateId` AS `aggregateId`,`v`.`styleExtendedRaw` AS `styleExtendedRaw` from `netapp_model`.`volume` `v` where (`v`.`objState` = 'LIVE'))) `inventoryvolume` straight_join `ocum`.`volume` on((`inventoryvolume`.`objid` = `ocum`.`volume`.`id`))) left join `netapp_model`.`volume_flexgroup_constituent_relationship` `f` on((`inventoryvolume`.`objid` = `f`.`objid`))) where (`inventoryvolume`.`styleExtendedRaw` = 'flexgroup_constituent')) `volumeaggregatemapping` straight_join `netapp_model`.`aggregate` `inventoryaggregate` on(((`volumeaggregatemapping`.`aggregateId` = `inventoryaggregate`.`objid`) and (`inventoryaggregate`.`objState` = 'LIVE')))) straight_join `ocum`.`aggregate` on((`inventoryaggregate`.`objid` = `ocum`.`aggregate`.`id`))) group by `volumeaggregatemapping`.`volumeId`