Trigger from SQL Query doent work

francescoVallone

Hello

I try to trigger HSRP status from a cisco switch.

I try to run a query from DB

SELECT status FROM [dbo].[CustomPollerAssignmentView] where nodeid ='1070' and CustomPollerAssignmentID='e52152d8-286f-4a80-83ed-aec24b23fa93'

that return 0 if is standby node  1 otherwhise.

Wen i try to use in a trigger condition the result is ever false and the trigger fail.

what could be the cause?

Thanks in advance

jajao555

That isn't how you use the SQL alert you have to select it from the dropdown. You should see options for SQL and SWQL alerts. Then you'll get a screen like this depending on the type of UNDP poller you setup if its a table or whatever type you have setup.

You just have to work off the SELECT statement that isn't editable to get the trigger you want.