Hello,
When I used the last script I had no result.
I checked the access_points table and I found many same rows.
Screenshot attached.
What do you think about this.
The Node 842 is a Mikrotik router.
I used this script to check how many duplicated records I have.
select count(*), ap.node_id, ap.mac_address, ap.vendor, ap.model, ap.serial_number, ap.ap_state, ap.ap_index
from access_points ap
group by ap.node_id, ap.mac_address, ap.vendor, ap.model, ap.serial_number, ap.ap_state, ap.ap_index
I attached the results.
Any idea or suggestion?
Thank you for any help!
Regards,
Mortymer
[image: heidisql.PNG]
[image: heidisql-2.PNG]