how do I get a custom SQL alert to trigger on every trap of a specific type to fire.
I hwritten the SQL script to look in the SNMPtraps. The alert runs every minute and the SQL has part of the query that looks at the previous minutes worth of alerts, the only problem is that even though the SQL will return several nodes having matching criteria, only a single alert is triggered for one of the nodes.
Am I doing somethign wrong with the script?
What is the script you are using in the alert? If you are using an or, then it's going to only select a device once that applies to any of the criteria you are looking at. For each instance of a trap type, you'd have to have the alert basically reset and retrigger.
Senior Sales Engineer