danicam001
New Member
- Joined
- Dec 10, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello Dear team
Hi everyone, this is my first post! I'm working on figuring out the hops in an internal traceroute using a list of known IPs. I'm running a traceroute on my Windows computer, saving it to a file, and then opening it in Excel.
I want to find the hops I already know. For example, in this traceroute, some hops are part of my network, so I can recognize them easily.
Normal Traceroute
Tracing route to 10.142.111.1 over a maximum of 8 hops
1 5 ms * 7 ms 10.111.111.10
2 5 ms 5 ms 5 ms 10.111.113.20
3 5 ms 5 ms 6 ms 192.16.100.103
4 8 ms 5 ms 4 ms 192.17.143.212
5 * * * Request timed out.
6 11 ms 22 ms 9 ms 192.142.120.1
Trace complete.
What I want to achieve is to have a list of all IPs that I know, either in another sheet or the same one. For those IPs that I recognize, place the corresponding names on the right side of the tracert, like this:
List of known Ips:
10.111.113.20 - router123
192.16.100.103 - router456
192.17.143.212 - router777
192.142.120.1 - Core1
etc
The final result I would like to be like this:
Tracing route to 10.142.111.1 over a maximum of 8 hops
Column A Column B
1 5 ms * 7 ms 10.111.111.10
2 5 ms 5 ms 5 ms 10.111.113.20 router123
3 5 ms 5 ms 6 ms 192.16.100.103 router456
4 8 ms 5 ms 4 ms 192.17.143.212 router777
5 * * * Request timed out.
6 11 ms 22 ms 9 ms 192.142.120.1 Core1
Trace complete.
Thank you, Dan
Hi everyone, this is my first post! I'm working on figuring out the hops in an internal traceroute using a list of known IPs. I'm running a traceroute on my Windows computer, saving it to a file, and then opening it in Excel.
I want to find the hops I already know. For example, in this traceroute, some hops are part of my network, so I can recognize them easily.
Normal Traceroute
Tracing route to 10.142.111.1 over a maximum of 8 hops
1 5 ms * 7 ms 10.111.111.10
2 5 ms 5 ms 5 ms 10.111.113.20
3 5 ms 5 ms 6 ms 192.16.100.103
4 8 ms 5 ms 4 ms 192.17.143.212
5 * * * Request timed out.
6 11 ms 22 ms 9 ms 192.142.120.1
Trace complete.
What I want to achieve is to have a list of all IPs that I know, either in another sheet or the same one. For those IPs that I recognize, place the corresponding names on the right side of the tracert, like this:
List of known Ips:
10.111.113.20 - router123
192.16.100.103 - router456
192.17.143.212 - router777
192.142.120.1 - Core1
etc
The final result I would like to be like this:
Tracing route to 10.142.111.1 over a maximum of 8 hops
Column A Column B
1 5 ms * 7 ms 10.111.111.10
2 5 ms 5 ms 5 ms 10.111.113.20 router123
3 5 ms 5 ms 6 ms 192.16.100.103 router456
4 8 ms 5 ms 4 ms 192.17.143.212 router777
5 * * * Request timed out.
6 11 ms 22 ms 9 ms 192.142.120.1 Core1
Trace complete.
Thank you, Dan