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

How long any node is down

contracer

Hi,

I´m looking for a report to show me how long any node is down... (only nodes in down status now).

Find more posts tagged with

Accepted answers

contracer

Thanks a lot !

All comments

rutgerht

Contracer,

I found this post to have useful info:

If you drop the following (slightly modified) code in an Advanced SQL report it should do the trick.

SELECT

N.StatusLED as Status,N.Caption AS Device,MAX(E.EventTime) AS DownTime,

Cast(DateDiff(day,MAX(E.EventTime),getdate()) as varchar) + ' Day(s) ' + convert(char(8),dateadd(second,DateDiff(second,MAX(E.EventTime),getdate()),0),14) as Duration

FROM

Nodes N

INNER JOIN Events E ON E.NetworkNode = N.NodeID

where N.status = 2

GROUP BY

N.StatusLED,

N.Caption

contracer

Thanks a lot !

slidermike

I see how you did this in an advanced sql search but how can I do this slightly modified?

What I need to do is a monthly report of network "outages" for a certain group we will refer to as Vincent.

It would be helpful to create a report (monthly) that will show me which "Vincent" cisco router went offline & for how long (duration) along with the date of the outage.

Would anyone offer to assit me in how this would be sql coded please?

Thank you in advance.

Mike

contracer

Try this:

slidermike

contracer,

thank you that looks really nice.

Two things though if you have the time.

#1 This precanned sql report is showing last 30 days (not a big deal but would prefer a monthly I can run at the beginning of each new month).

#2 Would you be kind enough to show me an example of how I would tweak it to only show my "Vincent" routers instead of all managed devices?

It would be hugely helpful to be able to break this down by the business unit which can be characterized by router device name.

An example of one for the Vincent group would be usrtrvinXXXX

Thank you

rana468

How to get the report for particular custom group. Above SQL query include node caption only. For example I have created custom group xyz, abc etc. Now I want outage report for XYZ custom group.Would you please let me know how to add custom group in above query.