View ocum_report_birt.nodelevelcapacitymapping 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
nodeId bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
nodeName varchar 255 Textual name
clusterId bigint 19
partnerNodeId bigint 19  √  null
partnerNodeName varchar 255 Textual name
model varchar 255  √  null Hardware model of this node.
isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
ontapVersion varchar 1024  √  null
serialNumber varchar 255  √  null Serial number
cpuFirmwareRelease varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
rawDiskBytesTotal bigint 19  √  null DERIVED.Sum of all disks size total
aggregateBytesUsed bigint 19  √  null DERIVED. Sum of bytes used (including snapshot) on all aggregates in the Node.
aggregateBytesTotal bigint 19  √  null DERIVED. Sum of bytes total (including snapshot) on all aggregates in the Node.
totalVolumeCapacity decimal 41  √  null
volumeUsedCapacity decimal 42  √  null
volumeProtectionCapacity decimal 41  √  null
assignedLunCapacity decimal 63  √  null
unassignedLunCapacity decimal 63  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `node1`.`objid` AS `nodeId`,`node1`.`name` AS `nodeName`,`node1`.`clusterId` AS `clusterId`,`node1`.`partnerNodeId` AS `partnerNodeId`,`node2`.`name` AS `partnerNodeName`,`node1`.`model` AS `model`,`node1`.`isAllFlashOptimized` AS `isAllFlashOptimized`,`ocum`.`na_shortOSVersion`(`node1`.`version`) AS `ontapVersion`,`node1`.`serialNumber` AS `serialNumber`,`node1`.`cpuFirmwareRelease` AS `cpuFirmwareRelease`,`node1`.`rawDiskBytesTotal` AS `rawDiskBytesTotal`,`node1`.`aggregateBytesUsed` AS `aggregateBytesUsed`,`node1`.`aggregateBytesTotal` AS `aggregateBytesTotal`,`volumenodecapacitymapping`.`totalVolumeCapacity` AS `totalVolumeCapacity`,`volumenodecapacitymapping`.`volumeUsedCapacity` AS `volumeUsedCapacity`,`volumenodecapacitymapping`.`volumeProtectionCapacity` AS `volumeProtectionCapacity`,sum(`lunnodecapacitymapping`.`assignedLunCapacity`) AS `assignedLunCapacity`,sum(`lunnodecapacitymapping`.`unassignedLunCapacity`) AS `unassignedLunCapacity` from (((`netapp_model_view`.`node` `node1` join `netapp_model_view`.`node` `node2` on((`node2`.`objid` = `node1`.`partnerNodeId`))) left join `ocum_report_birt`.`volumenodecapacitymapping` on((`volumenodecapacitymapping`.`nodeId` = `node1`.`objid`))) left join `ocum_report_birt`.`lunnodecapacitymapping` on((`lunnodecapacitymapping`.`nodeId` = `node1`.`objid`))) group by `nodeId`
 
Possibly Referenced Tables/Views: