DownTime - Change minutes to hours

rhether

I am trying to configure an email alert to display downtime in hours rather than minutes.   Maybe add days for the longer ones 

N=Alerting;M=DownTime is displayed in minutes
Took a guess that this would work: N=Alerting;M=DownTime /60

e.g. Object was down for 120 minutes.  --> Object was down for 2 hours.
Is there a method to complete this task?

dkeyser

You'll probably need to use a custom SWQL variable in your email actions. Something like this:

Down for ${N=SWQL;M=SELECT TOP 1000 
HOURDIFF(TriggeredDateTime, GETUTCDATE()) as HoursDown
FROM Orion.AlertActive AA
WHERE AA.AlertObjects.RelatedNodeId = ${N=SwisEntity;M=NodeID} 
} hours.