8 Replies Latest reply on Apr 21, 2013 6:48 PM by superfly99

    Have troubling setting alert for custom Exalt UDP

    minnehaha
    minnehaha Apr 16, 2013 11:44 AM

      (I am having trouble setting up an alert based on the Received Signal Level (RSL) of an Exalt wireless radio from a Universal Device Poller.


      I chose 'Custom Node Table Poller'

      Trigger Alert when 'all' of the following apply

      Poller Name 'is equal to' locMinRSL

      Numeric Value 'is less than' -54

       

       

       

      I can't seem to get the correct value to report on the 'Triggered Actions' alert message. In fact I don't even know if I have the alert setup corretly. I tried variables ${Value} ${NumValue} and everything seems to report 0 (zero).

       

      Can anyone guide on what I am doing wrong and how to get the Trigger Action email to display the actual value? If the value of the RSL falls to -55 or lower on the wireless we want to get an alert. Here's a couple of screenshots to help. The Message doesn't makes sense I am just trying to get the correct string to display the value which is usually around -45.

       

      Thank you in advance for any help.exalt1.JPGexalt2.JPG

        • Re: Have troubling setting alert for custom Exalt UDP
          minnehaha
          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
              RichardLetts
              RichardLetts Expert Apr 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
              superfly99
              superfly99 Expert Apr 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
                  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.

                   

                  exalt4.JPGexalt5.JPG

                    • Re: Have troubling setting alert for custom Exalt UDP
                      superfly99
                      superfly99 Expert Apr 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.