View ocum.clusternoderawspareshareddatacapacityview 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  √  null
rawBytesSharedDataSpare decimal 42  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventorydisk`.`ownerNodeId` AS `node_id`,sum((coalesce(`inventorydisk`.`usableDataSize`,0) + coalesce(`inventorydisk`.`usableRootSize`,0))) AS `rawBytesSharedDataSpare` from `netapp_model_view`.`disk` `inventorydisk` where (`inventorydisk`.`containerTypeRaw` = 'shared') group by `inventorydisk`.`ownerNodeId`