Тэги:
#netvn #net_vn #how_to #monitor_ip_with_excel #monitor_IP_address_using_Microsoft_excel #network_monitoring_tool_with_excel #ip_monitoring_tool_with_excel #ping_with_microsoft_excel #ping_monitor_tool #ping_online_offline_with_microsoft_excel #make_your_own_ping_tool_with_microsoft_excel #create_your_own_ping_tool_with_microsoft_excel #create_your_own_ip_monitoring_tool_with_microsoft_excel #ping #ip #excelКомментарии:
Thank you brother, i am admin (technical officer) of it department, its help me a lot, thank you again
ОтветитьIf I want the income tax details of my father-in-law..
ОтветитьHow to find my ip in excel plz help
ОтветитьWoW, Great
ОтветитьFrom the table is not showing to me
Ответитьcomo se actualiza los valores?
ОтветитьWill this work if VBA macros are disabled?
ОтветитьExcellent tutorial. Once of the best & useful.
ОтветитьExcelllent!! Brillant!!
ОтветитьHow would you get this to report a time stamp to a .txt for every minute an IP Address is offline?
ОтветитьExcellent and perhaps one of the best video related to the topic with crystal clear instruction. Highly appreciate the content.👏👏👏
Ответитьthank you
do you have other application that moitor the port or service in multi server/ip?
Good video and content. Please dont use robot voice if possible.
ОтветитьAre they done with their wonderful date-time format yet? Hell, what a mess...
ОтветитьAnd for what ??
Ответитьlove this, is there a way to add it to a dashboard? thinking as a smart home integration
ОтветитьPhp ?🙃
Ответить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.
Cab we log continuous ping with timestamps ??
Ответить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!
ОтветитьBut why??? 🤷
There are other easier solutions out there.
According to this video how to link with mikrotik wan public ip?
Ответитьgreat & tq 🥲
ОтветитьIs it accessible for telnet?
ОтветитьUse uptime Kuma instead , much easy ,fancy and can alert you.
ОтветитьComo obtener un valor en excel que mando por ip desde una balanza? Gracias
Ответитьhow to used ....
ОтветитьThank you sir, you are the universal god of excel, for being generous sir.
Ответитьgreat videos, please can you connect on wifi network with link bat command
ОтветитьGreat!
Ответить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
ОтветитьGreat 👍
ОтветитьAwesome. Thank you!!!!!!
ОтветитьAbomination....monitoring with a macro anabled excel shouldn't exist in the first place
ОтветитьI get the error message that there is a problem with this formula. He wants to calculate because the cell starts with "="
ОтветитьHay quá anh ơi
Ответить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
Ответить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 😂
ОтветитьObrigado por re-upload este vídeo, o anterior eu não encontrava mais🙇🏻♂️♥️
Ответить234
ОтветитьIs it monitor Mac address, serial number of the network device also?
ОтветитьHow about in Google sheet?
ОтветитьHi Boss
in Which language this Ping script has been written ?
Thanks
Great! My friend.
ОтветитьHow can I contact you by email?
ОтветитьThanks.. How we could extend this feature to create a log of every minute of status and latency?
ОтветитьWant more videos on excel ❤
ОтветитьExcelent vídeo. Congratulations.
ОтветитьWow, I had no idea that Excel could be used for programming. 👏👏
Ответитьhow to hack wiFi in Android phone
Ответить