Identify all connections between routers
This query identifies all connections between routers. These types of connections are also called Layer 3 router links. Each of these connections also represents a connection between two subnets.
You can use similar queries to determine the type of connection between two devices. You can determine whether a connection falls into any of the following types:
- Layer 2 connection
- Layer 3 router links
This refers to connections between routers, and hence, between subnets, and is the example provided in this query.
- Psuedowire connection
Use the topologyLinks table to identify which connections belong to a
specific type of topology. This table lists all the connections in the database
and specifies the identifier of a topology type entity from the
entityData table.
Example
1] SELECT a.entityName Connected_Entity,
2] z.entityName Connected_Entity
3] FROM topologyLinks t
4] INNER JOIN entityData topo ON topo.entityId = t.entityId
5] INNER JOIN connects c ON c.connectionId = t.connectionId
6] INNER JOIN entityData a ON a.entityId = c.aEndEntityId
7] INNER JOIN entityData z ON z.entityId = c.zEndEntityId
8] WHERE topo.entityType = 73Description
The table below describes this query.
|
Line numbers |
Description |
|---|---|
|
1-2 |
Specify the data to show in the results, as follows:
|
|
3 |
Use the |
|
4 |
Identify all the types of topology listed in the
|
|
5 |
Extract the connection data for each connection. Do this by joining the
|
|
6-7 |
Extract entity details for each of the interfaces at either end of the connection. Do this by joining the |
|
8 |
Limit the results to connections within layer 3 router links only. This limits the results to connections between routers, and hence, between subnets. |
Results
The table below shows the results of the query.
|
Connected entity |
Connected entity |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|