1 Reply Latest reply on Jul 27, 2018 7:24 AM by Mark Roberts

    Alert: Variables for mulitple components in 1 alert.

    2her

      Is there a way to populate Statistic data from multiple components into one 1 email alert?

       

      I currently have an application monitor monitoring two components. One is a WMI monitor monitoring the number of blocked processes of a SQL DB, and the other is custom SQL that outputs the block and blocker. I would like one have 1 email alert, with all the information in this screenshot.

       

       

      Thank you!

        • Re: Alert: Variables for mulitple components in 1 alert.
          Mark Roberts

          You can utilise the Custom SQL Variable within the alert variable selector.

           

          You will need to use the other variables within the SQL query in order to bring back the correct information which in this case may be the ApplicationID value for the template these component monitors reside. If you only have this assigned to one, you could hard code the ComponentID value to allow you to filter to this row of data.

          1 of 1 people found this helpful