View ocum_report_birt.diskcapacitymapping 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
clusterId bigint 19
unconfiguredRawCapacity decimal 60  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `disk`.`clusterId` AS `clusterId`,sum((`disk`.`bytesPerSector` * `disk`.`capacitySectors`)) AS `unconfiguredRawCapacity` from `netapp_model_view`.`disk` where (`disk`.`containerTypeRaw` not in ('aggregate','spare','shared','broken')) group by `disk`.`clusterId`