Here are ping functions in other languages. For Excel based, follow the tutorial from here.
ping
<?php //Define the variables$host = '127.0.0.1'; // update ip-address here$port = 80; // update port number here$waitTimeoutInSeconds = 1;$output = '';$status = 'IDLE'; //Setup timezone and date//https://www.php.net/manual/en/timezonesdate_default_timezone_set("Europe/Berlin");$date = date('Y-m-d H:i:s'); //Ping test using fsockopen//fsockopen(): Initiates a socket connection to the resource specified by hostname.//@: disables the Warning$fp = @fsockopen($host, $port, $errCode, $errStr, $waitTimeoutInSeconds);if ($fp) { $status = 'ONLINE';} else { $status = 'OFFLINE';} //Write the output to a fileif (!file_exists("output.md")) { $output = "| Host | Port | Status | Performed at |\r\n"; $output .= "| -------------- | ---- | ------ | ------------------- |\r\n";}$output .= sprintf("| %s | %s | %s | %s |\r\n", $host, $port, $status, $date ); file_put_contents("output.md", $output, FILE_APPEND); //save the file and execute in terminal
Copy the contents to a file index.js
index.js
const exec = require("child_process").exec;const fs = require("fs"); const hosts = ["192.168.91.175", "www.google.de", "127.0.0.1"];const replyFromLocale = "Reply from"; const promises = []; hosts.forEach(host => { promises.push(new Promise((resolve, reject) => { exec(`ping -n 1 -w 1000 ${host}`, (err, stdout, stderr) => { // successfull response: Reply from 142.250.186.78: bytes=32 time=10ms TTL=128 // unsuccessfull: Reply from 192.168.1.3: Destination host unreachable // host unreachable: Ping request could not find host let status = "offline"; let output = stdout.toString(); let replyFromIndex = output.indexOf(replyFromLocale); if (replyFromIndex > 0 && output.substring(replyFromIndex).toUpperCase().indexOf("BYTES") > 0) { status = "online" } resolve(new Date().toISOString() + " " + host + " " + status) }) }))}) Promise.all(promises).then((results) => { fs.writeFile("ping-results.txt", results.join("\n"), (err) => { if (err) { console.log(err); } })})
Execute the script using the command
node index.js