Geo SCADA 2020: How to specify which servers I query in my script

[paige66]

Hi there,

In my Geo SCADA 2020 system, I have created 3 different databases as shown in the attachment. In my script, when I wrote a SQL query to query the table by using some codes like 'Set qryResult = Server.Query("SELECT * from CDBOBJECT")'.  However, since I got 3 different servers running behind, are there any server property field that I can add to my codes to specify which servers I want to query such as the server port number?

Thank you for the help.

[BevanWeiss]

This is all based on your System Configuration (Client Configure Connections), and what Node Cost you have assigned to which Server.  The lowest available server will win..

If you're creating a new Automation Interface / .NET API connection, then you can determine yourself which servers to connect to (or which to include in the system).  But if doing things within ViewX scripting it would not be advised to do this.  The Client Configure Connection setup is what you should use.  Even when creating apps etc which use the .NET API I still use the Client Configure Connection setup.

[AdamWoodlandToo]

You could do a seperate query "SELECT NODENAME FROM CROOTGROUP", that will report which server you're connected to (that setting should be from the server you're connected to, not synced from the Main)