dottbin
2014-09-17, 05:37 PM
Hi all,
I connected with DB Visualizer to OMC Nokia where it is defined new Nokia RNC multicontroller.
I try to extract with a query the ADJS,ADJI and ADJG. The cells of BTS belonging to this RNC are defined in :
OC_ID
1063 EXTERNAL_CELL_COLLECTION_OBJECT_CLASS EXCC Collection of External Cells
1064 EXTERNAL_WCDMA_CELL_OBJECT_CLASS EWCE External WCDMA Cell
Query is:
SELECT distinct
cell.*
FROM
UMA.UTP_COMMON_OBJECTS cell,UMA.UTP_COMMON_OBJECTS wbts
where cell.co_name = 'cell name'
and cell.co_parent_gid=wbts.co_gid
and cell.co_state=0
and cell.co_oc_id=1064
and wbts.co_oc_id=1063
but I don't to know how to find all adj for this cell.
Can someone help me?
thanks in advanced
dottBin
I connected with DB Visualizer to OMC Nokia where it is defined new Nokia RNC multicontroller.
I try to extract with a query the ADJS,ADJI and ADJG. The cells of BTS belonging to this RNC are defined in :
OC_ID
1063 EXTERNAL_CELL_COLLECTION_OBJECT_CLASS EXCC Collection of External Cells
1064 EXTERNAL_WCDMA_CELL_OBJECT_CLASS EWCE External WCDMA Cell
Query is:
SELECT distinct
cell.*
FROM
UMA.UTP_COMMON_OBJECTS cell,UMA.UTP_COMMON_OBJECTS wbts
where cell.co_name = 'cell name'
and cell.co_parent_gid=wbts.co_gid
and cell.co_state=0
and cell.co_oc_id=1064
and wbts.co_oc_id=1063
but I don't to know how to find all adj for this cell.
Can someone help me?
thanks in advanced
dottBin