I am working with couples of 3750 switches in different location, all centralized on a backbone 4506. I am trying to find a system to see every hour how many connected ports are in connected status. Any idea ?
So far I had the idea to schedule a show inter status every hours redirected to an excel file, then from there having another excel file who will look in the first one and count the number of connected in it every hour. But I have trouble figuring how to do this part automatically.
Thank you for your help.