List supporting routers for a Traffic Engineered tunnel
These queries show which routers and services support a particular tunnel.
Example: which router and service support a particular tunnel
1] SELECT eHost.entityName as HostingRouter, eServ.entityName as TunnelService, eTun.entityName as TunnelName
2] FROM entityData eTun
3] INNER JOIN contains c ON c.containedEntityId = eTun.entityId
4] INNER JOIN entityData eServ ON eServ.entityId = c.containingEntityId
5] INNER JOIN hostedService h ON h.hostedEntityId = eServ.entityId
6] INNER JOIN entityData eHost ON eHost.entityId = h.hostingEntityId
7] WHERE eTun.entityName = '172.20.1.7_MPLS_TE_Tunnel_Idx_50_Inst_12'; Results
The following table provides an example of part of the result set for this query.
HostingRouter |
TunnelService |
TunnelName |
|---|---|---|
|
|
|
Example: show all routers in a tunnel path
1] SELECT DISTINCT eMain.entityName
2] FROM collects c
3] INNER JOIN entityData eTun ON eTun.entityId = c.collectingEntityId
4] INNER JOIN entityData eInt ON eInt.entityId = c.collectedEntityId
5] INNER JOIN entityData eMain ON eMain.entityId = eInt.mainNodeEntityId
6] WHERE eTun.entityName = '172.20.1.7_MPLS_TE_Tunnel_Idx_50_Inst_12'; Results
The following table provides an example of part of the result set for this query.
entityName |
|---|
|
|
|