I’m collecting wifi client information for all our wifi clients into an influxDB database. The information is recorded every 10 minutes.
The information looks like this:
timestamp SSID APname APmodel clientIP clientMAC protocol RSSI SNR
I’d like to be able to display a table that only shows records when the SSID or APName differs from the previous record.
I’ve puzzled until my puzzler is sore on how to accomplish this. The influxDB select docs seem to hint that using “distinct” along with “group by” could be the solution, but so far, I’ve not been able to get it to work.