網路裝置自動化組態與管理

from jinja2 import Template

# 定義Jinja2範本
template = Template('''
interface {{ interface_name }}
  ip address {{ ip_address }} {{ subnet_mask }}
''')

# 渲染範本
interface_name = 'GigabitEthernet0/0'
ip_address = '192.168.1.1'
subnet_mask = '255.255.255.0'
rendered_template = template.render(interface_name=interface_name, ip_address=ip_address, subnet_mask=subnet_mask)

print(rendered_template)

from napalm import get_network_driver

# 連線到裝置
driver = get_network_driver('ios')
device = driver('192.168.1.1', 'username', 'password')
device.open()

# 組態裝置
config = '''
interface GigabitEthernet0/0
  ip address 192.168.1.1 255.255.255.0
'''
device.load_merge_candidate(config=config)
device.commit_config()

# 關閉連線
device.close()

from nornir import InitNornir

# 初始化Nornir
nr = InitNornir(config_file='config.yaml')

# 組態裝置
def configure_devices(task):
    # 組態裝置的任務
    config = '''
    interface GigabitEthernet0/0
      ip address 192.168.1.1 255.255.255.0
    '''
    task.run(task=napalm_configure, config=config)

nr.run(task=configure_devices)

from netmiko import Netmiko

ip_list = ["10.10.10.1", "10.10.10.2", "10.10.10.3", "10.10.10.4"]

for ip in ip_list:
    device = {
        "host": f"{ip}",
        "username": "admin",
        "password": "cisco",
        "device_type": "cisco_ios",
        "global_delay_factor": 0.1
    }
    try:
        print(f"\n
---
Try to Login: {device['host']} 
---
\n")
        net_connect = Netmiko(**device)
        output = net_connect.send_command("show interface description")
        print(output)
    except:
        print(f"***Cannot login to {device['host']}")

from netmiko import Netmiko
import re

with open("host_info.txt") as r:
    host = r.read()
ip_list = re.split("\n", host)

for ip in ip_list:
    device = {
        "host": f"{ip}",
        "username": "admin",
        "password": "cisco",
        "device_type": "cisco_ios",
        "global_delay_factor": 0.1
    }
    try:
        print(f"\n
---
Try to Login: {device['host']} 
---
\n")
        net_connect = Netmiko(**device)
        output = net_connect.send_command("show interface description")
        print(output)
    except:
        print(f"***Cannot login to {device['host']}")

# 使用 xlwings 模組讀取 Excel 檔案中的資料
import xlwings as xw

# 開啟 Excel 檔案
wb = xw.Book('device_config.xlsx')

# 取得工作表
sheet = wb.sheets['Sheet1']

# 讀取資料
for i in range(1, 4):
    config = sheet.range(f'A1:A14').value
    device = {
        "host": sheet.range(f'A{i+1}').value,
        "username": "admin",
        "password": "cisco",
        "device_type": "cisco_ios",
        "global_delay_factor": 0.1
    }
    try:
        print(f"\n
---
Try to Login: {device['host']} 
---
\n")
        net_connect = Netmiko(**device)
        output = net_connect.send_config_set(config)
        print(output)
    except:
        print(f"***Cannot login to {device['host']}")

import xlwings
from netmiko import Netmiko

# 開啟Excel檔案
excel = xlwings.Book("Config_file.xlsx").sheets['Sheet1']

# 定義裝置IP地址和對應的Excel列
column = ["A","B","C"]
host = ["10.10.10.1", "10.10.10.2", "10.10.10.3"]

for x, ip in zip(column, host):
    print(f"
---
Connected to {ip}
---
")
    # 從Excel中讀取組態資訊
    configuration = excel.range(f"{x}1:{x}14").value
    
    # 定義裝置連線資訊
    device = {"host": ip, "username": "admin", "password": "cisco", "device_type": "cisco_ios"}
    
    # 連線裝置並下發組態
    net_connect = Netmiko(**device)
    net_connect.send_config_set(configuration)

from netmiko import Netmiko

# 讀取裝置IP地址列表
with open("host_info.txt") as r:
    host = r.read()
ip_list = host.split("\n")

for ip in ip_list:
    # 定義裝置連線資訊
    device = {"host": ip, "username": "admin", "password": "cisco", "device_type": "cisco_ios"}
    
    try:
        print(f"\n
---
Try to Login: {ip} 
---
\n")
        net_connect = Netmiko(**device)
        # 從檔案中讀取組態命令並下發
        output = net_connect.send_config_from_file("command_list.txt")
        print(output)
    except:
        print(f"***Cannot login to {ip}")

# 定義舊組態和新組態
command_change = [
    """interface GigabitEthernet0/0
description TEST""",
    "interface GigabitEthernet0/0",
    """interface GigabitEthernet0/1
no ip address
shutdown""",
    """interface GigabitEthernet0/1
ip address 192.168.10.10 255.255.255.0"""
]

# 讀取舊組態檔案
with open("old_config.txt") as old_config:
    new_config = old_config.read()

# 替換組態內容
item_count = len(command_change)
for x in range(0, item_count, 2):
    new_config = new_config.replace(command_change[x], command_change[x + 1])

# 儲存新組態檔案
with open("new_config.txt", "w") as new:
    new.write(new_config)