View ocum.managedvolumecalculationsview 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
daysUntilFull double 22  √  null
dailyGrowthRatePercent double 22  √  null
dailySnapshotGrowthRatePercent double 22  √  null
snapshotReserveDaysUntilFull double 22  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `volume`.`objid` AS `volumeId`,(case when (`ocum`.`volumeregressioninfo`.`bytesUsedPerDay` <= 0) then NULL else (`volume`.`sizeAvail` / `ocum`.`volumeregressioninfo`.`bytesUsedPerDay`) end) AS `daysUntilFull`,(case when (`volume`.`sizeTotal` = 0) then 0 else ((`ocum`.`volumeregressioninfo`.`bytesUsedPerDay` / `volume`.`sizeTotal`) * 100) end) AS `dailyGrowthRatePercent`,(case when (`volume`.`snapshotReserveSize` = 0) then NULL else ((`ocum`.`volumeregressioninfo`.`snapshotBytesUsedPerDay` / `volume`.`snapshotReserveSize`) * 100) end) AS `dailySnapshotGrowthRatePercent`,(case when (`volume`.`snapshotReserveSize` = 0) then NULL when (`ocum`.`volumeregressioninfo`.`snapshotBytesUsedPerDay` <= 0) then NULL else (`ocumvolume`.`dfSnapshotBytesAvail` / `ocum`.`volumeregressioninfo`.`snapshotBytesUsedPerDay`) end) AS `snapshotReserveDaysUntilFull` from ((`netapp_model_view`.`volume` join `ocum`.`volume` `ocumvolume` on((`ocumvolume`.`id` = `volume`.`objid`))) join `ocum`.`volumeregressioninfo` on((`volume`.`objid` = `ocum`.`volumeregressioninfo`.`volume_id`)))
 
Possibly Referenced Tables/Views: