Re: Is there a way to find out if a server is part of application connection string?

2023-06-07 Thread Miles Garnsey
Could you maybe do something with the output of lsof -nPi? It'll give you open network connections across the system. You could then filter them down using grep/awk for just those accessing Cassandra's CQL port (9042 by default). On Wed, Jun 7, 2023 at 10:10 AM Surbhi Gupta wrote: > Hi, > > We

Re: Is there a way to find out if a server is part of application connection string?

2023-06-07 Thread Miklosovic, Stefan
Hi Surbhi, maybe looking into system_views.clients virtual table in case you are on a cluster of version 4.0+ would be helpful? That table contains all clients connected to that particular Cassandra node having "address" and "hostname" columns as well as "username" column. I am not sure there