Hey there.
I've scrounged the Alert Lab forum for something like this, but haven't had any luck. Combine that with the fact I've no idea what I'm doing trying to write SQL stuff, I really need the help. :)
What I'm trying to do is for each consecutive alert that goes out for a node that's down is to include how long it's been down since the first alert trigger or just something to tell me how long it's been down for that matter.
Here's what I was thinking:
Give the difference in time between ${LastSystemUpTimePollUtc} and ${Time}, but I'm not sure how well that will work if a node has been down for over 24 hours. I'm not sure if it will work at all.
Am I missing the obvious where there's already something like this built-in or do I need fancy SQL stuff like I'm thinking?
