View ocum.volumeaggregatemappingview | Generated by SchemaSpy |
View Definition:
select distinct `inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`aggregateId` AS `aggregateId`,`inventoryvolume`.`styleExtendedRaw` AS `styleExtendedRaw` from (`netapp_model_view`.`volume` `inventoryvolume` straight_join `ocum`.`volume` on((`inventoryvolume`.`objid` = `ocum`.`volume`.`id`))) where (`inventoryvolume`.`aggregateId` is not null) union select distinct `inventoryvolume`.`flexgroupId` AS `volumeId`,`inventoryvolume`.`aggregateId` AS `aggregateId`,'flexgroup' AS `styleExtendedRaw` from (`netapp_model_view`.`volume` `inventoryvolume` straight_join `ocum`.`volume` on((`inventoryvolume`.`objid` = `ocum`.`volume`.`id`))) where (`inventoryvolume`.`styleExtendedRaw` = 'flexgroup_constituent')
Possibly Referenced Tables/Views: