Hi,
Is there any way to create an alert message like this:
Node ABC - Downtime: 3 hours
or
Node ABC - Downtime: 45 hours
(Only changing the hour variable)
Thanks
Difference between the time of the event (when node went down) and the current time should give you the downtime.
The custom SQL var below should give you just that - downtime in hours. So, just add the flavor text around it to achieve the required result.
${SQL:SELECT datediff(hh, (SELECT TOP 1 EventTime FROM Events WHERE NetworkNode = ${NodeID} AND EventType = 1 ORDER BY EventTime DESC), (SELECT getdate()))}
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.