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

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Alert message

contracer

Hi,

Is there any way to create an alert message like this:

Node ABC - Downtime: 3 hours

Node ABC - Downtime: 45 hours

(Only changing the hour variable)

Thanks

Find more posts tagged with

Accepted answers

KubaM

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()))}

All comments

bshopp

I am checking with Dev on this.

bshopp

OK, there is no canned variable out of the box, but you should be able to use a SQL variable, something like this

Down since: ${SQL:SELECT TOP 1 EventTime FROM Events WHERE NetworkNode = ${NodeID} AND EventType = 1 ORDER BY EventTime DESC}

contracer

Hi,

Now my alert comes with this message:

Node ABC was down for 6/15/2011 4:24:21 PM

but what I need is:

Node ABC: 12 hours in Downtime.

Thanks

KubaM

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()))}

contracer

Thanks a lot.

Working fine...