Community discussions

MikroTik App
 
carlosanghez
just joined
Topic Author
Posts: 1
Joined: Mon Apr 27, 2020 3:38 pm

Export history from dude.db

Mon Apr 27, 2020 6:26 pm

Is is possibile to query dude.db?

I need to save ping response from dude.db in a human readble format.

The format of tables is not so easy, but I can retrieve the type of devices: SELECT id, (obj) AS obj FROM objs WHERE HEX(obj) LIKE '4D320100FF8801000F000000%' ORDER by id.

I can retrieve all the devices: SELECT id, (obj) AS obj FROM objs WHERE HEX(obj) LIKE '4D320100FF8801000F000000%' ORDER by id.

I can not query ping result from chart_values_raw yet.

Suggestions?

Thanks in advance,

Carlo Sanghez

Who is online

Users browsing this forum: No registered users and 15 guests