Was this page helpful?
This document describes how to work with ScyllaDB’s client table, which provides real-time information on CQL clients currently connected to the ScyllaDB cluster.
SELECT address, port FROM system.clients;
Example output:
address | port
------------+-------
172.17.0.2 | 33296
172.17.0.2 | 33298
Significant columns in the Client table:
Parameter |
Description |
|---|---|
address (PK) |
Client’s IP address |
port (CK) |
Client’s outgoing port number |
username |
Username - when Authentication is used |
shard_id |
ScyllaDB node shard handing the connection |