View ocum_report_birt.volumenodecapacitymapping | Generated by SchemaSpy |
View Definition:
select `inventoryvolume`.`nodeId` AS `nodeId`,sum(`inventoryvolume`.`size`) AS `totalVolumeCapacity`,(sum(`inventoryvolume`.`sizeUsed`) + sum(if((`inventoryvolume`.`sizeUsedBySnapshots` > `inventoryvolume`.`snapshotReserveSize`),`inventoryvolume`.`snapshotReserveSize`,`inventoryvolume`.`sizeUsedBySnapshots`))) AS `volumeUsedCapacity`,sum(if(((`inventoryvolume`.`volTypeRaw` = 'dp') or ((`inventoryvolume`.`volTypeRaw` = 'rw') and (`incominginventorysnapmirror`.`objid` is not null) and ((`incominginventorysnapmirror`.`relationshipTypeRaw` = 'data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'vault')))),`inventoryvolume`.`size`,0)) AS `volumeProtectionCapacity` from (`netapp_model_view`.`volume` `inventoryvolume` left join `netapp_model_view`.`snap_mirror` `incominginventorysnapmirror` on(((`incominginventorysnapmirror`.`destinationVolumeId` = `inventoryvolume`.`objid`) and ((`incominginventorysnapmirror`.`relationshipTypeRaw` = 'data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'vault'))))) where (`inventoryvolume`.`derivedStyle` <> 'INFINIVOL') group by `inventoryvolume`.`nodeId`