5 Replies Latest reply on Dec 9, 2008 8:20 PM by vhcato

Alert variable question

mandg Nov 10, 2008 1:29 PM

I'm looking for a variable in NPM advanced alerts that I can add into the subject line of alert reset messages that show total down time. So, something that can calcuate the time delta of when the system originally went down until the system comes back up (status changes).IE: Alert: ${NodeName} is ${Status} and was down for ${WhatTheHeckGoesHere?}I've reviewed the documentation and this isn't jumping out at me.

Re: Alert variable question

qle Nov 10, 2008 2:42 PM (in response to mandg)

I'm pretty certain such a variable does not exist. You'll probably have to dabble with SQL in order to get this information.
Like Show 0 Likes(0)

Actions
- Re: Alert variable question
  
  mandg Nov 10, 2008 9:08 PM (in response to qle)
  
  hmm- Drats! Not what I was hoping to hear.
  
  Are there any SQL experts in here that like a challenge? Not real sure how to design such a query.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Alert variable question
    
    lopezjo49 Dec 9, 2008 11:12 AM (in response to mandg)
    
    From the Solarwinds variable docs there should be an ${AlertStartTime} and an ${AlertEndTime}
    
    Like Show 0 Likes(0)
    
    Actions
  - Re: Alert variable question
    
    lopezjo49 Dec 9, 2008 11:15 AM (in response to mandg)
    
    The AlertStartTime and End variables may be start or quick workaround.
    
    Like Show 0 Likes(0)
    
    Actions
Re: Alert variable question

vhcato Dec 9, 2008 8:20 PM (in response to mandg)

This is a duplicate post and was actually answered here.
Re: SQL query challange (for me)
Like Show 0 Likes(0)

Actions

Go to original post