Number of Listeners in all streams

Read 6426 times
Hello,

I would like to know if there is a way ( preferably via database, but if other command line i would be happy as well) if i can the list of all active listeners in a respective stream.
I have tried this query in the database, but it does not really return the information needed:

select a.username ,v.starttime,v.endtime,v.ipaddress,v.country 
   from visitorstats_sessions v
inner join
   accounts a
on a.id=v.accountid
order by v.starttime desc , v.endtime desc;