In the Alert Execution Settings; if the ‘Repeat this action every X minutes’ is checked; is there a way to include in the alert how many times the alert has been repeated?
There is ${N=Alerting;M=AlertTriggerCount} Count of triggers, but it looks like it's for how many times the alert has fired in general.
Otherwise you may need to create a custom query to return the count per instance of the alert.
hebron1212 This is the join I have on one of my displays, showing how many times a node has been down in the past 24 hours/1 day. It joins on the Orion.Nodes table. I snagged it from someone's THWACK post a long time ago, but perhaps it could be used for your purpose.
LEFT JOIN (SELECT n.Events.NetworkNode, COUNT(*) AS TimesBounced FROM Orion.Nodes AS n WHERE n.Events.EventType=1 AND (n.Events.EventTime > (GetUtcDate() - 1)) GROUP BY n.Events.NetworkNode ) AS a ON a.NetworkNode=n.NodeID
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.