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.
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.