Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: Jason Friedman <jsf80238@gmail.com>
Newsgroups: comp.lang.python
Subject: Re: Python,ping,csv
Date: Mon, 11 Apr 2016 19:17:49 -0600
Lines: 54
Message-ID: <mailman.41.1460423871.15650.python-list@python.org>
References: <o1JNy.43731$pt.31548@tornado.fastwebnet.it> <CANy1k1h392HiXq-onCAFj1zJkK0Z31AXeR6fEtnf7fZ-5fHkaQ@mail.gmail.com> <mailman.0.1460259273.424.python-list@python.org> <L3KOy.43878$pt.32317@tornado.fastwebnet.it> <CANy1k1hEMDmkZaQugrbgWdY3ekv5EQocyUJ9pLzXFU-y8++r1A@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
In-Reply-To: <L3KOy.43878$pt.32317@tornado.fastwebnet.it>
Precedence: list
Xref: csiph.com comp.lang.python:106898

> I added a line.
> I would need to put the output into a csv file which contained the results
> of the hosts up and down.
> Can you help me?
>
>
> import subprocess
> from ipaddress import IPv4Network
> for address in IPv4Network('10.24.59.0/24').hosts():
>         a = str(address)
>         res = subprocess.call(['ping', '-c', '3', address])

"""Typical output from ping:

$ ping -c 3 10.2.2.2
PING 10.2.2.2 (10.2.2.2) 56(84) bytes of data.

--- 10.2.2.2 ping statistics ---
3 packets transmitted, 0 received, 100% packet loss, time 1999ms


$ ping -c 3 localhost
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.030 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.040 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.042 ms

--- localhost ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 1998ms
rtt min/avg/max/mdev = 0.030/0.037/0.042/0.007 ms
"""

import csv
import ipaddress
import re
import subprocess
import sys
NETWORK = "192.168.1.0"
MASK = "24"
with open('some.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(("Address", "% success"))
    for address in ipaddress.IPv4Network('%s/%s' % (NETWORK, MASK)).hosts():
        print("Pinging %s ..." % address, file=sys.stderr)
        command = "ping -c 3 %s" % address
        output = subprocess.getoutput(command)
        match = re.search(r"(\d+)% packet loss", output)
        if match:
            percent_lost = match.group(1)
            writer.writerow((str(address), 100 - int(percent_lost)))
        else:
            # If we reach this point the ping command output
            # was not in the expected output format
            writer.writerow((str(address), ""))