Querying system tables for cluster topology information

Query system tables to get cluster topology information.

Query system tables to get cluster topology information. Display the IP address of peer nodes, datacenter and rack names, ports, token values, versions, and other information.
Tip: The ring or list view in OpsCenter Monitoring displays IP address and workload, in addition to node health.

Procedure

After setting up a cluster, query the peers and local tables.
SELECT * FROM system.peers;

Example output from querying the peers table:

 peer           | data_center | dse_version | graph | host_id                              | jmx_port | native_transport_address | native_transport_port | native_transport_port_ssl | preferred_ip | rack  | release_version | rpc_address | schema_version                       | server_id         | storage_port | storage_port_ssl | tokens | workload  | workloads
----------------+-------------+-------------+-------+--------------------------------------+----------+--------------------------+-----------------------+---------------------------+--------------+-------+-----------------+-------------+--------------------------------------+-------------------+--------------+------------------+--------+-----------+---------------
 10.10.100.110 |   Cassandra |       6.0.0 | False | ff96a036-a4e3-4257-8787-a66010919c36 |     7199 |                127.0.0.1 |                  9042 |                      9042 |         null | rack1 |      4.0.0.2202 |   127.0.0.1 | b5ce8e4d-8594-31f6-9032-9edd270bbafe | FA-16-3E-EF-9D-EE |         7000 |             7001 |  {'0'} | Cassandra | {'Cassandra'}

(1 rows)