Cisco Router Alerts Monitoring T1 Circuit

mkurtzhals

I would like to keep a running tally of how many times our T1 circuit drops.  What would be the best alert to use to track this or graph in system managaer.

 

Thanks,

dhardy

Configure an alert to fire off an email to include the result of a query to count the number of events associated to your T1 dropping.

eg

{SQL: SELECT Count(*) AS Count

FROM
(Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType))


WHERE
( EventTime BETWEEN 39812 AND 40132 )
 AND 
(
  (Events.Message LIKE 'ROUTER-Serial0/0/0 · Down')
)}

You could probably write this as a catchall for all T1s, but this will show you a count of all Down Events for the past year if you keep that many.