View ocum_report_birt.nodelevelcapacitymapping | Generated by SchemaSpy |
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: