問題已開啟
(普通問題)
有哪位高手可以給我發(fā)一份取指標(biāo)的sql腳本?
有哪位高手可以給我發(fā)一份取指標(biāo)的sql腳本?
就是用數(shù)據(jù)庫軟件sqldbx從sybase中取指標(biāo)的sql腳本?愛立信的設(shè)備
就是用數(shù)據(jù)庫軟件sqldbx從sybase中取指標(biāo)的sql腳本?愛立信的設(shè)備
提問者: zhugeyingju 提問時(shí)間: 2011-09-03
• 移動(dòng)LTE日常網(wǎng)優(yōu)后臺(tái)考核哪些KIP指標(biāo) 2020-06-14
• 全業(yè)務(wù)BRAS設(shè)備需要關(guān)哪些性能指標(biāo)呢? 2020-02-22
• CQI指標(biāo) 是能說明SINR不好么? 2019-12-30
• 游戲交互時(shí)延怎么定義,游戲話單中怎么計(jì)算該指標(biāo) 2019-12-25
• 區(qū)塊鏈?zhǔn)菓?yīng)對資本五毒:造假、欺詐、炒作、權(quán)力尋租及流氓無賴的利器!只要在具體落實(shí)四中全會(huì)《決議》的13項(xiàng)堅(jiān)持與完善措施中,仔細(xì)分析研究已有的經(jīng)濟(jì)規(guī)律、法律、法規(guī),將它們上升為經(jīng)濟(jì)發(fā)展中受要素決定的指標(biāo) 2019-12-01
• 我想問下,4G全套視頻這個(gè),有講解后臺(tái)怎么提升指標(biāo),每個(gè)指標(biāo)做什么的嘛 2019-11-04
• 影響天線系統(tǒng)覆蓋性能的指標(biāo)有哪些 2019-09-29
• 調(diào)整TA&TAL可以改善哪些指標(biāo) 2019-07-13
• 全業(yè)務(wù)BRAS設(shè)備需要關(guān)哪些性能指標(biāo)呢? 2020-02-22
• CQI指標(biāo) 是能說明SINR不好么? 2019-12-30
• 游戲交互時(shí)延怎么定義,游戲話單中怎么計(jì)算該指標(biāo) 2019-12-25
• 區(qū)塊鏈?zhǔn)菓?yīng)對資本五毒:造假、欺詐、炒作、權(quán)力尋租及流氓無賴的利器!只要在具體落實(shí)四中全會(huì)《決議》的13項(xiàng)堅(jiān)持與完善措施中,仔細(xì)分析研究已有的經(jīng)濟(jì)規(guī)律、法律、法規(guī),將它們上升為經(jīng)濟(jì)發(fā)展中受要素決定的指標(biāo) 2019-12-01
• 我想問下,4G全套視頻這個(gè),有講解后臺(tái)怎么提升指標(biāo),每個(gè)指標(biāo)做什么的嘛 2019-11-04
• 影響天線系統(tǒng)覆蓋性能的指標(biāo)有哪些 2019-09-29
• 調(diào)整TA&TAL可以改善哪些指標(biāo) 2019-07-13
問題答案
( 3 )
愛立信的的腳本
回答者:
sxp030315
回答時(shí)間:2011-09-03 15:53
13 16
留個(gè)郵箱,晚點(diǎn)幫你發(fā)過來,這個(gè)貼的話,比較多。
試一試 看能貼多少吧
SELECT CELTCHF_ADM.TIME AS DATE,CELTCHF.MO AS CELL,CELTCHF_ADM.NE AS BSC,
STR((CELTCHF.TFTRALACC/(CELTCHF.TFNSCAN+0.0001) + CELTCHH.THTRALACC/(CELTCHH.THNSCAN+0.0001))*3600/(CELTCHF.TFCALLS+CELTCHH.THCALLS+0.0001),10,2) AS 通話時(shí)間,
CELTCHFP.TFCONGPGSMSUB AS TCH掉話次數(shù),
CELTCHF.TFNDROP AS 全速率TCH掉話次數(shù),
CELTCHH.THNDROP AS 半速率TCH掉話次數(shù),
CELTCHF.TFNDROP+CELTCHH.THNDROP AS 全速率加半速率掉話次數(shù),
CLTCH.TASSALL-CLTCH.TCASSALL as TCH分配失敗次數(shù),
CLTCH.TCASSALL as TCH分配成功次數(shù)不含切換,
CLTCH.TASSALL as TCH分配請求次數(shù),
STR(CLTCH.TCASSALL/(CLTCH.TASSALL+0.00001),10,2) as TCH分配成功率,
STR(CELTCHFP.TFCONGPGSMSUB/(CLTCH.TCASSALL+0.0001)*100,10,2) AS TCH掉話率不含切換,
STR((CELTCHF.TFTRALACC/CELTCHF.TFNSCAN+CELTCHH.THTRALACC/CELTCHH.THNSCAN),10,2) AS TCH話務(wù)量,
STR((CELTCHF.TFTRALACC/CELTCHF.TFNSCAN),10,2) AS TCH全速率話務(wù)量,
STR((CELTCHH.THTRALACC/CELTCHH.THNSCAN),10,2) AS TCH半速率話務(wù)量,
str(((CELTCHF.TFTRALACC + CELTCHH.THTRALACC)/(CELTCHF.TFNSCAN+0.00001))/(CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.00001)+0.00001),10,2) as TCH每信道話務(wù)量,
str((CELLGPRS.ALLPDCHACC/(CELLGPRS.ALLPDCHSCAN+0.00001)),10,2) AS 分配的PDCH數(shù)量,
CELLGPRS.PCHALLATT-CELLGPRS.PCHALLFAIL AS PDCH分配成功次數(shù),
CELLGPRS.PCHALLATT AS PDCH請求次數(shù),
CELLGPRS.PCHALLFAIL AS PDCH分配失敗次數(shù),
str((CELLGPRS.PCHALLATT-CELLGPRS.PCHALLFAIL)/(CELLGPRS.PCHALLATT+0.00001),10,2) AS PDCH分配成功率,
CELTCHFP.TFESTPGSMSUB+CELTCHF.TFCONGSHO+CELTCHH.THCONGSHO as TCH擁塞次數(shù),
str(100*(CELTCHFP.TFESTPGSMSUB+CELTCHF.TFCONGSHO+CELTCHH.THCONGSHO)/(CELTCHF.TFCALLS+CELTCHH.THCALLS+0.00001),10,4) as TCH擁塞率,
CELTCHFP.TFESTPGSMSUB as TCH真實(shí)擁塞次數(shù),
CELTCHF.TFCONGSHO as TCH全速率切換擁塞次數(shù),
CELTCHH.THCONGSHO as TCH半速率切換擁塞次數(shù),
CELTCHF.TFCALLS as TCH全速率試呼次數(shù),
CELTCHH.THCALLS as TCH半速率試呼次數(shù),
CLTCH.TASSALL AS TCH本地試呼次數(shù),
CLTCH.TNUCHCNT AS TCH定義的信道數(shù),
STR(CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.0001),10,2) AS TCH可用信道數(shù),
STR((CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.0001))/(CLTCH.TNUCHCNT+0.0001)*100,10,2) AS TCH信道可用率,
CEILING((CLTCH.TNUCHCNT+CLSDCCH.CNUCHCNT/8)/8) AS TRX,
STR((CLTCHDRF.TFDISTA+CLTCHDRH.THDISTA)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS TA掉話比,
STR((CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSDL+CLTCHDRH.THDISSUL+CLTCHDRH.THDISSBL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 弱信號掉話比,
STR((CLTCHDRF.TFDISSDL+CLTCHDRH.THDISSDL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 下行弱信號掉話比,
STR((CLTCHDRF.TFDISSUL+CLTCHDRH.THDISSUL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 上行弱信號掉話比,
STR((CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSBL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 上下行弱信號掉話比,
STR((CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISQABL+CLTCHDRH.THDISQADL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISQABL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQADL+CLTCHDRH.THDISQADL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 下行質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQAUL+CLTCHDRH.THDISQAUL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 上行質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQABL+CLTCHDRH.THDISQABL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 上下行質(zhì)差掉話比,
STR((CLTCHDRF.TFSUDLOS+CLTCHDRH.THSUDLOS)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 突然掉話比,
STR((CELTCHF.TFNDROP+CELTCHH.THNDROP-CLTCHDRF.TFDISTA-CLTCHDRH.THDISTA-CLTCHDRF.TFDISSDL-CLTCHDRF.TFDISSUL-CLTCHDRF.TFDISSBL-CLTCHDRH.THDISSDL-CLTCHDRH.THDISSUL-CLTCHDRH.THDISSBL-CLTCHDRF.TFDISQADL-CLTCHDRF.TFDISQAUL-CLTCHDRF.TFDISQABL-CLTCHDRH.THDISQADL-CLTCHDRH.THDISQAUL-CLTCHDRH.THDISQABL-CLTCHDRF.TFSUDLOS-CLTCHDRH.THSUDLOS)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 其他掉話比,
STR((CLTCHDRF.TFDISTA)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率TA掉話比,
STR((CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISSBL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率弱信號掉話比,
STR((CLTCHDRF.TFDISSDL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率下行弱信號掉話比,
STR((CLTCHDRF.TFDISSUL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率上行弱信號掉話比,
STR((CLTCHDRF.TFDISSBL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率上下行弱信號掉話比,
STR((CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISQABL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQADL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率下行質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQAUL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率上行質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQABL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率上下行質(zhì)差掉話比,
STR((CLTCHDRF.TFSUDLOS)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率突然掉話比,
STR((CELTCHF.TFNDROP-CLTCHDRF.TFDISTA-CLTCHDRF.TFDISSDL-CLTCHDRF.TFDISSUL-CLTCHDRF.TFDISSBL-CLTCHDRF.TFDISQADL-CLTCHDRF.TFDISQAUL-CLTCHDRF.TFDISQABL-CLTCHDRF.TFSUDLOS)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率其他掉話比,
STR((CLTCHDRH.THDISTA)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半全速率TA掉話比,
STR((CLTCHDRH.THDISSDL+CLTCHDRH.THDISSUL+CLTCHDRH.THDISSBL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率弱信號掉話比,
STR((CLTCHDRH.THDISSDL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率下行弱信號掉話比,
STR((CLTCHDRH.THDISSUL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率上行弱信號掉話比,
STR((CLTCHDRH.THDISSBL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率上下行弱信號掉話比,
STR((CLTCHDRH.THDISQADL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISQABL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率質(zhì)差掉話比,
STR((CLTCHDRH.THDISQADL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率下行質(zhì)差掉話比,
STR((CLTCHDRH.THDISQAUL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率上行質(zhì)差掉話比,
STR((CLTCHDRH.THDISQABL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率上下行質(zhì)差掉話比,
STR((CLTCHDRH.THSUDLOS)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率突然掉話比,
STR((CELTCHH.THNDROP-CLTCHDRH.THDISTA-CLTCHDRH.THDISSDL-CLTCHDRH.THDISSUL-CLTCHDRH.THDISSBL-CLTCHDRH.THDISQADL-CLTCHDRH.THDISQAUL-CLTCHDRH.THDISQABL-CLTCHDRH.THSUDLOS)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率其他掉話比,
RANDOMACC.CNROCNT AS 隨即接入成功次數(shù),
RANDOMACC.RAACCFA AS 隨即接入失敗次數(shù),
STR(RANDOMACC.CNROCNT/(RANDOMACC.CNROCNT+RANDOMACC.RAACCFA+0.00001)*100,10,2) AS 隨即接入成功率,
RANDOMACC.RAEMCAL AS 緊急呼叫次數(shù),
RANDOMACC.RACALRE AS 呼叫重建接入次數(shù),
RANDOMACC.RAANPAG AS 隨即接入的尋呼次數(shù),
RANDOMACC.RAOSREQ AS 隨即接入的呼叫次數(shù),
RANDOMACC.RAOTHER AS 隨即接入中的位置更新次數(shù),
STR(RANDOMACC.RAOTHER/(RANDOMACC.CNROCNT+0.0001)*100,10,2) AS 隨機(jī)接入中的位置更新比,
CLSDCCH.CCALLS AS SDCCH試呼次數(shù),
CLSDCCH.CMSESTAB AS SDCCH成功占用次數(shù),
STR(CLSDCCH.CCONGS/(CLSDCCH.CCALLS+0.0001)*100,10,2) AS SD擁塞率,
CLSDCCH.CNDROP AS SD掉話次數(shù),
STR(CLSDCCH.CNDROP/(CLSDCCH.CMSESTAB+0.0001)*100,10,2) AS SD掉話率,
CLSDCCH.CCONGS AS SD擁塞次數(shù),
CLSDCCH.CTCONGS AS SD擁塞時(shí)間,
STR((CLSDCCH_ADM.RPL/60)*CLSDCCH.CTRALACC/(CLSDCCH.CNSCAN+0.0001),10,2) AS SD話務(wù)量,
STR((CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001))/CLSDCCH.CNUCHCNT*100,10,2) AS SD信道可用率,
STR(CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001),10,2) AS SD可用的信道數(shù),
CLSDCCH.CNUCHCNT AS SD定義的信道數(shù),
STR(CELLCCHDR.CDISTA/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SD的TA掉話比,
STR(CELLCCHDR.CDISSS/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SD弱信號掉話比,
STR(CELLCCHDR.CDISQA/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SD質(zhì)差掉話比,
STR(((CLSDCCH.CNDROP-CELLCCHDR.CDISTA-CELLCCHDR.CDISSS-CELLCCHDR.CDISQA)/(CLSDCCH.CNDROP+0.0001))*100,10,2) AS SD其他原因掉話比,
STR((CLSDCCH.CMSESTAB)/(CLSDCCH.CCALLS-CLSDCCH.CCONGS+0.0001)*100,10,2) AS SD建立成功率,
CLTCH.TCHSIG AS TCH轉(zhuǎn)換為SD的次數(shù),
STR((IDLEUTCHF.ITFUSIB1)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU1,
STR((IDLEUTCHF.ITFUSIB2)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU2,
STR((IDLEUTCHF.ITFUSIB3)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU3,
STR((IDLEUTCHF.ITFUSIB4)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU4,
STR((IDLEUTCHF.ITFUSIB5)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU5
FROM CELTCHF
LEFT JOIN CELTCHF_ADM ON CELTCHF.ID=CELTCHF_ADM.ID
LEFT JOIN CELTCHFP ON CELTCHF.MO=CELTCHFP.MO AND CELTCHF.ID=CELTCHFP.ID
LEFT JOIN CELTCHH ON CELTCHF.MO=CELTCHH.MO AND CELTCHF.ID=CELTCHH.ID
LEFT JOIN CELTCHH_ADM ON CELTCHF.ID=CELTCHH_ADM.ID
LEFT JOIN CLTCH ON CELTCHF.MO=CLTCH.MO AND CELTCHF.ID=CLTCH.ID
LEFT JOIN CLTCHDRF ON CELTCHF.MO=CLTCHDRF.MO AND CELTCHF.ID=CLTCHDRF.ID
LEFT JOIN CLTCHDRH ON CELTCHF.MO=CLTCHDRH.MO AND CELTCHF.ID=CLTCHDRH.ID
LEFT JOIN CLSDCCH ON CELTCHF.MO=CLSDCCH.MO AND CELTCHF.ID=CLSDCCH.ID
LEFT JOIN CLSDCCH_ADM ON CELTCHF.ID=CLSDCCH_ADM.ID
LEFT JOIN CELLCCHDR ON CELTCHF.MO=CELLCCHDR.MO AND CELTCHF.ID=CELLCCHDR.ID
LEFT JOIN IDLEUTCHF ON CELTCHF.MO=IDLEUTCHF.MO AND CELTCHF.ID=IDLEUTCHF.ID
LEFT JOIN CELLGPRS ON IDLEUTCHF.MO=CELLGPRS.MO AND IDLEUTCHF.ID=CELLGPRS.ID
LEFT JOIN RANDOMACC ON CELTCHF.MO=RANDOMACC.MO AND CELTCHF.ID=RANDOMACC.ID
WHERE CELTCHF_ADM.TIME/*>= '2010-12-13 9:00'*/IN('2010-12-11 10:00') AND CELTCHF_ADM.NE LIKE '%WHBSC%' AND CELTCHF.MO LIKE '%W%'
ORDER BY CELTCHF_ADM.NE,CELTCHF.MO,CELTCHF_ADM.TIME;
試一試 看能貼多少吧
SELECT CELTCHF_ADM.TIME AS DATE,CELTCHF.MO AS CELL,CELTCHF_ADM.NE AS BSC,
STR((CELTCHF.TFTRALACC/(CELTCHF.TFNSCAN+0.0001) + CELTCHH.THTRALACC/(CELTCHH.THNSCAN+0.0001))*3600/(CELTCHF.TFCALLS+CELTCHH.THCALLS+0.0001),10,2) AS 通話時(shí)間,
CELTCHFP.TFCONGPGSMSUB AS TCH掉話次數(shù),
CELTCHF.TFNDROP AS 全速率TCH掉話次數(shù),
CELTCHH.THNDROP AS 半速率TCH掉話次數(shù),
CELTCHF.TFNDROP+CELTCHH.THNDROP AS 全速率加半速率掉話次數(shù),
CLTCH.TASSALL-CLTCH.TCASSALL as TCH分配失敗次數(shù),
CLTCH.TCASSALL as TCH分配成功次數(shù)不含切換,
CLTCH.TASSALL as TCH分配請求次數(shù),
STR(CLTCH.TCASSALL/(CLTCH.TASSALL+0.00001),10,2) as TCH分配成功率,
STR(CELTCHFP.TFCONGPGSMSUB/(CLTCH.TCASSALL+0.0001)*100,10,2) AS TCH掉話率不含切換,
STR((CELTCHF.TFTRALACC/CELTCHF.TFNSCAN+CELTCHH.THTRALACC/CELTCHH.THNSCAN),10,2) AS TCH話務(wù)量,
STR((CELTCHF.TFTRALACC/CELTCHF.TFNSCAN),10,2) AS TCH全速率話務(wù)量,
STR((CELTCHH.THTRALACC/CELTCHH.THNSCAN),10,2) AS TCH半速率話務(wù)量,
str(((CELTCHF.TFTRALACC + CELTCHH.THTRALACC)/(CELTCHF.TFNSCAN+0.00001))/(CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.00001)+0.00001),10,2) as TCH每信道話務(wù)量,
str((CELLGPRS.ALLPDCHACC/(CELLGPRS.ALLPDCHSCAN+0.00001)),10,2) AS 分配的PDCH數(shù)量,
CELLGPRS.PCHALLATT-CELLGPRS.PCHALLFAIL AS PDCH分配成功次數(shù),
CELLGPRS.PCHALLATT AS PDCH請求次數(shù),
CELLGPRS.PCHALLFAIL AS PDCH分配失敗次數(shù),
str((CELLGPRS.PCHALLATT-CELLGPRS.PCHALLFAIL)/(CELLGPRS.PCHALLATT+0.00001),10,2) AS PDCH分配成功率,
CELTCHFP.TFESTPGSMSUB+CELTCHF.TFCONGSHO+CELTCHH.THCONGSHO as TCH擁塞次數(shù),
str(100*(CELTCHFP.TFESTPGSMSUB+CELTCHF.TFCONGSHO+CELTCHH.THCONGSHO)/(CELTCHF.TFCALLS+CELTCHH.THCALLS+0.00001),10,4) as TCH擁塞率,
CELTCHFP.TFESTPGSMSUB as TCH真實(shí)擁塞次數(shù),
CELTCHF.TFCONGSHO as TCH全速率切換擁塞次數(shù),
CELTCHH.THCONGSHO as TCH半速率切換擁塞次數(shù),
CELTCHF.TFCALLS as TCH全速率試呼次數(shù),
CELTCHH.THCALLS as TCH半速率試呼次數(shù),
CLTCH.TASSALL AS TCH本地試呼次數(shù),
CLTCH.TNUCHCNT AS TCH定義的信道數(shù),
STR(CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.0001),10,2) AS TCH可用信道數(shù),
STR((CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.0001))/(CLTCH.TNUCHCNT+0.0001)*100,10,2) AS TCH信道可用率,
CEILING((CLTCH.TNUCHCNT+CLSDCCH.CNUCHCNT/8)/8) AS TRX,
STR((CLTCHDRF.TFDISTA+CLTCHDRH.THDISTA)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS TA掉話比,
STR((CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSDL+CLTCHDRH.THDISSUL+CLTCHDRH.THDISSBL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 弱信號掉話比,
STR((CLTCHDRF.TFDISSDL+CLTCHDRH.THDISSDL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 下行弱信號掉話比,
STR((CLTCHDRF.TFDISSUL+CLTCHDRH.THDISSUL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 上行弱信號掉話比,
STR((CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSBL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 上下行弱信號掉話比,
STR((CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISQABL+CLTCHDRH.THDISQADL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISQABL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQADL+CLTCHDRH.THDISQADL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 下行質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQAUL+CLTCHDRH.THDISQAUL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 上行質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQABL+CLTCHDRH.THDISQABL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 上下行質(zhì)差掉話比,
STR((CLTCHDRF.TFSUDLOS+CLTCHDRH.THSUDLOS)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 突然掉話比,
STR((CELTCHF.TFNDROP+CELTCHH.THNDROP-CLTCHDRF.TFDISTA-CLTCHDRH.THDISTA-CLTCHDRF.TFDISSDL-CLTCHDRF.TFDISSUL-CLTCHDRF.TFDISSBL-CLTCHDRH.THDISSDL-CLTCHDRH.THDISSUL-CLTCHDRH.THDISSBL-CLTCHDRF.TFDISQADL-CLTCHDRF.TFDISQAUL-CLTCHDRF.TFDISQABL-CLTCHDRH.THDISQADL-CLTCHDRH.THDISQAUL-CLTCHDRH.THDISQABL-CLTCHDRF.TFSUDLOS-CLTCHDRH.THSUDLOS)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS 其他掉話比,
STR((CLTCHDRF.TFDISTA)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率TA掉話比,
STR((CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISSBL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率弱信號掉話比,
STR((CLTCHDRF.TFDISSDL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率下行弱信號掉話比,
STR((CLTCHDRF.TFDISSUL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率上行弱信號掉話比,
STR((CLTCHDRF.TFDISSBL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率上下行弱信號掉話比,
STR((CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISQABL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQADL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率下行質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQAUL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率上行質(zhì)差掉話比,
STR((CLTCHDRF.TFDISQABL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率上下行質(zhì)差掉話比,
STR((CLTCHDRF.TFSUDLOS)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率突然掉話比,
STR((CELTCHF.TFNDROP-CLTCHDRF.TFDISTA-CLTCHDRF.TFDISSDL-CLTCHDRF.TFDISSUL-CLTCHDRF.TFDISSBL-CLTCHDRF.TFDISQADL-CLTCHDRF.TFDISQAUL-CLTCHDRF.TFDISQABL-CLTCHDRF.TFSUDLOS)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS 全速率其他掉話比,
STR((CLTCHDRH.THDISTA)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半全速率TA掉話比,
STR((CLTCHDRH.THDISSDL+CLTCHDRH.THDISSUL+CLTCHDRH.THDISSBL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率弱信號掉話比,
STR((CLTCHDRH.THDISSDL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率下行弱信號掉話比,
STR((CLTCHDRH.THDISSUL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率上行弱信號掉話比,
STR((CLTCHDRH.THDISSBL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率上下行弱信號掉話比,
STR((CLTCHDRH.THDISQADL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISQABL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率質(zhì)差掉話比,
STR((CLTCHDRH.THDISQADL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率下行質(zhì)差掉話比,
STR((CLTCHDRH.THDISQAUL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率上行質(zhì)差掉話比,
STR((CLTCHDRH.THDISQABL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率上下行質(zhì)差掉話比,
STR((CLTCHDRH.THSUDLOS)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率突然掉話比,
STR((CELTCHH.THNDROP-CLTCHDRH.THDISTA-CLTCHDRH.THDISSDL-CLTCHDRH.THDISSUL-CLTCHDRH.THDISSBL-CLTCHDRH.THDISQADL-CLTCHDRH.THDISQAUL-CLTCHDRH.THDISQABL-CLTCHDRH.THSUDLOS)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS 半速率其他掉話比,
RANDOMACC.CNROCNT AS 隨即接入成功次數(shù),
RANDOMACC.RAACCFA AS 隨即接入失敗次數(shù),
STR(RANDOMACC.CNROCNT/(RANDOMACC.CNROCNT+RANDOMACC.RAACCFA+0.00001)*100,10,2) AS 隨即接入成功率,
RANDOMACC.RAEMCAL AS 緊急呼叫次數(shù),
RANDOMACC.RACALRE AS 呼叫重建接入次數(shù),
RANDOMACC.RAANPAG AS 隨即接入的尋呼次數(shù),
RANDOMACC.RAOSREQ AS 隨即接入的呼叫次數(shù),
RANDOMACC.RAOTHER AS 隨即接入中的位置更新次數(shù),
STR(RANDOMACC.RAOTHER/(RANDOMACC.CNROCNT+0.0001)*100,10,2) AS 隨機(jī)接入中的位置更新比,
CLSDCCH.CCALLS AS SDCCH試呼次數(shù),
CLSDCCH.CMSESTAB AS SDCCH成功占用次數(shù),
STR(CLSDCCH.CCONGS/(CLSDCCH.CCALLS+0.0001)*100,10,2) AS SD擁塞率,
CLSDCCH.CNDROP AS SD掉話次數(shù),
STR(CLSDCCH.CNDROP/(CLSDCCH.CMSESTAB+0.0001)*100,10,2) AS SD掉話率,
CLSDCCH.CCONGS AS SD擁塞次數(shù),
CLSDCCH.CTCONGS AS SD擁塞時(shí)間,
STR((CLSDCCH_ADM.RPL/60)*CLSDCCH.CTRALACC/(CLSDCCH.CNSCAN+0.0001),10,2) AS SD話務(wù)量,
STR((CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001))/CLSDCCH.CNUCHCNT*100,10,2) AS SD信道可用率,
STR(CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001),10,2) AS SD可用的信道數(shù),
CLSDCCH.CNUCHCNT AS SD定義的信道數(shù),
STR(CELLCCHDR.CDISTA/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SD的TA掉話比,
STR(CELLCCHDR.CDISSS/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SD弱信號掉話比,
STR(CELLCCHDR.CDISQA/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SD質(zhì)差掉話比,
STR(((CLSDCCH.CNDROP-CELLCCHDR.CDISTA-CELLCCHDR.CDISSS-CELLCCHDR.CDISQA)/(CLSDCCH.CNDROP+0.0001))*100,10,2) AS SD其他原因掉話比,
STR((CLSDCCH.CMSESTAB)/(CLSDCCH.CCALLS-CLSDCCH.CCONGS+0.0001)*100,10,2) AS SD建立成功率,
CLTCH.TCHSIG AS TCH轉(zhuǎn)換為SD的次數(shù),
STR((IDLEUTCHF.ITFUSIB1)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU1,
STR((IDLEUTCHF.ITFUSIB2)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU2,
STR((IDLEUTCHF.ITFUSIB3)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU3,
STR((IDLEUTCHF.ITFUSIB4)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU4,
STR((IDLEUTCHF.ITFUSIB5)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU5
FROM CELTCHF
LEFT JOIN CELTCHF_ADM ON CELTCHF.ID=CELTCHF_ADM.ID
LEFT JOIN CELTCHFP ON CELTCHF.MO=CELTCHFP.MO AND CELTCHF.ID=CELTCHFP.ID
LEFT JOIN CELTCHH ON CELTCHF.MO=CELTCHH.MO AND CELTCHF.ID=CELTCHH.ID
LEFT JOIN CELTCHH_ADM ON CELTCHF.ID=CELTCHH_ADM.ID
LEFT JOIN CLTCH ON CELTCHF.MO=CLTCH.MO AND CELTCHF.ID=CLTCH.ID
LEFT JOIN CLTCHDRF ON CELTCHF.MO=CLTCHDRF.MO AND CELTCHF.ID=CLTCHDRF.ID
LEFT JOIN CLTCHDRH ON CELTCHF.MO=CLTCHDRH.MO AND CELTCHF.ID=CLTCHDRH.ID
LEFT JOIN CLSDCCH ON CELTCHF.MO=CLSDCCH.MO AND CELTCHF.ID=CLSDCCH.ID
LEFT JOIN CLSDCCH_ADM ON CELTCHF.ID=CLSDCCH_ADM.ID
LEFT JOIN CELLCCHDR ON CELTCHF.MO=CELLCCHDR.MO AND CELTCHF.ID=CELLCCHDR.ID
LEFT JOIN IDLEUTCHF ON CELTCHF.MO=IDLEUTCHF.MO AND CELTCHF.ID=IDLEUTCHF.ID
LEFT JOIN CELLGPRS ON IDLEUTCHF.MO=CELLGPRS.MO AND IDLEUTCHF.ID=CELLGPRS.ID
LEFT JOIN RANDOMACC ON CELTCHF.MO=RANDOMACC.MO AND CELTCHF.ID=RANDOMACC.ID
WHERE CELTCHF_ADM.TIME/*>= '2010-12-13 9:00'*/IN('2010-12-11 10:00') AND CELTCHF_ADM.NE LIKE '%WHBSC%' AND CELTCHF.MO LIKE '%W%'
ORDER BY CELTCHF_ADM.NE,CELTCHF.MO,CELTCHF_ADM.TIME;
回答者:
liuhao123
回答時(shí)間:2011-09-03 19:25
15 13
學(xué)習(xí)一下
回答者:
RFMSC
回答時(shí)間:2011-09-05 00:47
11 13
• 深圳市訊方技術(shù)股份有限公司
聘:華為45G高級網(wǎng)優(yōu)工程師
需求人數(shù):5 人 地點(diǎn):山東省
• 福建省鴻官通信工程有限公司 聘:湖南電信原廠優(yōu)化高級
需求人數(shù):2 人 地點(diǎn):岳陽市,長沙市
• 西安長河通訊有限責(zé)任公司 聘:網(wǎng)絡(luò)優(yōu)化工程師
需求人數(shù):4 人 地點(diǎn):渭南市,商洛市,漢中市,安康市
• 福州弘宇信合通信技術(shù)有限公司 聘:“1+N項(xiàng)目”高級網(wǎng)優(yōu)工程師
需求人數(shù):5 人 地點(diǎn):廣東省
• 安徽引途科技有限公司 聘:福建測試/1個(gè)月
需求人數(shù):2 人 地點(diǎn):福建省
• 重慶信科通信工程有限公司 聘:江西電信原廠高級后臺(tái)
需求人數(shù):2 人 地點(diǎn):九江市
• 錦華技術(shù)(蘭州)有限公司 聘:杭州5G中興中級/高級后臺(tái)
需求人數(shù):5 人 地點(diǎn):杭州市,寧波市,嘉興市,溫州市,紹興市
• 重慶愛信思科技有限責(zé)任公司 聘:高級系統(tǒng)優(yōu)化工程師(駐菲律賓)
需求人數(shù):2 人 地點(diǎn):東南亞
• 浙江明訊網(wǎng)絡(luò)技術(shù)有限公司 聘:網(wǎng)優(yōu)工程師(湖南)
需求人數(shù):0 人 地點(diǎn):長沙市,湘潭市,邵陽市
• 嘉環(huán)科技股份有限公司 聘:湖南電信原廠優(yōu)化招聘
需求人數(shù):10 人 地點(diǎn):長沙市,永州市,郴州市,衡陽市
需求人數(shù):5 人 地點(diǎn):山東省
• 福建省鴻官通信工程有限公司 聘:湖南電信原廠優(yōu)化高級
需求人數(shù):2 人 地點(diǎn):岳陽市,長沙市
• 西安長河通訊有限責(zé)任公司 聘:網(wǎng)絡(luò)優(yōu)化工程師
需求人數(shù):4 人 地點(diǎn):渭南市,商洛市,漢中市,安康市
• 福州弘宇信合通信技術(shù)有限公司 聘:“1+N項(xiàng)目”高級網(wǎng)優(yōu)工程師
需求人數(shù):5 人 地點(diǎn):廣東省
• 安徽引途科技有限公司 聘:福建測試/1個(gè)月
需求人數(shù):2 人 地點(diǎn):福建省
• 重慶信科通信工程有限公司 聘:江西電信原廠高級后臺(tái)
需求人數(shù):2 人 地點(diǎn):九江市
• 錦華技術(shù)(蘭州)有限公司 聘:杭州5G中興中級/高級后臺(tái)
需求人數(shù):5 人 地點(diǎn):杭州市,寧波市,嘉興市,溫州市,紹興市
• 重慶愛信思科技有限責(zé)任公司 聘:高級系統(tǒng)優(yōu)化工程師(駐菲律賓)
需求人數(shù):2 人 地點(diǎn):東南亞
• 浙江明訊網(wǎng)絡(luò)技術(shù)有限公司 聘:網(wǎng)優(yōu)工程師(湖南)
需求人數(shù):0 人 地點(diǎn):長沙市,湘潭市,邵陽市
• 嘉環(huán)科技股份有限公司 聘:湖南電信原廠優(yōu)化招聘
需求人數(shù):10 人 地點(diǎn):長沙市,永州市,郴州市,衡陽市
熱點(diǎn)問題
更多精彩
聯(lián)系我們 - 問通信專家 | Powered by MSCBSC 移動(dòng)通信網(wǎng) © 2006 - |