Scribd
Upload
9 views1 page

GSM Cell Stats SQL Query Analysis

This SQL query selects performance metrics from the CELLSTATS_60 table for multiple NEs for a one hour period on May 16, 2012. It retrieves fields like NE, site ID, cell congestion, call failures, traffic volumes, and throughput. The query filters for specific NEs.

Uploaded by

richnett
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
9 views1 page

GSM Cell Stats SQL Query Analysis

This SQL query selects performance metrics from the CELLSTATS_60 table for multiple NEs for a one hour period on May 16, 2012. It retrieves fields like NE, site ID, cell congestion, call failures, traffic volumes, and throughput. The query filters for specific NEs.

Uploaded by

richnett
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

SELECT NE, sdate,SITEID,SITENAME,CELL,PCCONG,pcong2,PCFAIL,

erlang,pttch,CSSR_1,hosr,Serlang,Erlang_ul,TBFDLEGPRS,TBGEGDATA,EDLIPTHRPUT
FROM ericsson_GSM.CELLSTATS_60
WHERE SDATE BETWEEN TO_DATE('16-may-2012 00:00:00','DD-MON-YYYY HH24:MI:SS')
AND TO_DATE('16-may-2012 23:59:59','DD-MON-YYYY HH24:MI:SS')
--and ne in ('BNBSC1', 'BNBSC2','BNBSC4', 'BNBSC5','BNHBSC2','BNBSC6')
--and ne in ('IBHBSC11','IBHBSC12','IBHBSC13')
and ne in ('BNBSC1', 'BNBSC2','BNBSC4',
'BNBSC5','IBHBSC1','IBHBSC2','IBHBSC3', 'IBHBSC4','IBHBSC5',
'IBHBSC8', 'IBHBSC9', 'BNBSC6', 'IBHBSC10',
'IBHBSC11','IBHBSC12','IBHBSC13','IBHBSC14','IBHBSC15','IBHBSC16')
--and cssr<95
--and pccong>0.2

FACTS
Service Manager-----Database------execute SQL.

SELECT NE, sdate,SITEID,SITENAME,CELL,PCCONG,PCONG,PCFAIL,


erlang,pttch,CSSR_1,hosr,Serlang,AVE_EDGE_THRUPUT,TRAFFIC_EDGE_DL
FROM huawei_GSM.CELLSTATS_60
WHERE SDATE BETWEEN TO_DATE('7-june-2012 19:00:00','DD-MON-YYYY
HH24:MI:SS')
AND TO_DATE('7-june-2012 19:59:59','DD-MON-YYYY HH24:MI:SS')
--and ne in ('BNBSC1', 'BNBSC2','BNBSC4', 'BNBSC5','BNHBSC2','BNBSC6')
and ne in ('BNBSC1', 'BNBSC2','BNBSC4',
'BNBSC5','BNHBSC2','IBHBSC1','IBHBSC2','IBHBSC3', 'IBHBSC4','IBHBSC5',
'IBHBSC8', 'IBHBSC9', 'BNBSC6', 'IBHBSC10',
'IBHBSC11','IBHBSC12','IBHBSC13','IBHBSC14','IBHBSC15','IBHBSC16')
--and cssr<95
--and pccong>0.2

You might also like