Help with Trigger

Question

Hello

I'm new in NPM and i'm tring to trigger an alarm when a routing neighbor is DOWN but the corrisponding physical interface is up.

i try with the configuration in attach but trigger never switch:

IN an extreme depression state i try even with direct database query:

${N=SWQL;M=SELECT ProtocolStatus FROM [dbo].[NPM_RoutingNeighbor] NE

inner join  [dbo].[Nodes] N  on N.nodeid = NE.nodeid

inner join [dbo].[Interfaces] I on I.nodeid= N.NOdeid where N.Caption = '2iGAS-SCALEA-A1' and NE.AutonomousSystem!=65000 and I.InterfaceName='GigabitEthernet0/0/0'}

Somewone can help me?

Francesco,

bobmarley · Answer

If you want to try using a custom SWQL take a look here. Make sure you are using Custom SWQL Alert and then your SWQL condition is selecting the correct table.

You can not edit the Select statement directly so you may need to do some SQL tricks to get everything you need in the query.