View ocum_report_birt.hapairview | Generated by SchemaSpy |
View Definition:
select `hapair`.`objid` AS `objid`,`hapair`.`node1Id` AS `node1Id`,`hapair`.`node2Id` AS `node2Id`,cast(concat(`node1`.`name`,'/',`node2`.`name`) as char(255) charset utf8mb4) AS `haPairName` from ((`netapp_model_view`.`node` `node1` join `netapp_model_view`.`node` `node2` on((`node1`.`objid` = `node2`.`partnerNodeId`))) join `netapp_model_view`.`ha_pair` `hapair` on(((`hapair`.`node1Id` = `node1`.`objid`) and (`hapair`.`node2Id` = `node1`.`partnerNodeId`))))