I am looking forward the best solution or custom SQL/SWQL based script inorder to achieve the below logic of interface correlation.
Logic:
1. Single route: parent(Down) - child(Unreachable) multiple routes: Parent(down) - Child(Up): no Interface down alert on child conncting towards the parent If anyother interface goes down which is not of the parent should trigger Interface down.
2. Parent(Up) - Child(Down): no Interface down alert on Parent connecting towards the Child If anyother interface goes down which is not of the child should trigger Interface down.
3. Parent (Up) - Child (Up): if any interface connected between the parent and child goes down it should trigger interface down alert on either the parent or the child
