Use Openpyxl library to import the basic information of the network device into the asset table, logging in the network device through Netmiko library and automatically execute the CLI commands, Collects and saves the displayed information into an customized folder, the file Name as timestamp or as CLI command，use the Paramiko library to SFTP download the configuration file from the network device and save it ,After logging in successfully , compress all of the LOG that we need as a single zip file and send e-mail to the operation and maintenance staff automatically (netmiko supports multi-vendor , including virtual network environments and real physical network environments). By the way , EVE-NG platform is an clientless multivendor network emulation software . with EVE-NG , you are able to construct virtual network environments .including CISCO ,Juniper and other network vendor.
| 1 | Define the asset table, set up the basic connection information of the network device in the Excel sheet, execute the CLI commands, etc. |
|---|---|
| 2 | Read basic information, device type, etc. from asset table (Excel sheet) via Python |
| 3 | Use Netmiko to establish an SSH connection to a network device |
| 4 | Execute the CLI commands obtained from the form within the network device. |
| 5 | Collects and saves the displayed information in date and command format to a customized folder. |
| 6 | Download target files (e.g. configuration files) via SMTP to be saved in the LOG folder |
| 7 | Compressed and packed LOG folder. |
| 8 | Realize log mail auto-push |
The Asset Sheet is used as a template to define the basic information of the network equipment, the Sheet name can be customized, the table width is A-I, and the name of the basic information of the network equipment is set within the header row 1, which can be customized but needs to be modified within the code to correspond to it.
Name the corresponding sheet according to device_type to set the inspection command. Title name comment, cmd_list can be customized, must be in the code change corresponding.
SSH.py is a connection test using netmiko.
connect.py contains openpyxl to read the asset table information, netmiko to connect to the network device, execute CLI commands and display the information back.
send_email.py contains SMTP to send emails automatically, you need to configure the SMTP server.
zip_file.py is the compression and packaging method.
requirements.txt is the development environment information.
Note: By combining the above scripts and writing the display information into the LOG folder, you can realize the network automation patrol, and directly use connect.py to meet the automation of connecting devices to write CLI commands and output display information.