PYTHON SCRIPT TO GENERATE SWITCH DETAILS

 

from netmiko import ConnectHandler

from netmiko.ssh_exception import NetMikoTimeoutException

from netmiko.ssh_exception import SSHException

from netmiko.ssh_exception import AuthenticationException

 

import re

 

#Here is the list of Cisco SWITCH/ROUTER IP addresses

 

ip_list = ["<Device_ip_address>","< Device_ip_address>","<Device_ip_address>"]

 

#List where information will be stored

 

devices = []

 

#Clearing the old data from the CSV file and writing the headers

f = open("<filename.csv>", "w+")

f.write("IP Address, Hostname, Uptime, Current_Version, Current_Image, Serial_Number, Device_Model, Device_Memory")

f.write("\n")

f.close()

 

#Clearing the old data from the CSV file and writing the headers

f = open("<filename.csv>", "w+")

f.write("IP Address, Status")

f.write("\n")

f.close()

#loop all ip addresses in ip_list

for ip in ip_list:

    cisco = {

    'device_type':'cisco_ios',

    'ip':ip,

    'username':'username',     #ssh username

    'password':'password',  #ssh password

    'secret': 'secret,   #ssh_enable_password

    'ssh_strict':False,  

    'fast_cli':False,

    }

 

 

    #handling exceptions errors

    try:

        net_connect = ConnectHandler(**cisco)

    except NetMikoTimeoutException:

        f = open("login_issues.csv", "a")

        f.write(ip + "," + "Device Unreachable/SSH not enabled")

        f.write("\n")

        f.close()

        continue

    except AuthenticationException:

        f = open("login_issues.csv", "a")

        f.write(ip + "," + "Authentication Failure")

        f.write("\n")

        f.close()

        continue

    except SSHException:

        f = open("login_issues.csv", "a")

        f.write(ip + "," + "SSH not enabled")

        f.write("\n")

        f.close()

        continue

    try:

        net_connect.enable()

    #handling exceptions errors        

    except ValueError:

        f = open("login_issues.csv", "a")

        f.write(ip + "," + "Could be SSH Enable Password issue")

        f.write("\n")

        f.close()

        continue

    # execute show version on router and save output to output object    

    sh_ver_output = net_connect.send_command('show version')  

    #finding hostname in output using regular expressions

    regex_hostname = re.compile(r'(\S+)\suptime')

    hostname = regex_hostname.findall(sh_ver_output)

    #finding uptime in output using regular expressions

    regex_uptime = re.compile(r'\S+\suptime\sis\s(.+)')

    uptime = regex_uptime.findall(sh_ver_output)

    uptime = str(uptime).replace(',' ,'').replace("'" ,"")

    uptime = str(uptime)[1:-1]  

 

 

    #finding version in output using regular expressions

    regex_version = re.compile(r'Cisco\sIOS\sSoftware.+Version\s([^,]+)')

    version = regex_version.findall(sh_ver_output)

 

    #finding serial in output using regular expressions

    regex_serial = re.compile(r'Processor\sboard\sID\s(\S+)')

    serial = regex_serial.findall(sh_ver_output)

 

    #finding ios image in output using regular expressions

    regex_ios = re.compile(r'System\simage\sfile\sis\s"([^ "]+)')

    ios = regex_ios.findall(sh_ver_output)

 

    #finding model in output using regular expressions

    regex_model = re.compile(r'[Cc]isco\s(\S+).*memory.')

    model = regex_model.findall(sh_ver_output)

    #append results to table [hostname,uptime,version,serial,ios,model]

    devices.append([ip, hostname[0], uptime, version[0], ios[0], serial[0], model[0]]

 

#print all results (for all SWITCH) on screen    

for i in devices:

    i = ", ".join(i)      

    f = open("<filename.csv>", "a")

    f.write(i)

    f.write("\n")

    f.close()

 

OUTPUT

Note: In excel/CSV format file will be generated as an output.