Routing Neighbors for a Single Node

Thanks.

This question should be posted in the Alert Lab  since it's distinct from the above shared query.

Hello,

Can someone can create a SQL query when the neighbor node OSFP go down and when both source and neighbor node sample above have custom properties name SLA with a value of 1 will trigger an alert. This is my SQL alert query but need to add condition with SLA.

SQL alert query:
SELECT Nodes.Caption, Nodes.NodeID FROM Nodes
join NodeIPAddresses ni on nodes.nodeid=ni.nodeid
join NPM_RoutingNeighbor_V RN on ni.IPAddress=RN.NeighborIP
WHERE (( (RN.OrionStatus = 2) OR (RN.IsDeleted = 1) )  and nodes.status <> 9 )
group by Nodes.Caption, Nodes.NodeID

Thanks,

Thanks, This is a good one to spot flapping routes.