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