View ocum.clusternoderawsparecapacityview 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
node_id bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
rawBytesSpare decimal 65  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `node`.`objid` AS `node_id`,sum(((coalesce(`clusternodededicatesparecapacityview`.`rawBytesDedicatedSpare`,0) + coalesce(`clusternoderawspareshareddatacapacityview`.`rawBytesSharedDataSpare`,0)) + coalesce(`clusternoderawsparesharedcachecapacityview`.`rawBytesSharedCacheSpare`,0))) AS `rawBytesSpare` from (((`netapp_model_view`.`node` left join `ocum`.`clusternodededicatesparecapacityview` on((`clusternodededicatesparecapacityview`.`node_id` = `node`.`objid`))) left join `ocum`.`clusternoderawspareshareddatacapacityview` on((`clusternoderawspareshareddatacapacityview`.`node_id` = `node`.`objid`))) left join `ocum`.`clusternoderawsparesharedcachecapacityview` on((`clusternoderawsparesharedcachecapacityview`.`node_id` = `node`.`objid`))) group by `node`.`objid`
 
Possibly Referenced Tables/Views: