Hi all,

We're currently parsing our radius logs into InfluxDB with the aim of 
getting an idea of how "busy" our routers are. We currently get 
measurements on when devices log out/in/update with the access points, and 
from that we're trying to measure how many concurrent sessions each access 
point has at any given time.

We have a measurement like

time                    ap              device                             
     event                           person
----                    --              ------                             
     --------                        ------
1481065220440122880     24A43C5BA461    2c3acbb5c9ee4bfd45d86dd07fc717a9   
     login                           c07a66088d7aa5aa94a18dd02d33c8e6

where "ap" is an accesspoint, which is a tag.

So far I've done "select count(distinct(person)) from connected" but that's 
very sensitive to the time slice I group by. We assume a device starts a 
session when there's no session going for that device, and we find a 
login/update event, and a session ends at either a logout event for that 
device or no update/login event for two minutes.

Any suggestions on how best to get this data from InfluxDB? Even if it 
means our schema should change?

Thanks,
Emile

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/1267a7ba-4e3f-48b1-b6d7-c73c46cf0a21%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to