cdr介紹及應(yīng)用分析教程

1、2024/3/21,廣州CDMA項(xiàng)目組,華為CDR介紹及應(yīng)用分析,,Page 2,目錄,華為CDR介紹SQL查詢介紹CDR應(yīng)用案例,Page 3,1. 華為CDR介紹—概述,,Page 4,1. 華為CDR介紹—CDR腳本,,Page 5,1. 華為CDR介紹—CDR腳本,,Page 6,1. 華為CDR介紹—打開CDR跟蹤,,Page 7,1. 華為CDR介紹—停止CDR跟蹤,,Page 8,1. 華為CDR介紹—CDR對(duì)系統(tǒng)的影

2、響,,Page 9,1. 華為CDR介紹—CDR重要字段介紹,,Page 10,1. 華為CDR介紹—CDR重要字段介紹,,Page 11,1. 華為CDR介紹—CDR釋放字段,,Page 12,目錄,華為CDR介紹SQL查詢介紹CDR應(yīng)用案例,Page 13,2. SQL查詢介紹—特定IMSI的CDR查詢,USE Nastar_Genex_CDMA2K_11SELECT *FROM (SELECT 'BSC01&

3、#39; AS BscId,* FROM dbo.CHR_1X_CDR_Detail_BSC01UNION ALLSELECT 'BSC02' AS BscId,* FROM dbo.CHR_1X_CDR_Detail_BSC02UNION ALLSELECT 'BSC03' AS BscId,* FROM dbo.CHR_1X_CDR_Detail_BSC03UNION ALLS

4、ELECT 'BSC04' AS BscId,* FROM dbo.CHR_1X_CDR_Detail_BSC04UNION ALLSELECT 'BSC05' AS BscId,* FROM dbo.CHR_1X_CDR_Detail_BSC05UNION ALLSELECT 'BSC06' AS BscId,* FROM dbo.CHR_1X_CDR_Detail_BS

5、C06UNION ALLSELECT 'BSC07' AS BscId,* FROM dbo.CHR_1X_CDR_Detail_BSC07) AS AWHERE 最終的業(yè)務(wù)選項(xiàng) = 3 AND IMSI IN('460036241001393')AND [接入時(shí)刻秒數(shù)] BETWEEN '2009-04-17 00:00:00' AND '2009-04-20

6、00:00:00'ORDER BY 接入時(shí)刻秒數(shù),Page 14,2. SQL查詢介紹—TOP掉話用戶查詢,USE Nastar_Genex_CDMA2K_11SELECT TOP 20 [IMSI],BscId,[呼叫資源釋放時(shí)激活集1小區(qū)標(biāo)識(shí)] AS [小區(qū)], COUNT(*) AS NumFROM (SELECT 'BSC01' AS BscId,* FROM dbo.CHR_1X_BSC

7、01_CDR_DetailUNION ALLSELECT 'BSC02' AS BscId,* FROM dbo.CHR_1X_BSC02_CDR_DetailUNION ALLSELECT 'BSC03' AS BscId,* FROM dbo.CHR_1X_BSC03_CDR_DetailUNION ALLSELECT 'BSC04' AS BscId,* FR

8、OM dbo.CHR_1X_BSC04_CDR_DetailUNION ALLSELECT 'BSC05' AS BscId,* FROM dbo.CHR_1X_BSC05_CDR_DetailUNION ALLSELECT 'BSC06' AS BscId,* FROM dbo.CHR_1X_BSC06_CDR_DetailUNION ALLSELECT 'BSC07&#

9、39; AS BscId,* FROM dbo.CHR_1X_BSC07_CDR_Detail) AS AWHERE [最終的業(yè)務(wù)選項(xiàng)] = 3 AND [呼叫狀態(tài)] = 1AND [呼叫釋放原因值] IN (3077)GROUP BY [IMSI],BscId, [呼叫資源釋放時(shí)激活集1小區(qū)標(biāo)識(shí)]ORDER BY Num DESC,Page 15,2. SQL查詢介紹—TOP呼建失敗用戶查詢,SELECT TOP 20 [

10、IMSI],BscId,[接入導(dǎo)頻_CellID] AS [小區(qū)], COUNT(*) AS NumFROM (SELECT 'BSC01' AS BscId,* FROM dbo.CHR_1X_BSC01_CDR_DetailUNION ALLSELECT 'BSC02' AS BscId,* FROM dbo.CHR_1X_BSC02_CDR_DetailUNION ALLS

11、ELECT 'BSC03' AS BscId,* FROM dbo.CHR_1X_BSC03_CDR_DetailUNION ALLSELECT 'BSC04' AS BscId,* FROM dbo.CHR_1X_BSC04_CDR_DetailUNION ALLSELECT 'BSC05' AS BscId,* FROM dbo.CHR_1X_BSC05_CDR_Det

12、ailUNION ALLSELECT 'BSC06' AS BscId,* FROM dbo.CHR_1X_BSC06_CDR_DetailUNION ALLSELECT 'BSC07' AS BscId,* FROM dbo.CHR_1X_BSC07_CDR_Detail) AS AWHERE [最終的業(yè)務(wù)選項(xiàng)] = 3 AND [呼叫釋放原因值] IN (9986,9987)G

