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
Store

report on number of times an interface has gone down in X number of months

Hi,

I'm trying to create a syslog report that will display a list of nodes and how many times the WAN interface has gone down in the past three months

Can this be done? I've attempted to use the Advanced SQL report type to do this without much success.

Here's a sample SQL query I've tried:

SELECT SysLog.IP AS IP_Address,
SysLog.Hostname AS Hostname,
COUNT(SysLog.Message) AS Message

FROM
((SysLog INNER JOIN SysLogFacilities SysLog_SysLogFacilities ON (SysLog.SysLogFacility = SysLog_SysLogFacilities.FacilityCode)) INNER JOIN SysLogSeverities SysLog_SysLogSeverities ON (SysLog.SysLogSeverity = SysLog_SysLogSeverities.SeverityCode))

WHERE
( DateTime BETWEEN 40482 AND 40575 )
AND
(
(SysLog.IP LIKE '10.11%') AND
(
(SysLog.Message LIKE '%down%') AND
(SysLog.Message LIKE '%Serial%'))
)

Find more posts tagged with

Accepted answers

All comments

njoylif

what does this query give you? any kind of error, or just empty set (no data)?

GaryB

I get an error.

It says: "Column SysLog.IP is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

If I take out all but COUNT(SysLog.Message) AS Message from the select statment the qurey returns a digit representing the total number if messages containing the words 'down' and 'serial'.

I'm looking for an output which shows each node name and next to it the total number of times a serial interface has gone down on that node.