Hi
I want to Alert only on OSPF ( ProtocolID='13)
NOT Neighbors in BGP
OSPF Neighbors is NOT Status FULL
Neighbors is a Node in NPM and not interface.
Node NPM status is UP
Something that look like that in SQL
where ProtocolID='13' and ProtocolStatus <>'8'
Can I do that without Adv. SQL ?
Have this one
WHERE
(
(Nodes.Node_Alarm_Type <> 'NO_ALARM') AND
(Nodes.Node_Alarm_Type <> 'N_SILENT') AND
(Nodes.Node_Alarm_Type = '24-7') AND
(Nodes.Status = '1') AND
( Node_Type='BBN-AS') AND
(NPM_RoutingNeighbor_V.ProtocolStatus<> '8') AND
(NPM_RoutingNeighbor_V.ProtocolID = 13)
)
the SQL is Okay but I dont see alert in that way.