Cusom SQL Alert for OSPF neighbors down

I apologize in advance if this has already been answered, but I’ve looked everywhere. At the reddit link below, you can see a user came up with an SQL query that he claims would work. We are trying to do something similar by getting a count of neighbors and a count of ospf ports per device_id, and compare the two. If they do not match, we would like to alert.

I am failing to create such SQL query in an alert in Libre and it says it cannot be parsed. Can anyone provide guidance? The problem is that once an OSPF neighbor goes down, it will no longer be remembered by LibreNMS due to the nature of OSPF and neighbor discovery.

Thanks,

Possibly related topics:

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.