Excel : How to check switch port status
HTML-код
- Опубликовано: 10 апр 2021
- How to Check all ports UP / DOWN using Excel & SNMP
Download MIB Browser www.ireasoning.com/mibbrowser...
Download code docdro.id/MrilzCg
NETGEAR 16-Port Gigabit Switch amzn.to/43PUWlF
NETGEAR 24-Port Gigabit Switch amzn.to/3DyTDgt
You subscribe now because it's free / netvn82
#netvn #excel #network #networkmonitoring - Хобби
This is the most 90's thing i've ever seen
Couldn't agree more
Valuable guidance to known ! Thanks !
I really appreciate your detailing..on everything 💯
This is great because it is thinking outside the box. This can also be used for a lot more than just checking the status of ports on a switch
yes, is there a way to show the assigned vlan for each port also ??
You've always been a great help couldn't appreciate you better maahn. Would really appreciate if you could come up with a command prompt for windows 10 activation and if there is one please share.🙏
Thanks man, it is great content
wow thats nice ... is there chance to get also MAC address under each cell?
Excellent video, really works !
Do you have some solution when the ports from device manager are disconected to be enabled forced ?.
Excellente video
Tem como disponibilizar a planilha do excel ? Muito bom.
Excellent
Legend
one of the greatest videos ever, is there a way to show the vlan assigned to each port ?? it'll be a life saver for me
yes it's possible via mikrotik dude
a noob question how to get IP of router/switch? i am learning it on my home PC
It's possible to do that with VMware and exel ??
can we monitor multiple switches in one excel using this
I'm using SNMPv3 in my environment. Could anyone help which what parameters need to be added and to what line of the code to make this work? SNMP and coding is new to me.
this is the most secure way I would configure SNMP. It is in Excel and uses Visual Basic so it will never be hacked. We have never had any issues with the security of Visual Basic or using SNMP v2 in the past.
Hi. How do you run a command like ' ssh username@ip "aLinuxScriptOrCommand" ' and capture its output inside the Excel/VBA ?
Hello. I have a lot of Quidway switches. I think it is possible to add a list of switches so that you can select the IP to check. Thanks. You're making a useful video.
Can you share it with the finished Excel? Thanks.
i got error message on MIB Browser
" Address of agent cannot be empty "
can you create full video with configure MIB
Router data swcith Excel piz ?
From where I can get the ip address of switch.
😍😍😍😍😍😍😍😍😍😍😍
please make a video gpon olt ont dbm show in snmp
That is very interesting, but who the hell is going to need to show the ethernet port status in EXCEL ???
where switch templates download
can u share xlsm file?
My ZTE router me option BANDHWTH Q Not show
What does the string " "public", 2, 1000" mean? And what if the switch is password protected?
public is the community name. 2 is how many times to retry and 1000 is the timeout in ms.
Hi, I followed you along but I cannot go further since my OID-Interfaces starts at .10101 and your example starts at .6 - Could you please help me on here?
Where the code shows "y=x+", make it say "y = x + 10100"
How about the stack switch with the same IP? How to get the port status form 2:1-2:24?
Its possible add that we can check what device is connected in determinate port? For instance, port 1 there ir a switch, port 2 there is a PC, etc
thanks and I hope Master considere this funcionality
How to install Free Panel on Ubuntu
just why? why would you use excel to do snmp queries? ...
hi NET S/W GUI FILE UPLOADING PLZ
Can you please share VBA script for SNMP V2 and V3...pls
crazy
PRTG is better than.
This is absolutely crazy. There are hundreds of free web based tools to monitor switches, why in gods name would you use excel?
Another way?
Why this row y = x + 5
Because the first interface (GigabitEthernet0/0/1) appears as "ifDescr.6" in Mib browser.
Also, there is x =1 in the code.
So 1 + 5 equals 6, 2 + 5 equals 7 and so on
@@matiasvarrone7021 Thank you, I will not notice it in the video.
@@user-xt8wt1vf6n No problem!
Can you use your real voice rather than a computer voice?
start using linux)))
What’s the point of using excel? Seems like you are using paid software for no real reason when you could just write a small script to do the same thing.
Merci !
Thank a lot
I really want to watch this video, but that robo-voice is bloody awful! 🤬
I hate them as well. I think it would be better to just have large text onscreen with no robo voice or simply not make the video at all. I'm saying this as someone who has never published a video containing my voice on youtube.
The robot voice SUCKS, but the concept is interesting, Excel is an interesting and dangerous program that I've used to do some very "non-excel" things with.
Downloaded and ran your example. Received "Run-time error '-2147467259 (800040005)' Unknown Error". What are the prerequisites for your example to work?
Try to set up netframework 3.5
Buenas tardes
excelente aporte que se realizo pero cuando ejecuto el programa me sale este error, de pronto me puedan otientar que puede estar sucediendo. gracias
se ha producido el error '-2147467259 (80004005)' en tiempo de jecución - La operación SNMP solicitada identifico una variable desconocidad
Si, le ponen e on error ayudaria?
This is pretty sweet too bad most people switched to free alternatives like Google docs or LibreOffice.