View ocum_report_birt.volumenodecapacitymapping Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
nodeId bigint 19  √  null
totalVolumeCapacity decimal 41  √  null
volumeUsedCapacity decimal 42  √  null
volumeProtectionCapacity decimal 41  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

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`