work with dude.db

RouterOS The Dude
1

Hi All.

Can some one explain, how i can find correlation between devices on different map and same name columns in dude base ?
On table “outages” we can find this columns

         select   os.serviceID, 
                  os.deviceID, 
                  os.mapID, 
                  datetime(time, 'unixepoch', 'localtime') as ttime, 
                  os.status, 
                  os.duration 
         from     outages os
-------------------------------------------------------------------
os.serviceID, os.deviceID, os.mapID, ttime, os.status, os.duration

2

You are in new territory here, I wish we had some powerful tools to verify and repair databases.