View ocum.managedvolumecalculationsview | Generated by SchemaSpy |
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: