View ocum.vserverassociationlivelistdtoview | Generated by SchemaSpy |
View Definition:
select `vserverassociation`.`id` AS `id`,`sourcevserver`.`name` AS `sourceVserverName`,`sourcevserver`.`objid` AS `sourceVserverId`,`sourcecluster`.`name` AS `sourceClusterName`,`sourcecluster`.`objid` AS `sourceClusterId`,`destinationvserver`.`name` AS `destinationVserverName`,`destinationvserver`.`objid` AS `destinationVserverId`,`destinationcluster`.`name` AS `destinationClusterName`,`destinationcluster`.`objid` AS `destinationClusterId`,`vserverassociation`.`connectionType` AS `connectionType` from ((((`ocum`.`storageservicevserverdestination` `vserverassociation` left join `netapp_model_view`.`vserver` `sourcevserver` on((`sourcevserver`.`objid` = `vserverassociation`.`sourceVserver_id`))) straight_join `netapp_model_view`.`vserver` `destinationvserver` on((`destinationvserver`.`objid` = `vserverassociation`.`destinationVserver_id`))) left join `netapp_model_view`.`cluster` `sourcecluster` on((`sourcecluster`.`objid` = `sourcevserver`.`clusterId`))) straight_join `netapp_model_view`.`cluster` `destinationcluster` on((`destinationcluster`.`objid` = `destinationvserver`.`clusterId`)))
Possibly Referenced Tables/Views: