We want to make an alert that would email a DL if we reached over X traps in a 24 hour period. I am guessing it can be completed in a SQL Script, but I don't know where to start. Any help would be appreciated.
I would do this in the trap viewer itself, and would not need any custom SQL.
then use an alert action to send an email:
Thanks. I set this up and set it to 1 for the triggered alert but nothing was sent to my email. What would you suggest for putting in the conditions? I attempted the default and also not having anything in there with no difference.
Attached is an example -- you will have to edit the thresholds to be something sensible and update the email action..
(this worked for me in my environment a few seconds ago)
thanks, but no attachment came thru with the conditions settings you used.
I included an attachment; I didn't filter anything on the first couple of tabs, so it selected all traps.
I'm sorry, but you need to look in the logs and see what your trap server is doing, because i can assure you this worked.
thanks, but how can i see this in my webAlert List on the Solarwinds WebPage? it a Trap-Alert is active, the soulde be a active-alert in the web-page as well??
Hi
can you not just select the resource and add it ?
Unfortunately this is not easily possible -- the actions inside the Syslog (and trap) processing server applications don't cause advanced alerts to be displayed; they lack the simple ability to set properties on a node (or interface) that can be picked up by an alert.
What I do:
I use the more unusual options in the trap and syslog viewer to do things like set colour (yes, really) or a tag on the trap or alert, and then use a custom SQL alert.
I also have VBS scripts that set properties on objects )yes, really)