DevAsc – Python Script To Collect Show Commands Output

A colleague needed to connect to several Cisco devices, run some show commands, and save the output. I decided it would be good to practice my Python skills so I coded something together.

Why didn’t do you do this in Ansible, Nornir, or other tool of choice? Because the goal was to learn Python, not minimize amount of work to solve the task.

This work was highly inspired by others such as Debi, John, and wouldn’t be possible without the work from Kirk. Also thanks to Patrick, and Nick for giving me pointers on the code.

From a high level, the script will perform the following tasks:

• Read commands from a text file “commands.txt”
• Read devices from a text file “devices.txt”
• Ask the user for credentials
• Log in to the devices
• Perform show commands
• Save the output to a text file per device

In order to perform the tasks, the script relies on several modules:

Colorama – Used to color code terminal output
Netmiko – Used to setup SSH connection to device and parse the output
Datetime – Used to create a timestamp
Getpass – To get password from user without displaying it to the terminal

The script starts by importing these modules:

# Colorama used for coloring of terminal
from colorama import Fore, Back, init
# Netmiko used to connect to devices
from netmiko import ConnectHandler
from netmiko.ssh_exception import NetMikoTimeoutException, NetMikoAuthenticationException
# Datetime used to timestamp files
import datetime
# Getpass for asking for password from user
import getpass

The first thing we do is to get a timestamp. The timestamp is in ISO format. We don’t want microseconds so

# Get current time in ISO format
time_now = datetime.datetime.now().isoformat(timespec="seconds")

Running this from the REPL produces an output like this:

>>> time_now = datetime.datetime.now().isoformat(timespec="seconds")
>>> time_now
'2020-07-01T10:24:23'
>>> 

The next thing we do is to initialize Colorama. We set

# Initialize colorama and reset style by default
init(autoreset=True)

Following that, there is a function that opens a file, with the name

def read_from_filename(filename):
    """Returns all lines from filename as a list

    Parameters:
    filename - name of the file to read

    Returns:
    list: lines
    """
    with open(filename) as f:
        lines = f.read().splitlines()
        return lines

The next part is a function that gets the credentials. It asks the user for a

def get_credentials():
    """Get username and password from user
    
    Parameters:

    Returns:
    str: username
    str: password
    
    """
    username = input("Enter username: ")
    password = getpass.getpass()
    return username, password

Finally, we have the function that actually does all of the work connecting, entering commands, and saving the output. This is where most of the code is so I’ll break the code down into smaller parts. The function takes 4 arguments:

• devices_lines
  devices_lines – The devices to connect to in the form of a list. We get this list when running
  read_from_filename()
  read_from_filename()
• config_lines
  config_lines – The commands to use on the devices. This is also provided after running
  read_from_filename()
  read_from_filename()
• username
  username – The username. This is provided after running
  get_credentials()
  get_credentials()
• password
  password – The password. This is provided after running
  get_credentials()
  get_credentials()

def connect_and_send(devices_lines, config_lines, username, password):
    """Connect, run show commands, and save the output
    
    Parameters:
    devices_lines - devices to connect to, gathered from read_devices()
    config_lines - commands to run, gathered from read_commands()
    username - username for logging in to device, gathered from get_credentials()
    password - password for logging in to device, gathered from get_credentials()

    Returns:

    """

We want to iterate over the list

• device_type
  device_type – Set to
  cisco_ios
  cisco_ios because only Cisco devices in this demo
• ip
  ip – The IP of the device to connect to. We get this from iterating over the IP addresses in
  devices_lines
  devices_lines
• username
  username – The username used to connect 
• password
  password – The password used to connect

for ip in devices_lines:
        device = { 
            "device_type": "cisco_ios",
            "ip": ip,
            "username": username,
            "password": password
        }

Then follows a

try:
            print(Fore.MAGENTA + "=" * 70)
            print(Fore.CYAN + "" * 15 + " Connecting to Device: " + ip)
            print(Fore.MAGENTA + "=" * 70)

The next step is to setup the actual connection using Netmiko. We provide the dictionary

net_connect = ConnectHandler(**device)

Then there’s a bunch of printing to the terminal, indicating what device we are connected to with

print(Fore.MAGENTA + "~" * 70)
print(Fore.CYAN + "" * 15 + " Now connected to Device: " + ip)
print(Fore.CYAN + "" * 15 + " Sending commands ")
print(Fore.CYAN + "" * 15 + " Saving output to: " + ip +"_" + time_now)
print(Fore.MAGENTA + "~" * 70)

We need a file to save output to. We open the file, run all the commands in

# Open file to write to
            filename = ip + "_" + time_now + ".txt"
            with open(filename, "w") as f:
                for command in config_lines:
                    f.write("=" * 20)
                    f.write(command)
                    f.write("=" * (80 - len(command)))
                    f.write("\n" * 2)
                    cmd_output = net_connect.send_command(command)
                    f.write(cmd_output + "\n" *2)

We also have a few Netmiko exceptions that we are looking for,

except (NetMikoTimeoutException, NetMikoAuthenticationException) as e:
            print(Fore.RED + "~" * 15 + str(e) + "~" * 15)

Finally, here is the code that executes the functions. We run

if __name__ == "__main__":
    # Get all commands
    config_lines = read_from_filename("commands.txt")
    # Get all devices
    devices_lines = read_from_filename("devices.txt")
    # Get credentials
    username, password = get_credentials()
    # Connect and save
    connect_and_send(devices_lines, config_lines, username, password)

Running the code, it looks like this:

The result looks like this:

daniel@devasc:~/DevAsc$ cat 192.168.255.186_2020-07-01T15\:19\:43.txt 
====================show ip arp=====================================================================

Protocol  Address          Age (min)  Hardware Addr   Type   Interface
Internet  192.168.255.1           0   000c.2957.2663  ARPA   GigabitEthernet1
Internet  192.168.255.11        140   0050.56b7.217a  ARPA   GigabitEthernet1
Internet  192.168.255.185         3   0050.56b7.5e33  ARPA   GigabitEthernet1
Internet  192.168.255.186         -   0050.56b7.69ff  ARPA   GigabitEthernet1

====================show mac address-table | exclude STATIC=========================================

^
% Invalid input detected at '^' marker.


====================show cdp neighbors detail=======================================================

Total cdp entries displayed : 0

====================show ip route===================================================================

Codes: L - local, C - connected, S - static, R - RIP, M - mobile, B - BGP
       D - EIGRP, EX - EIGRP external, O - OSPF, IA - OSPF inter area 
       N1 - OSPF NSSA external type 1, N2 - OSPF NSSA external type 2
       E1 - OSPF external type 1, E2 - OSPF external type 2
       i - IS-IS, su - IS-IS summary, L1 - IS-IS level-1, L2 - IS-IS level-2
       ia - IS-IS inter area, * - candidate default, U - per-user static route
       o - ODR, P - periodic downloaded static route, H - NHRP, l - LISP
       a - application route
       + - replicated route, % - next hop override, p - overrides from PfR

Gateway of last resort is 192.168.255.1 to network 0.0.0.0

S*    0.0.0.0/0 [254/0] via 192.168.255.1
      192.168.255.0/24 is variably subnetted, 2 subnets, 2 masks
C        192.168.255.0/24 is directly connected, GigabitEthernet1
L        192.168.255.186/32 is directly connected, GigabitEthernet1

daniel@devasc:~/DevAsc$ 

Code is available at Github.

I hope this example was useful for learning Python. Use the code as you wish but I take no responsibility for your network