View ocum.aggregatecalculationsview | Generated by SchemaSpy |
View Definition:
select `aggregate`.`objid` AS `aggregateId`,(case when (`aggregate`.`sizeTotal` = 0) then 0 else ((`aggregate`.`sizeUsed` / `aggregate`.`sizeTotal`) * 100) end) AS `dfBytesUsedPercent`,(case when (`aggregate`.`sizeTotal` = 0) then 0 else ((`aggregate`.`sizeAvail` / `aggregate`.`sizeTotal`) * 100) end) AS `dfBytesAvailPercent`,(case when (`aggregate`.`sizeTotal` = 0) then 0 else ((`ocum`.`aggregateregressioninfo`.`bytesUsedPerDay` / `aggregate`.`sizeTotal`) * 100) end) AS `dailyGrowthRatePercent` from (`netapp_model_view`.`aggregate` join `ocum`.`aggregateregressioninfo` on((`aggregate`.`objid` = `ocum`.`aggregateregressioninfo`.`aggregate_id`)))
Possibly Referenced Tables/Views: