Excel : How to check switch port status
Вставка
- Опубліковано 7 вер 2024
- How to Check all ports UP / DOWN using Excel & SNMP
Download MIB Browser www.ireasoning...
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
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 ??
I really appreciate your detailing..on everything 💯
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.
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.🙏
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
Excellente video
Valuable guidance to known ! Thanks !
wow thats nice ... is there chance to get also MAC address under each cell?
Thanks man, it is great content
a noob question how to get IP of router/switch? i am learning it on my home PC
Excellent
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.
How about the stack switch with the same IP? How to get the port status form 2:1-2:24?
can we monitor multiple switches in one excel using this
That is very interesting, but who the hell is going to need to show the ethernet port status in EXCEL ???
Excellent video, really works !
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.
can you create full video with configure MIB
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"
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.
just why? why would you use excel to do snmp queries? ...
Hi. How do you run a command like ' ssh username@ip "aLinuxScriptOrCommand" ' and capture its output inside the Excel/VBA ?
Do you have some solution when the ports from device manager are disconected to be enabled forced ?.
Legend
please make a video gpon olt ont dbm show in snmp
Tem como disponibilizar a planilha do excel ? Muito bom.
It's possible to do that with VMware and exel ??
From where I can get the ip address of switch.
Router data swcith Excel piz ?
where switch templates download
i got error message on MIB Browser
" Address of agent cannot be empty "
My ZTE router me option BANDHWTH Q Not show
PRTG is better than.
Can you please share VBA script for SNMP V2 and V3...pls
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
This is absolutely crazy. There are hundreds of free web based tools to monitor switches, why in gods name would you use excel?
How to install Free Panel on Ubuntu
hi NET S/W GUI FILE UPLOADING PLZ
can u share xlsm file?
crazy
😍😍😍😍😍😍😍😍😍😍😍
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!
start using linux)))
Can you use your real voice rather than a computer voice?
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.
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.
Merci !
Thank a lot
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.