Is there a way for an alert email to contain in its message body the 'trigger condition' and 'reset condition'?

ekis

Is there a way for an alert email to contain in its message body the "7. Summary of Alert Configuration"?

If not the entirety of the "Summary of Alert Configuration", is it possible to at least put into the alert email message body both the 'trigger condition' and 'reset condition'?

If this is possible, let me know how it can be done.

Our monitoring team plans to put the 'trigger condition' and 'reset condition' statements at the very bottom of alert email messages as "What logic did this SW alert used to send & fire this triggered / recovered email?".

Let me know if you have inputs, thanks!

mesverrum

Unfortunately the database stores that data in an XML layout that makes it a  real chore to parse out, you could see an example of what you'd be working with using this query in SQL

SELECT * FROM [dbo].[AlertConfigurations]

Specifically your are interested in the Trigger and Reset Columns, an example of one is below for the Node Down alert

<ArrayOfAlertConditionShelve xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Orion.Core.Models.Alerting" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><AlertConditionShelve><AndThenTimeInterval i:nil="true"/><ChainType>Trigger</ChainType><ConditionTypeID>Core.Dynamic</ConditionTypeID><Configuration>&lt;AlertConditionDynamic xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Orion.Core.Alerting.Plugins.Conditions.Dynamic" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"&gt;&lt;ExprTree xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Orion.Core.Models.Alerting"&gt;&lt;a:Child&gt;&lt;a:Expr&gt;&lt;a:Child&gt;&lt;a:Expr&gt;&lt;a:Child/&gt;&lt;a:NodeType&gt;Field&lt;/a:NodeType&gt;&lt;a:Value&gt;Orion.Nodes|Status&lt;/a:Value&gt;&lt;/a:Expr&gt;&lt;a:Expr&gt;&lt;a:Child/&gt;&lt;a:NodeType&gt;Constant&lt;/a:NodeType&gt;&lt;a:Value&gt;2&lt;/a:Value&gt;&lt;/a:Expr&gt;&lt;/a:Child&gt;&lt;a:NodeType&gt;Operator&lt;/a:NodeType&gt;&lt;a:Value&gt;=&lt;/a:Value&gt;&lt;/a:Expr&gt;&lt;/a:Child&gt;&lt;a:NodeType&gt;Operator&lt;/a:NodeType&gt;&lt;a:Value&gt;AND&lt;/a:Value&gt;&lt;/ExprTree&gt;&lt;Scope i:nil="true" xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Orion.Core.Models.Alerting"/&gt;&lt;TimeWindow i:nil="true"/&gt;&lt;/AlertConditionDynamic&gt;</Configuration><ConjunctionOperator>None</ConjunctionOperator><IsInvertedMinCountThreshold>false</IsInvertedMinCountThreshold><NetObjectsMinCountThreshold i:nil="true"/><ObjectType>Node</ObjectType><SustainTime i:nil="true"/></AlertConditionShelve></ArrayOfAlertConditionShelve>

I've considered taking the time to put together some SQL to translate this out into something closer to english but have not been willing to commit the time to make it happen yet.