17 Replies Latest reply on May 1, 2013 11:28 AM by doepain

    E-mail when alert acknowledged

      I've seen a couple of topics asking about this, but no one responded.  Has anyone been able to have Orion send an e-mail when an alert is acknowledged?  Basically, I want Orion to send an e-mail to the ticketing system once an alert has been acknowledged.  Let me know if you want more details.  Thanks.

        • Re: E-mail when alert acknowledged
          ondrej.salplachta

          Hello,

          at this moment it's not possible without code change.

          But you can create trigger in DB for Acknowledged column in AlertStatus table and then send email from MS SQL:

          http://support.microsoft.com/kb/312839
          http://www.motobit.com/tips/detpg_sqlemailcdo/
           

          It’s not clear, but it should works without touching the code.

          Warning: This solution could have some database performance impact.

            • Re: E-mail when alert acknowledged

              Thanks.  I would definitely like to see this as a feature in Orion - but I've already made that post in the feature request area. 

              We've started the long process of migrating off our old monitoring system, which is taking precedence over this particular sub-project.  As soon as time permits, I will look into this solution.  Thanks again for responding with a work-around.

            • Re: E-mail when alert acknowledged
              jamie.burch

              I know this is a pretty old thread, but I'm wondering if this functionality has been added in any of the newer versions, or if a custom SQL script is still needed.  It would be very nice for my team to be able to get an email when an alert is acknowledged rather than having to log in to Orion only to see that an alert was acknowledged 3 hours ago.

                • Re: E-mail when alert acknowledged
                  netlogix

                  you could create a seperate custom SQL alert that will create a new alert and can send an email.

                  Add this as the condition for a custom SQL node alert (you'd need to change Nodes.Caption to Interfaces.Caption for interface, etc)

                      inner join AlertStatus on Nodes.Caption = AlertStatus.ObjectName
                    where AlertStatus.Acknowledged <> 0

                   

                  Not as clean as one SW could make, but it could get you by for now.

                    • Re: E-mail when alert acknowledged
                      syn3rgy

                      Hi netlogix,

                       

                      while I anticipate the added functionality of an email to show that an alert has been acknowledged, please could you forgive me for being a n00b and tell me how i would go about adding the SQL alert?

                       

                      Thank you

                        • Re: E-mail when alert acknowledged
                          netlogix

                          Open Alert Manager on Server - New Alert - Change type in trigger condition to "Custom SQL Alert"

                          Put in the SQL statement I put in before.

                            In your notification email, you could include ${SQL:Select AcknowledgedBy from AlertStatus where ObjectName = '${Caption}'} to get who acknowledged it.

                          Is this what you needed?

                            • Re: E-mail when alert acknowledged
                              syn3rgy

                              Hi netlogix,

                               

                              That is great that you so much. 

                              Just another quick question:

                              I added the the additional line to the email alert to see who has acknowledged it however i get the below error in  my email:

                              ----------------------------

                              MACRO SQL ERROR - Unclosed quotation mark after the character string 'EH2-1'.
                              Incorrect syntax near 'EH2-1'.'

                              ----------------------------

                              Also, for me, ${Caption} does not exist :(

                          • Re: E-mail when alert acknowledged
                            macgyver

                            Has this still not been addressed? Is the custom SQL still the only way to get anything like this?

                        • Re: E-mail when alert acknowledged
                          ZBurkett

                          The suggested SQL statement to dertermine if an alert has been acknowlegde works for creating a trigger condition, but when the trigger action of sending an email is excuted with the variable ${Acknowledged} it returns "Not Acknowledge" when the alert has been acknowledged either using the web console, a URL in an email, or directly using the "Alert Manger - Active Alerts".  Why would this variable be set incorrectly and is there a custom SQL statement that could be embeded in the body of the message to be sent?

                          Here is the body of the message to be sent; The  ${Acknowledged} status is incorrect and ${AcknowledgedBy} is not even displayed.

                          User: ${SQL:Select AcknowledgedBy from AlertStatus where ObjectName = '${Caption}'}

                          ${Acknowledged}
                          ${AcknowledgedBy}
                          Time: ${AcknowledgedTime}

                          Alert: ${AlertName}

                          • Re: E-mail when alert acknowledged
                            pmzwieryznski

                            I to am trying to get this to work and can't understand why they wouldn't have something like this implemented already? I've implemented the SQL statement as was suggested in the posting here but cannot get it to trigger? Does anyone have any suggestions? The query does check out, it just never fires...

                            • Re: E-mail when alert acknowledged
                              Radioteacher

                              It would be wonderful if an email can be sent what an Alert is Acknowledged that contains Who Acknowledged it and what was written to the Acknowledgment Text Box.

                               

                              Can 10.3 do this?

                              • Re: E-mail when alert acknowledged
                                doepain

                                When I go to "Custom SQL Alert" Select NODE" and then add the SQL "join statement" I am given this error:

                                 

                                ScreenShot108.png

                                 

                                Any thoughts on what I am doing wrong?