docker exec -it influxdb influx -execute 'show measurements' -database 'sonos'
name: measurements
name
----
metrics
docker exec -it influxdb influx -database 'sonos' -execute 'SELECT LAST("AVG_NOISE_FLOOR_DBM") FROM "influxTestDB"."autogen"."TEST" GROUP BY "device" LIMIT 5;'
name: TEST
tags: device=
time last
---- ----
1579607744957000000 104.33333333333333
name: TEST
tags: device=Bedroom
time last
---- ----
1579608296503000000 103.66666666666667
name: TEST
tags: device=Dining Room
time last
---- ----
1579608234480000000 0
name: TEST
tags: device=Kitchen
time last
---- ----
1579608296491000000 104.33333333333333
docker exec -it influxdb influx -database 'sonos' -execute 'SELECT LAST("AVG_NOISE_FLOOR_DBM") FROM "influxTestDB"."autogen"."TEST" GROUP BY "device" LIMIT 5;'
name: TEST
tags: device=
time last
---- ----
1579607744957000000 104.33333333333333
name: TEST
tags: device=Bedroom
time last
---- ----
1579608296503000000 103.66666666666667
name: TEST
tags: device=Dining Room
time last
---- ----
1579608234480000000 0
name: TEST
tags: device=Kitchen
time last
---- ----
1579608296491000000 104.33333333333333