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