View ocum.clusternoderawsparecapacityview | Generated by SchemaSpy |
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: