Retrieve RAN connectivity

These queries retrieve the details of entities that are connected to RAN entities.

Example: connectivity of a given base station

This query retrieves the connectivity of a given base station.

select e1.entityName BTSName,
 e2.entityName BTSConnectedName,
 e3.entityName ConnectedInt,
 e4.entityName ConnectedDevice,
 e4.entityType, ch4.className,
 et.entityName Topology

The table below describes this query.

Table 1. Description of the query
Line numbers	Description
1-6	Specify the data to show in the results, as follows: Name of the base station, represented by `as e1.entityName` Name of the connected base station, represented by `e2.entityName` Name of the connected interface, represented by `e3.entityName` Name of the connected device, represented by `e4.entityName` Class of the connected device, represented by `e4.entityType` Name of the connection, represented by `et.entityName`
7-15	Retrieve the data from the following tables: `entityData` `ranBaseStation` `connects` `topologyLinks` `chassis`
18	The entity name of the base station is `BaseStation10`.
20	Ensure that the entity is a base station.
22	Limit the results (connected devices) to entities that are main nodes.
24	Identify all the connections for the entities associated with the specified base station.
26	Extract the entity data for each neighboring entity.
28	Determine the connecting point on the other device for the connection. This is captured in `e3.entityId`.
30	Determine the layer in which the other connection is located. This is determined using the `topologyLinks` object.
32	Determine the `entityData` entry corresponding to the topology layer. This enables the query results to specify in which layer the connecting point on the other device is; for example, layer 1,or layer 2.
34	Determine the chassis that the connecting point is in.
36	Use the `UNION` statement to ensure that all connections are retrieved.
37-71	This is the same code as line 1-36 with the difference that here the specified device is considered to be the zend (see line 60) and the neighboring devices are all considered to be at the aend (see line 62).

Similar queries

The following example queries retrieve relevant data for different RAN relationships, using similar syntax to the above example.

Example: connectivity of a given Node B entity

This query retrieves the connectivity of a given Node B entity.

select e1.entityName AS NodeBName,
 e2.entityName AS NodeBConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType, ch4.className 
from ncim.entityData e1,
 ncim.ranNodeB rnb,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4, ncim.physicalChassis ch4
where
(
	e1.entityName = 'NodeB10'
	AND
	e1.entityId = rnb.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.aEndEntityId
	AND
	e3.entityId = c.zEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)
UNION
select e1.entityName AS NodeBName,
 e2.entityName AS NodeBConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType,
 ch4.className 
from ncim.entityData e1,
 ncim.ranNodeB rnb,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4,
 ncim.physicalChassis ch4
where
(
	e1.entityName = 'NodeB10'
	AND
	e1.entityId = rnb.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.zEndEntityId
	AND
	e3.entityId = c.aEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)

Example: connectivity of a given base station controller

This query retrieves the connectivity of a given base station controller.

select e1.entityName AS BSCName,
 e2.entityName AS BSCConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType,
 ch4.className 
from ncim.entityData e1,
 ncim.ranBaseStationController rbsc,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4,
 ncim.physicalChassis ch4
where
(
	e1.entityName = 'BaseStationController2'
	AND
	e1.entityId = rbsc.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.aEndEntityId
	AND
	e3.entityId = c.zEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)
UNION
select e1.entityName AS BSCName,
 e2.entityName AS BSCConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType, ch4.className 
from ncim.entityData e1,
 ncim.ranBaseStationController rbsc,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4,
 ncim.physicalChassis ch4
where
(
	e1.entityName = 'BaseStationController2'
	AND
	e1.entityId = rbsc.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.zEndEntityId
	AND
	e3.entityId = c.aEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)

Example: connectivity of a given radio network controller

This query retrieves the connectivity of a given radio network controller.

select e1.entityName AS RNCName,
 e2.entityName AS RNCConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType,
 ch4.className 
from ncim.entityData e1,
 ncim.ranRadioNetworkController rrnc,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4,
 ncim.physicalChassis ch4
where
(
	e1.entityName = 'radioNetworkController2'
	AND
	e1.entityId = rrnc.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.aEndEntityId
	AND
	e3.entityId = c.zEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)
UNION
select e1.entityName AS RNCName,
 e2.entityName AS RNCConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType,
 ch4.className 
from ncim.entityData e1,
 ncim.ranRadioNetworkController rrnc,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4,
 ncim.physicalChassis ch4
where
(
	e1.entityName = 'radioNetworkController2'
	AND
	e1.entityId = rrnc.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.zEndEntityId
	AND
	e3.entityId = c.aEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)

Example: connectivity of a given media gateway

This query retrieves the connectivity of a given media gateway.

select e1.entityName AS MGWName,
 e2.entityName AS MGWConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType,
 ch4.className 
from ncim.entityData e1,
 ncim.ranMediaGateway rmgw,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4,
 ncim.physicalChassis ch4
where
(
	e1.entityName = 'MediaGateway1'
	AND
	e1.entityId = rmgw.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.aEndEntityId
	AND
	e3.entityId = c.zEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)
UNION
select e1.entityName AS MGWName,
 e2.entityName AS MGWConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType,
 ch4.className 
from ncim.entityData e1,
 ncim.ranMediaGateway rmgw,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4,
 ncim.physicalChassis ch4
where
(
	e1.entityName = 'MediaGateway1'
	AND
	e1.entityId = rmgw.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.zEndEntityId
	AND
	e3.entityId = c.aEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)

Example: connectivity of a given serving GPRS support node

This query retrieves the connectivity of a given serving GPRS support node.

select e1.entityName AS SGSNName,
 e2.entityName AS SGSNConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType, ch4.className 
from ncim.entityData e1,
 ncim.ranSGSN rsgsn,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4,
 ncim.physicalChassis ch4
where
(
	e1.entityName = 'SGSN3'
	AND
	e1.entityId = rsgsn.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.aEndEntityId
	AND
	e3.entityId = c.zEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)
UNION
select e1.entityName AS SGSNName,
 e2.entityName AS SGSNConnectedName,
 e3.entityName AS ConnectedInt,
 e4.entityName AS ConnectedDevice,
 e4.entityType,
 ch4.className 
from ncim.entityData e1,
 ncim.ranSGSN rsgsn,
 ncim.entityData e2,
 ncim.entityData et,
 ncim.topologyLinks tl,
 ncim.connects c,
 ncim.entityData e3,
 ncim.entityData e4,
 ncim.physicalChassis ch4
where
(
	e1.entityName = 'SGSN3'
	AND
	e1.entityId = rsgsn.entityId
	AND
	e2.mainNodeEntityId = e1.entityId
	AND
	e2.entityId = c.zEndEntityId
	AND
	e3.entityId = c.aEndEntityId	
	AND
	c.connectionId = tl.connectionId
	AND
	tl.entityId = et.entityId
	AND
	e3.mainNodeEntityId = e4.entityId
	AND
	ch4.entityId = e4.entityId
)