Download python script here: cdp2csv_stdout
# This script takes the output of Cisco's "show cdp neighbors" and # converts it to a csv formatted output. # # Usage: # # This script assumes the devices name is located in the first part of # the filename. i.e. [device_name].[fqdn].[extension] # # There are two parts to this script; # 1) Load the cdp_nei file and parse through it. # Sometimes data is split in two lines, sometimes it's all on one. # So we loop through the file, find what we think is valuable, and # put all data for one neighbor on a single line. # 2) Loop through the lines of data, pull out the individual parts of # data elements, print in csv format. $cdp2csv_stdout.py -h usage: cdp2csv_stdout.py [-h] [-c] [-n LOCAL_DEV_NAME] [-dv DEBUG_LEVEL] filename This script converts the results of 'show cdp neighbor' and turns it into csv output. CSV data is sent to stdout, so redirect or pipe as needed. positional arguments: filename The name of the file which contains the output of 'show cdp neighbor' optional arguments: -h, --help show this help message and exit -c Seperate data elements by a comma (',') rather than a tab. Tab is default. -n LOCAL_DEV_NAME Set the local hostname. If this flag is NOT set we assume the first part of the filename is the local node name. -dv DEBUG_LEVEL Turn on debug verbosity level. '0' is off (default). This will invalidate the CSV output structure, but is useful for troubleshooting.