How to find the current active node in a Vertica Cluster

As far as I know, you can direct your query to any node that you want. Then the cluster spreads the query to all nodes. by default all nodes are active

Thanks @ckotsidimos .

I need to query the cluster from a remote server. So at any time, the command requires a hostname.

Consider a scenario where the current active node goes down.
If I hard-code the hostname of initial active node, the query will fail and it wont replace this hostname with the hostname of the new active node intelligently.

I was hoping to find this information using a command or in a variable so that I can make my query intelligent enough to change hostnames as per the circumstances.

@khizer19194
I have 2 cases for you.

1) try to remotely run admintools on a node remotely and get the details from there
there is a command to get the nodes

2) Make a connection pool and get the names of hosts from that pool for your connection string. We have done this with the dev team in our company and worked.