SQLITE Dude 6 database and objects

RouterOS The Dude
1

Hello, I need to access to the objects colletion inside the dude database, for example I need to be able to read names and IPs of devices.
I already exported the dude.db file sucefully and opened ti with sqlite3, I can view some tables:

sqlite> .tables
chart_values_10min chart_values_2hour objs
chart_values_1day chart_values_raw outages

At this time seeing the table names I think the table called objs is my boy, but after doing some select in the table I see only data like this:

sqlite> select * from objs limit 0,10;
10004|M2
10005|M2
10006|M2
10009|M2
10010|M2
10011|M2
10012|M2
10013|M2
10014|M2
10015|M2

This is only a top 10, but all rows are similar.

The other tables has no relevant information.

Any idea ?

Regards,
RDA.-

2

Yes, I wish it was human readable too, rather than some sort of binary blob.
I’ve half considered having a go at reverse engineering some of the fields (I kinda guess M won’t tell us the structure), but it seems like a lot of work.
Be nice if they finished the command line support in RouterOS as well, which might help.
At the moment, the Dude is an unreliable mess.