-
Re: Have troubling setting alert for custom Exalt UDP
minnehaha Apr 16, 2013 11:45 AM (in response to minnehaha)*BUMP* I am still stuck trying to figure this out.
-
Re: Have troubling setting alert for custom Exalt UDP
RichardLettsApr 16, 2013 3:50 PM (in response to minnehaha)
${VALUE} is not a simple string, it could be a number of rows from the database and you will get nothing in the alert email if you have more than one interface that matches the locMinRSL
Try something like this, all in one line... try it in the database editor to make sure it returns a simple string.
{SQL:SELECT A.value + ', ' AS [text()] FROM ( Select CPST.* From CustomPollerStatusTable CPST inner join CustomPollers CP on CPST.PollerID=cp.Pollerid where cp.uniquename='locMinRSL' and Value<-54 and CPST.nodeid=${NODEID} ) A FOR xml path('')}
-
Re: Have troubling setting alert for custom Exalt UDP
minnehaha Apr 16, 2013 5:26 PM (in response to RichardLetts)Thank you for the response. I'm not very proficient with the alerts. I did some searching but I am having trouble finding the Database Editor. I think I am having trouble setting it up too. I changed to Custom SQL Alert and tried pasting it into the trigger but I get an error when I press Validate SQL.
-
-
-
Re: Have troubling setting alert for custom Exalt UDP
superfly99Apr 17, 2013 1:31 AM (in response to minnehaha)
I assume the poller works ok when you test it against the device i.e. it will give a figure of around -45. So how are you testing the alert?
-
Re: Have troubling setting alert for custom Exalt UDP
minnehaha Apr 17, 2013 9:29 AM (in response to superfly99)Hi Superfly, what I did is identical to the screen above in the previous post. I go to Advanced Alerts.
Change Type of Property to Monitor = Custom SQL Alert
Setup your Trigger Query = Custom Node Table Poller
Then I paste the query Richard recommended in to the lower window using Ctrl-V. When I click Validate SQL I get this error. I haven't been able to get it to run successfully yet.
I wasn't sure where the database editor is located to test if it returns a simple string as per his instruction to test it.
I have been using Alerts for a while and they have all worked fine but this is my first time setting up an alert using a Universal Device Poller based on the OID. I do have graph under the device that works good. Here's a screenshot of that also. Now we are just trying to get an alert since we have been having some trouble with our point-to-point wireless dropping for some odd reason lately.
-
Re: Have troubling setting alert for custom Exalt UDP
superfly99Apr 18, 2013 12:36 AM (in response to minnehaha)
I was wondering how you were doing your testing as if you are testing it against another device, you may see incorrect values being returned. But I see your poller is working so that's fine, just need to fine tune your email. I did some testing with my own pollers and found the following worked for me.
Change the Type of Property to Monitor to 'Custom Node Poller'. Also change Numeric Value to Numeric Status. Then in your email to get your numeric status to show use the variable ${CustomPollerStatus.RawStatus}
To test your email change the value in "Numeric Status is less than -54" to say 0 so that it will trigger an alert straight away. So once you confirm you're getting the email you like, then change the value back to -54. You'll need to clear the Active Alert each time you wish the Alert to re-trigger but you can obviously write in a Reset Condition once you finished testing your alert.
I don't know anything about SQL so I can't help with that.
-
Re: Have troubling setting alert for custom Exalt UDP
minnehaha Apr 19, 2013 3:26 PM (in response to superfly99)Hey Superfly, that worked perfect! Thank you so much for your help in getting this to work. At first I didn't have the PollerName as part of the Trigger Condition and several devices started sending messages when I set it to 0. Here's a screenshot below of the final alert. It's only the two condition checks but a picture is worth a thousand words or so they say. Thank you again and have a great weekend!
-
Re: Have troubling setting alert for custom Exalt UDP
superfly99Apr 21, 2013 6:48 PM (in response to minnehaha)
Excellent!
Can you please mark this question as answered?
-
-
-
-