Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

How to export EIGRP tables and SHOW IP ROUTE information to Excel

Is there a convenient way to transfer the routing entries for IP (e.g., SHOW IP ROUTE 10.0.0.0 or SHOW IP ROUTE EIGRP) from a Cisco router to Microsoft Excel. I want to sort the routing entries by gateway or by subnet.

4 REPLIES
Silver

Re: How to export EIGRP tables and SHOW IP ROUTE information to

If the internal redirection (inc, begin, etc) is not enough for you to do your sorting you can either pull the routing tables via SNMP (ipRouteTable) or RCMD. SNMP polling of the routing table can cause CPU issues and RCMD is seen, by some, to be a security risk.

Here is a link containing some information about RCMD:

http://www.cisco.com/en/US/partner/products/sw/iosswrel/ps1839/products_feature_guide09186a0080087c7f.html

Running 12.1 or higher IOS you should be able to do something like this to see your routes in question.

show ip route eigrp | include

That may or may not be enough capability for you.

Hope this helps,

Don

Silver

Re: How to export EIGRP tables and SHOW IP ROUTE information to

cut & paste the routing table to Excel then do a data > text to Columns > fixed width > then you can move the bar to the place were you want the columns to be.

New Member

Re: How to export EIGRP tables and SHOW IP ROUTE information to

Unfortunately, this will not work because each octet can take 1-3 character positions (0-255). For example, 10.9.3.0 versus 192.168.3.67.

Silver

Re: How to export EIGRP tables and SHOW IP ROUTE information to

Unfortunately, there is no convenient solution to this problem. A practical solution follows:

1. Log the output of 'show ip route | inc D' to a file

2. Open the file in vi/notepad and replace all Ds and EX with spaces. Or you can do so in step 4 as well.

3. If not using Unix, FTP this file to a Linux/UNIX box.

4. Use sed substitute repeatedly to get rid of all prefix spaces before route entries, saving the resulting file with each repeat.

5. cat the file piped with sort.

You will have your routes sorted by subnet addresses.

Thanks.

1269
Views
0
Helpful
4
Replies
CreatePlease to create content