Obrigado por re-upload este vídeo, o anterior eu não encontrava mais🙇🏻‍♂️♥️

Hey everyone, so I've successfully recreated the report from the video, and it works! Though it is not without its flaws. When sending a ping command to a network device, it is not uncommon for that device to occasionally fail to acknowledge the ping, and thus in my observations, devices that I knew were online would sometimes show as down on this report. With that being said, I think that I identified a simple solution, I added a bit of redundancy to the formulas in columns D & E, they are as follows... =IF(ping(C3),"Up",IF(ping(C3),"Up","Down")) and =IF(ping(C3),rsp_time(C3),IF(ping(C3),rsp_time(C3),"")). Essentially, the formulas return the status & response time if the ping was successful just like in the video, however, if the ping was unsuccessful, it will ping a second time to validate the first attempt at which point, if it failed to ping a second time, it would return the value "Down". I observed significant improvements with this method, and you will not experience false occurrences of the report showing online devices being offline. Hope this helps some of you!

@ReyZero

Жыл бұрын

igual depende de la version y el idioma, las sentencias se deben cambiar al idioma por ej el IF seria "SI" en la version en español

@heisenbergwaffles

8 ай бұрын

Can this implemented on a corporate network??

@Scott93312

8 ай бұрын

@@heisenbergwaffles I don't see why you couldn't, though you'll need to test for yourself. You'll also want to ensure that the IP address range that you want to monitor is static and not dynamic otherwise this solution is irrelevant.

@heisenbergwaffles

8 ай бұрын

@@Scott93312 IPs are static. I'm confused as to where I should save this. I'm trying to setup this to monitor a few critical servers where the monitoring software is installed so that in an event where the corporate monitoring tool is down, I can check or probably add a trigger action. How do I have this connect to the server to get the ping response? Second query different from above : help if you can, I have servers with no Internet enabled. I need to test snmp for nearly 200 devices. Is there something I can do? I can't install any foreign softwares inside and can't download the snmp module for running a snmp script on powershell. What can I do?

Excellent and perhaps one of the best video related to the topic with crystal clear instruction. Highly appreciate the content.👏👏👏

@NETVN82

Жыл бұрын

Glad it was helpful!

Excellent tutorial. Once of the best & useful.

Excelent vídeo. Congratulations.

Awesome. Thank you!!!!!!

Thank you brother, i am admin (technical officer) of it department, its help me a lot, thank you again

Hay quá Ad ơi. Nhiều khi tốn mớ tiền lại không bằng mấy thứ free ngay trước mắt 😂

love this, is there a way to add it to a dashboard? thinking as a smart home integration

Great! My friend.

Use uptime Kuma instead , much easy ,fancy and can alert you.

Thanks.. How we could extend this feature to create a log of every minute of status and latency?

Excelllent!! Brillant!!

Great Learning, ^hank you Sir.

Want more videos on excel ❤

Wow, I had no idea that Excel could be used for programming. 👏👏

Great 👍

Great!

great videos, please can you connect on wifi network with link bat command

Hello friend, do you have a video tutorial about how to install windows from one laptop to another computer? If you have it please share a link

Hay quá anh ơi

Thank you sir, you are the universal god of excel, for being generous sir.

WoW, Great

Como obtener un valor en excel que mando por ip desde una balanza? Gracias

Is it accessible for telnet?

How would you get this to report a time stamp to a .txt for every minute an IP Address is offline?

Cab we log continuous ping with timestamps ??

I get the error message that there is a problem with this formula. He wants to calculate because the cell starts with "="

Is that possible to add automatically make ticket after a fixed(2-5 minutes) time assign concern department ? Or is that possible ticketing system by Excel ? Please share if you have any idea. I hope you can help us. Example: Every IP will be have details data information, when it gets down make ticket in zone/department. And when IP status up it make up status to ticket.

@TomasMisura

Жыл бұрын

I'd say it's possible to connect it with your ticketing system if the system has API to reconnect it with Excel but this would be overcomplicated especially there are existing plenty of existing solutions. Put into your favorite search engine phrase "ticketing system" and "monitoring". I am pretty sure you'll find tons of solutions in matter of seconds.

According to this video how to link with mikrotik wan public ip?

como se actualiza los valores?

Will this work if VBA macros are disabled?

thank you do you have other application that moitor the port or service in multi server/ip?

@TomasMisura

Жыл бұрын

If you mean kind of port scanner so year there are tons of it and many of them are for free

Good video and content. Please dont use robot voice if possible.

Is it monitor Mac address, serial number of the network device also?

@TomasMisura

Жыл бұрын

no, it's just simple ping. usually don't need to monitor anything like this.

From the table is not showing to me

how to used ....

How about in Google sheet?

@TomasMisura

Жыл бұрын

did you try it? I guess Google sheet does not support VBA macros. As far as I know there is something like Apps Script that is dialect of Javascript

Hi Boss in Which language this Ping script has been written ? Thanks

@ouedraogoaboubakari6538

Жыл бұрын

it seems that it is VBA

How can I contact you by email?

Php ?🙃

And for what ??

But why??? 🤷 There are other easier solutions out there.

how to hack wiFi in Android phone

@avinashavinash3756

Жыл бұрын

Ha ha 😅

Yes Excel can do this ... But its the wrong tool. Also Visio is able todo this ... But also Not the best choice.

234

Hi Sir, your video is wonderful i was looking this several months just i got it, is there any way if any link can get alert through email or whatsapp message can link anywhere please suggest

If I want the income tax details of my father-in-law..

great & tq 🥲