Status bar data storage/database: reg

30 views
Skip to first unread message

Manu Kumar

unread,
Jul 23, 2023, 12:26:47 PM7/23/23
to open...@googlegroups.com
Greetings...
                   Dear team,
                                     May I know where the STATUS menu bar data is storing in the database. I have gone through all the tables in the db.sqlite3 but status menu data is not strong anywhere in the database. How to find it or else where exactly this data is stored.
Thanks in advance.
image.png
 

Federico Capoano

unread,
Jul 24, 2023, 9:33:24 AM7/24/23
to open...@googlegroups.com
It's stored in influxdb, the measurement is called device_data and by default the retention policy is 24 hours.

F.

--
You received this message because you are subscribed to the Google Groups "OpenWISP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openwisp+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/openwisp/CAGxhKFSa-%2Bx9Jv5uZhaJ%3D--U91fOMPqa7qbGzG7%3DqRG%3D1JhhyQ%40mail.gmail.com.

Manu Kumar

unread,
Jul 25, 2023, 1:43:14 AM7/25/23
to open...@googlegroups.com
I have gone through that Influxdb data in the MEASUREMENTS of usb0 I am able to see the data of signal_strength, signal_power, signal_quality, snr values but the Operator code, Operator name, Model, IMEI, Power status, etc. not able to see anywhere in the database.I have attached the screenshots it. How to track those parameters Where they are stored in the database?

Because I want to fetch these parameters Operator code, Operator name, Model, IMEI, Power status, etc from the database to display data from different ways. 
Thanks in advance.

Influxdb Terminal image:
4c047c62-aa54-4f48-b22e-8d791412260b.png

Status bar of Interface status:USB0 
.usb_data.png

Reply all
Reply to author
Forward
0 new messages