View ocum.aggregatecalculationsview 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
aggregateId bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
dfBytesUsedPercent decimal 26,4  √  null
dfBytesAvailPercent decimal 26,4  √  null
dailyGrowthRatePercent double 22  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

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: