Was this page helpful?
Caution
You're viewing documentation for an unstable version of ScyllaDB Enterprise. Switch to the latest stable version.
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 |