Cluster Name in a view

I need to identify the cluster server name when the primary server name is specified.I would like to create a view that first column value is Primary server name, and second column be the cluster server name.

Is there a way to create this view?

Thanks

Subject: Don’t need a view

Get a handle to the primary server document and get the cluster name from the field named ClusterName

Subject: Thanks - Still need cluster server anme

Thanks David… but that will only give me the cluster name, how do i get the secondary server name from just the cluster name?

Subject: Answer…

This form has 2 fields Server_Name & Server_Name2

Server_Name is editable and people select the server names from Dom Dir

Server_Name2 is computed with the formula below, assuming this is running on Dom Dir Db

Cluster := @DbLookup( “”:“NoCache” ; “”:“” ; “($Servers)”;Server_Name; 8) ;

ServerSet := @DbLookup( “”:“NoCache” ; “”:“” ; “($Clusters)”;Cluster; 2) ;

@If(@IsError(ServerSet); “-No Server Selected-”; @Subset(ServerSet;-1))