Showing results for 
Search instead for 
Did you mean: 
Create Post
Not applicable

Idle Switch Ports

I am looking for a way to ID idle ports on my closet switches. I need to be notified by an alert or report if I have active switch ports in a down state for more than 14 days.
0 Kudos
2 Replies
Level 7

Looked at the DB, try using SQL statement that grabs Interfaces.InterfaceLastChange and calculates > 14 days old AND Interfaces.Status field = <whatever is down>.

This will give you interfaces down > 14 days.

There may be an easier way, but this is off the top of my head.
0 Kudos
Level 7

I would think you'd have to write up a SQL script that took the last status change to down and have it calculate time since down (if there is not a field for that, which there might be).

Create an advanced alert that runs the script every 8 or 9 hours (thats the max allowed I think), and have it send an email or perform some action.

Hope that helps.

0 Kudos