View ocum.volumecalculationsview 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
volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
dfBytesUsedPercent decimal 26,4  √  null
dfBytesAvailablePercent decimal 27,4  √  null
dfSnapshotBytesUsedPercent double 22  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `volume`.`objid` AS `volumeId`,(case when (`volume`.`sizeTotal` = 0) then 0 else ((`volume`.`sizeUsed` / `volume`.`sizeTotal`) * 100) end) AS `dfBytesUsedPercent`,(case when (`volume`.`sizeTotal` = 0) then 0 else (((`volume`.`sizeTotal` - `volume`.`sizeUsed`) / `volume`.`sizeTotal`) * 100) end) AS `dfBytesAvailablePercent`,(case when (`volume`.`snapshotReserveSize` = 0) then 0 else ((`ocumvolume`.`dfSnapshotBytesUsed` / `volume`.`snapshotReserveSize`) * 100) end) AS `dfSnapshotBytesUsedPercent` from (`netapp_model_view`.`volume` join `ocum`.`volume` `ocumvolume` on((`ocumvolume`.`id` = `volume`.`objid`)))
 
Possibly Referenced Tables/Views:
volume