View ocum.halevelmapping 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
haPairId bigint 19 Locally unique object identifier. ZAPIs: cf-get-iter.storage-failover-info
nodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
haPairName varchar 511  √  null
clusterId bigint 19  √  null
partnerNodeId bigint 19  √  null
model varchar 255  √  null Hardware model of this node.
ontapVersion varchar 1024  √  null
isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
rawDiskBytesTotal decimal 41  √  null
aggregateBytesUsed decimal 41  √  null
aggregateBytesTotal decimal 41  √  null
totalVolumeCapacity decimal 63  √  null
volumeUsedCapacity decimal 64  √  null
volumeProtectionCapacity decimal 63  √  null
assignedLunCapacity decimal 65  √  null
unassignedLunCapacity decimal 65  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `hapair`.`objid` AS `haPairId`,`nodelevelcapacitymapping`.`nodeId` AS `nodeId`,concat(`nodelevelcapacitymapping`.`nodeName`,'/',`nodelevelcapacitymapping`.`partnerNodeName`) AS `haPairName`,`nodelevelcapacitymapping`.`clusterId` AS `clusterId`,`nodelevelcapacitymapping`.`partnerNodeId` AS `partnerNodeId`,`nodelevelcapacitymapping`.`model` AS `model`,`nodelevelcapacitymapping`.`ontapVersion` AS `ontapVersion`,`nodelevelcapacitymapping`.`isAllFlashOptimized` AS `isAllFlashOptimized`,sum(`nodelevelcapacitymapping`.`rawDiskBytesTotal`) AS `rawDiskBytesTotal`,sum(`nodelevelcapacitymapping`.`aggregateBytesUsed`) AS `aggregateBytesUsed`,sum(`nodelevelcapacitymapping`.`aggregateBytesTotal`) AS `aggregateBytesTotal`,sum(`nodelevelcapacitymapping`.`totalVolumeCapacity`) AS `totalVolumeCapacity`,sum(`nodelevelcapacitymapping`.`volumeUsedCapacity`) AS `volumeUsedCapacity`,sum(`nodelevelcapacitymapping`.`volumeProtectionCapacity`) AS `volumeProtectionCapacity`,sum(`nodelevelcapacitymapping`.`assignedLunCapacity`) AS `assignedLunCapacity`,sum(`nodelevelcapacitymapping`.`unassignedLunCapacity`) AS `unassignedLunCapacity` from (`netapp_model_view`.`ha_pair` `hapair` left join `ocum`.`nodelevelcapacitymapping` on(((`nodelevelcapacitymapping`.`nodeId` = `hapair`.`node1Id`) or (`nodelevelcapacitymapping`.`nodeId` = `hapair`.`node2Id`)))) group by `haPairId`
 
Possibly Referenced Tables/Views: