Hi,
I’m fairly new to LibreNMS and making my way through setting up some alerts. However, I have a specific requirement where I’d like to alert when BGP session 192.168.100.1 and 192.168.200.1 are both down, but not necessarily when just one if down. I’ve tried some custom SQL queries, but I’m unable to achieve this (it could be because my SQL query skill are average at best…)
I don’t mind plugging away at this and hopefully I’ll get there, however, I just thought I’d check to see if anyone has done something similar or even if it’s possible.
It seems the bgpPeers.bgpPeerState just checks for any session that’s down and can’t really be tied to a particular neighbor.
Any help or advice would be appreciated.
Cheers,
Luke