Centova Technologies Forum
Centova Cast v3 => General discussion => Topic started by: natoleal on May 17, 2016, 10:36:12 am
-
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;