2 Replies Latest reply on Feb 3, 2011 7:12 AM by GaryB

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

    GaryB

      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%'))
      )