Needing variable for 'last trigger' date/time

I would like to include in my reset/up notifications, the date/time of the actually trigger. i.e. - when a WAN site comes back up, I'd like to say the site had originally reported down at mm/dd/yyyy at 00:00 AM/PM, etc. I want to accomplish this with an advanced alert and have tried the following variables:

TriggerTime: ${TriggerTime}

LongTriggerTime: ${LongTriggerTime}

AlertStartTime: ${AlertStartTime}

AlertEndTime: ${AlertEndTime}

I had hoped that ${TriggerTime} would give me a date/time of when that particular alert triggered, but not luck. In advanced alerts, they variables come across as null. How can I include the date/time in my RESET/UP email notifications of the TRIGGER/DOWN details?

Find more posts tagged with

Accepted answers

All comments

vhcato

Chris, I believe the value you seek is "TriggerTimeStamp" in the "AlertStatus" table. Have you tried using this? You may have to use ${SQL:{query}}... ~ Vic

Geoo

This sort of works but at times I have found that, for whatever reason, the timestamp doesnt get updated so if a router goes down multiple times.. it may give an incorrect timestamp. Sometimes it seems that its just randomly putting in a time for that field.

ljenkins1

I don't know if this is what you want, but I use a custom field called "TimeOfLastOutage" and have a basic alert fill that in, then the advanced alerts just reference that variable.

It's always worked well for me.

Geoo

Out of curiousity, what would cause it to start sending the same value "3/26/2009 6:25:25 AM" all the sudden when using the TriggerTimeStamp? In my mail message I am using the line "This device originally went to dial back up at: ${SQL:SELECT TriggerTimeStamp FROM AlertStatus} "

At first it seemed to be working right. Then suddenly this morning, it says that every device went to backup at "3/26/2009 6:25:25 AM" Regardless of when they actually went to backup.

When I was messing with things last night I changed it too, "This device originally went to dial back up at: ${SQL:SELECT * FROM AlertStatus}" , but I dont know if that would hurt anything. I was hoping it would tell me what was available to choose from inside of "AlertStatus".

Obviously, I am a complete SQL noob.

Jim