13、ROUP BY [IMSI],BscId, [接入導(dǎo)頻_CellID]ORDER BY Num DESC,Page 16,2. SQL查詢介紹—小區(qū)掉話記錄查詢,USE Nastar_Genex_CDMA2K_11SELECT *FROM dbo.CHR_1X_BSC02_CDR_DetailWHERE 最終的業(yè)務(wù)選項(xiàng) = 3AND 呼叫釋放原因值 = 3077AND ((呼叫資源釋放時(shí)激活集1小區(qū)標(biāo)識(shí)=664 A

14、ND 呼叫資源釋放時(shí)激活集1扇區(qū)標(biāo)識(shí)=0)OR (呼叫資源釋放時(shí)激活集2小區(qū)標(biāo)識(shí)=664 AND 呼叫資源釋放時(shí)激活集2扇區(qū)標(biāo)識(shí)=0)OR (呼叫資源釋放時(shí)激活集3小區(qū)標(biāo)識(shí)=664 AND 呼叫資源釋放時(shí)激活集3扇區(qū)標(biāo)識(shí)=0))SELECT *FROM dbo.CHR_1X_BSC03_CDR_DetailWHERE 最終的業(yè)務(wù)選項(xiàng) = 3AND 呼叫釋放原因值 = 3077AND ((呼叫資源釋放

15、時(shí)激活集1小區(qū)標(biāo)識(shí)=29 AND 呼叫資源釋放時(shí)激活集1扇區(qū)標(biāo)識(shí) IN (0,1,2) )OR (呼叫資源釋放時(shí)激活集2小區(qū)標(biāo)識(shí)=29 AND 呼叫資源釋放時(shí)激活集2扇區(qū)標(biāo)識(shí) IN (0,1,2) )OR (呼叫資源釋放時(shí)激活集3小區(qū)標(biāo)識(shí)=29 AND 呼叫資源釋放時(shí)激活集3扇區(qū)標(biāo)識(shí) IN (0,1,2) )),Page 17,目錄,華為CDR介紹SQL查詢介紹CDR應(yīng)用案例,Page 18,3. CDR應(yīng)用案例1—

16、VIP掉話投訴分析,問題描述投訴時(shí)間：2009-5-14投訴原因：VIP投訴在廣州大道沙河路往北走時(shí)出現(xiàn)掉話。CDR分析,Page 19,3. CDR應(yīng)用案例1—VIP掉話投訴分析,問題描述投訴時(shí)間：2009-5-14投訴原因：VIP投訴在廣州大道沙河路往北走時(shí)出現(xiàn)掉話。CDR分析從地圖上看，掉話周圍小區(qū)較多，但掉話時(shí)只有單分支，且釋放時(shí)EcIo很差，判斷可能由于掉話小區(qū)201鄰區(qū)漏配引起，檢查鄰區(qū)確實(shí)存在明顯的漏配情況，

17、優(yōu)化鄰區(qū)后問題得到解決。,Page 20,3. CDR應(yīng)用案例2—導(dǎo)頻污染導(dǎo)致掉話分析,問題描述CDR發(fā)現(xiàn)用戶IMSI460030302882832在20090510掉話7次，分別在2_642_0(祈福學(xué)校宿舍)、2_444_0(廣地花園-D)掉話3次、2_420_2(錦繡香江-D）、2_420_1(錦繡香江-D)和2_646_1（迎賓酒店-D）小區(qū)上。CDR分析從接入延遲發(fā)現(xiàn)2_642_0(祈福學(xué)校宿舍)接入時(shí)延較大，在4公里左

18、右，為越區(qū)覆蓋，而釋放小區(qū)2_444_0(廣地花園-D) 和2_420_1(錦繡香江-D)的最后一條PSMM上報(bào)的導(dǎo)頻數(shù)目都大于4個(gè)，導(dǎo)頻強(qiáng)度在-12.5db以上，該區(qū)域?yàn)閷?dǎo)頻污染所致。,Page 21,3. CDR應(yīng)用案例2—導(dǎo)頻污染導(dǎo)致掉話分析,CDR分析從接入延遲發(fā)現(xiàn)2_642_0(祈福學(xué)校宿舍)接入時(shí)延較大，在4公里左右，而釋放小區(qū)廣地花園-D)和錦繡香江-D的最后一條PSMM上報(bào)的導(dǎo)頻數(shù)目都大于4個(gè)，導(dǎo)頻強(qiáng)度在-12.5db