叼嘿软件,亚洲日本不卡不码一区二区,欧美中文综合在线视频

移動通信網(wǎng) 首頁搜索新聞問答論壇人才博客通信圈

善于提問，勤于回答，你也是專家

問題已開啟 (普通問題)

有哪位高手可以給我發(fā)一份取指標(biāo)的sql腳本？

有哪位高手可以給我發(fā)一份取指標(biāo)的sql腳本？
就是用數(shù)據(jù)庫軟件sqldbx從sybase中取指標(biāo)的sql腳本？愛立信的設(shè)備

提問者: zhugeyingju 提問時(shí)間: 2011-09-03

	我要回答：

	請先登錄或注冊再回答問題

更多指標(biāo) 腳本 SQL 相關(guān)問題

• 移動LTE日常網(wǎng)優(yōu)后臺考核哪些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í)四中全會《決議》的13項(xiàng)堅(jiān)持與完善措施中，仔細(xì)分析研究已有的經(jīng)濟(jì)規(guī)律、法律、法規(guī)，將它們上升為經(jīng)濟(jì)發(fā)展中受要素決定的指標(biāo) 2019-12-01
• 我想問下，4G全套視頻這個(gè)，有講解后臺怎么提升指標(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

留個(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;

回答者： liuhao123 回答時(shí)間：2011-09-03 19:25

謝謝。我的郵箱是 zhugeyingju@163.com 非常感激。

zhugeyingju 2011-09-08 13:24

學(xué)習(xí)一下

回答者： RFMSC 回答時(shí)間：2011-09-05 00:47

未找到滿意答案？

移動通信論壇，提供全面的通信資料、技術(shù)支持！

最新緊急招聘通信職位

熱點(diǎn)問題


聯(lián)系我們 - 問通信專家	Powered by MSCBSC 移動通信網(wǎng) © 2006 -