Random quick and dirty scripts to help import data into netbox
This is a set of scripts that utilize napalm to query network devices, gather data, and import it into netbox.
I intended to clean these up but never got around to it. I take no responsbility if something goes wrong when you run them.
You need to change the driver manually to match your device type, such as junos, eos, ios. You can find a list of NAPALM driver names here.
You need to set the username and password for the devices manually in the script.
The script assumes there is a device created in Netbox already with the same exact name you supplied in the list of devices. You will need to be able to resolve those names, hardcode them in your hosts file if they don't already resolve.
If you use VRFs look at line 116 in combined.py, set the VRF you want properly or add more logic if needed. Remove that section if needed
In interfaces_import.py Juniper vlans get imported as just "vlan" and not vlan.247, etc. This works as expected in combined.py but not in interfaces_import.py
- Python3.5+
- napalm (pip3 install napalm)
This script queries your network device(s) using the napalm command get_interfaces. It strips out useless interfaces on Juniper devices and then imports the remaining ones into Netbox using the API. It has been tested on JunOS and EOS devices, but should work with any device that works with napalm.
This script queries your network device(s) using the napalm command get_interfaces_ip. It strips out useless interfaces on Juniper devices, removes the unit designation from them and then imports the remaining ones into Netbox using the API. It detects if an IP address is private or not and selects the appliance VRF using hardcoded IDs. It has been tested on JunOS and EOS devices, but should work with any device that works with napalm.
This script combines the two above scripts into one and uses functions which gives us some better error handling.
This script queries your network device(s) using the napalm command get_arp_table. It then looks up the each IP in Netbox, if no result is returned it will lookup the MAC address to see if it is assoicated with a virtual machine in Netbox, if that returns no results it will lookup the MAC to see if its assoicated with a device. No output is provided if the IP was found in Netbox. If the IP wasn't found in Netbox but the MAC was you'll see output. If nothing was found in Netbox you'll see output. This script was made to help audit ARP data against Netbox. Its not super fast but it works.
Example Output:
10.1.1.1 returned more than 1 result in Netbox, ignoring.
Couldn't find 10.100.42.40 (Vlan10, Port-Channel1) or 00:50:56:87:A2:89 (VMware, Inc.) in netbox
Couldn't find 10.100.42.42 (Vlan10, not learned) in netbox, but found 00:50:56:6D:E5:CD (VMware, Inc.) on ESXIHOST-1
- Better error handling
Combine both scripts- Detect device type