Netmiko_Sessions/tool5.py at master · labeveryday/Netmiko_Sessions · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
from netmiko import ConnectHandler
from openpyxl import load_workbook
import getpass
import time
import datetime

"""
5. This script updates the enable secret on multiple Cisco devices
   Appends results with hostname, ip, serial, and time to device_update.xlsx
"""


ip_file = open('ipaddress.txt')

file_location = ('device_update.xlsx')
workbook = load_workbook(file_location)
sheet = workbook.worksheets[0]

ip = ()
username = input('Enter username: ')
password = getpass.getpass()
device_type = 'cisco_ios'
now = datetime.datetime.now()

for i in ip_file:
    ip = i.strip()
    net_connect = ConnectHandler(ip=ip, device_type=device_type, username=username, password=password)
    print('Connecting to %s' % ip)
    time.sleep(1)
    device_hostname = net_connect.send_command('show run | include hostname')
    hostname = device_hostname[9:]
    device_serial = net_connect.send_command('show inventory | include PID')
    time.sleep(1)
    net_connect.write_channel('config t \n')
    time.sleep(1)
    net_connect.write_channel('enable secret NewCiscoPassword2019 \n')
    time.sleep(1)
    net_connect.write_channel('exit \n')
    time.sleep(1)
    net_connect.write_channel('wri mem \n')
    time.sleep(2)
    show_session = net_connect.read_channel()
    print(show_session)
    time.sleep(1)

    clock = now.strftime('%m-%d-%Y %H:%M')
    output = [hostname, ip, device_serial, clock]
    sheet.append(output)

    workbook.save(file_location)

input('##### Enable Secret Update Successfully #####\n Press Enter to Exit')