Excel : How to check switch port status

welcome to my video in this video i show you how to check the status of all ports of network devices at the same time by microsoft excel in the next video i will show you how to monitor the bandwidth each port make sure these network devices support snmp in this video i'm going to check the status of all ports on a switch on this switch i have enabled snmp first you use the mib browser software to find a list of the oids of the switch device enter the correct ip address of the network device the link to download this software is in the description of the video [Music] here is a list of the switches ports and their corresponding oid list these oids will tell you whether the port is up or down if the result is one the port is up and if the result is two the port is down you need to save these lists to use them in the next steps note that you need to save a microsoft excel file with the extension xlsm at this point you add commands to see the status of the ports [Music] you connect to your network device using [Music] snmp enter the correct ip address of the network device [Music] next i check the port 1 status with the oid found in the previous step [Music] the result i get is one so the port is up [Music] next i will assign green to port 1 if the port is up and white if port 1 is [Music] down as you can see port 1 has turned green you perform a loop to assign the colors to the switch's odd ports [Music] [Music] next do the same for the switch's even ports [Music] in the next video i will show you how to monitor the bandwidth each port remember to subscribe to the channel to follow the next video [Music] i will add some commands to make it easier for you to observe [Music] [Music] [Music] do [Music] finally you add a button to execute the commands you just added and so you can check the status of all the ports of your switch more easily thanks for watching don't forget to like and subscribe you

Channel: NETVN82

Views: 177,933

Keywords: netvn, check port status with microsoft excel, monitor network device with excel vba, connect snmp using microsoft excel, microsoft excel, do it yourself tool check port up down, check network device port using microsoft excel vba, diy port switch monitor, diy interface switch monitor, diy switch monitor, net vn, diy monitor port switch, how to, build your own switch port checking with excel, create your own switch port status checking with excel, how to monitor switch with excel

Id: tUdJjo91e0Q

Length: 7min 4sec (424 seconds)

Published: Sun Apr 11 2021