Home > May 2012

May 2012

Object Class In NetAct Database

Wednesday, May 2 Category : 0

What is Object Class In NetAct Database?

In OSS NetAct Database Oracle Server there is Objects Tables which is listed all Objects within the Network Element, for example BSC, BCF, BTS, HOC, POC, ADCE, ADJW, RNC, WBTS, WCEL, FMCG, FMCS, FMCI, ADJS, ADJG, ADJI,etc.

So what is Object Class?, simply defined object class is group which is having similar level. So for every Object Class its having same Object Class ID, example BSC is having Object Class = 3, RNC is 811, WBTS is 812 and WCEL is 813.

In simple oracle script, this is how to get the BSC List using Object Class Query:
SELECT * FROM OBJECTS WHERE OBJECT_CLASS=3;

Sample Oracle SQL script to get the RNC List from NetAct Database:
SELECT * FROM OBJECTS WHERE OBJECT_CLASS=811;

Sample Oracle SQL script to get the WBTS List from NetAct Database:
SELECT * FROM OBJECTS WHERE OBJECT_CLASS=812;

Sample Oracle SQL script to get the WCEL List from NetAct Database:
SELECT * FROM OBJECTS WHERE OBJECT_CLASS=813;

So its clear that using Object_Class ID we can filter some Objects within Network Element directly from NetAct Database Oracle Server.

Free Nokia BSC RNC MML Macro Converter Online
http://www.oss-tools.com


Free NSN FlexiBSC/RNC MML Macro

Powered by Blogger.

Popular Posts

Recent Posts

Labels