Find RAN dependencies

These queries retrieve the details of RAN entities that are dependent upon other RAN entities.

Example: find all cells managed by a given base station

This query retrieves the details of all cells that are managed by a given base station.

select e1.entityId cellEntityId,
 e1.entityName cellName,
 rc.cellid,
 e2.entityId btsEntityId,
 e2.entityName BTSname,
 rbs.baseStationId 
from ncim.entityData e1
INNER JOIN ncim.rangsmcell rc ON rc.entityId = e1.entityId
INNER JOIN ncim.dependency dep ON dep.dependentEntityId = e1.entityId
INNER JOIN ncim.entityData e2 ON e2.entityId = dep.independentEntityId
INNER JOIN ncim.ranBaseStation rbs ON rbs.entityId = e2.entityId
WHERE (e2.entityName = base_station_name)

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: The entity ID of the cell, represented by `e1.entityId`. The name of the cell, represented by `e1.entityName` The ID of the cell, represented by `rc.cellid` The entity ID of the base station, represented by `e2.entityId` The name of the base station, represented by `e2.entityName` The identifying string of the base station, represented by `rbs.baseStationId`
7	Use the `entityData` table as the driving table for this query.
8	Limit the results of the query to RAN GSM cells. Do this by joining the ranGSMCell table to the `entityData` table using the `entityId` field.
9-11	Limit the results of the query to cells that have dependencies listed on entities that are RAN base stations.
12	Limit the results of the query to cells managed by the base station known as `base_station_name`.

Similar queries

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

Example: find all cells managed by a given Node B entity

This query retrieves the details of all cells managed by a given Node B entity.

select e1.entityId cellEntityId,
 e1.entityName cellName, rc.cellid,
 e2.entityId nodeBEntityId,
 e2.entityName nodeBName,
 rnb.nodeBId
from ncim.entityData e1
INNER JOIN ncim.ranutrancell rc ON rc.entityId = e1.entityId
INNER JOIN ncim.dependency dep ON dep.dependentEntityId = e1.entityId
INNER JOIN ncim.entityData e2 ON e2.entityId = dep.independentEntityId
INNER JOIN ncim.ranNodeB rnb ON rnb.entityId = e2.entityId
WHERE
(
	e2.entityName = node_b_name
)

Example: find all base stations managed by a given base station controller

This query retrieves the details of all base stations managed by a given base station controller.

select e1.entityId btsEntityId,
 e1.entityName btsName,
 rbs.basestationid,
 e2.entityId bscEntityId,
 e2.entityName bscName,
 rbsc.baseStationControllerId 
from ncim.entityData e1
INNER JOIN ncim.ranBaseStation rbs ON rbs.entityId = e1.entityId
INNER JOIN ncim.dependency d ON d.dependentEntityId = e1.entityId
INNER JOIN ncim.entityData e2 ON e2.entityId = d.independentEntityId
INNER JOIN ncim.ranBaseStationController rbsc ON rbsc.entityId = e2.entityId
WHERE
(
	e2.entityName = base_station_controller_name
);

Example: find all Node B entities managed by a given radio network controller

This query retrieves the details of all Node B entities managed by a given radio network controller.

select e1.entityId nodeBEntityId,
 e1.entityName nodeBName,
 rnb.nodeBid, 
 e2.entityId rncEntityId,
 e2.entityName rncName,
 rrnc.rncId 
from ncim.entityData e1
INNER JOIN ncim.ranNodeB rnb ON rnb.entityId = e1.entityId
INNER JOIN ncim.dependency d ON d.dependentEntityId = e1.entityId
INNER JOIN ncim.entityData e2 ON e2.entityId = d.independentEntityId
INNER JOIN ncim.ranRadioNetworkController rrnc ON rrnc.entityId = e2.entityId
WHERE
(
	e2.entityName = radio_network_controller_name
);