01-02-2003 07:12 AM - edited 03-02-2019 03:53 AM
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.
01-02-2003 07:24 AM
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:
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
01-02-2003 08:57 AM
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.
01-02-2003 09:02 AM
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.
01-02-2003 11:07 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide