CDR介绍及应用分析教程.ppt
2023/11/7,广州CDMA项目组,华为CDR介绍及应用分析,Page 2,目录,华为CDR介绍SQL查询介绍CDR应用案例,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对系统的影响,Page 9,1.华为CDR介绍CDR重要字段介绍,Page 10,1.华为CDR介绍CDR重要字段介绍,Page 11,1.华为CDR介绍CDR释放字段,Page 12,目录,华为CDR介绍SQL查询介绍CDR应用案例,Page 13,2.SQL查询介绍特定IMSI的CDR查询,USE Nastar_Genex_CDMA2K_11SELECT*FROM(SELECT BSC01 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 ALLSELECT 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_BSC06UNION ALLSELECT BSC07 AS BscId,*FROM dbo.CHR_1X_CDR_Detail_BSC07)AS AWHERE 最终的业务选项=3 AND IMSI IN(460036241001393)AND 接入时刻秒数 BETWEEN 2009-04-17 00:00:00 AND 2009-04-20 00:00:00ORDER BY 接入时刻秒数,Page 14,2.SQL查询介绍TOP掉话用户查询,USE Nastar_Genex_CDMA2K_11SELECT TOP 20 IMSI,BscId,呼叫资源释放时激活集1小区标识 AS 小区,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 ALLSELECT 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_DetailUNION ALLSELECT BSC06 AS BscId,*FROM dbo.CHR_1X_BSC06_CDR_DetailUNION ALLSELECT BSC07 AS BscId,*FROM dbo.CHR_1X_BSC07_CDR_Detail)AS AWHERE 最终的业务选项=3 AND 呼叫状态=1AND 呼叫释放原因值 IN(3077)GROUP BY IMSI,BscId,呼叫资源释放时激活集1小区标识ORDER BY Num DESC,Page 15,2.SQL查询介绍TOP呼建失败用户查询,SELECT TOP 20 IMSI,BscId,接入导频_CellID AS 小区,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 ALLSELECT 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_DetailUNION ALLSELECT BSC06 AS BscId,*FROM dbo.CHR_1X_BSC06_CDR_DetailUNION ALLSELECT BSC07 AS BscId,*FROM dbo.CHR_1X_BSC07_CDR_Detail)AS AWHERE 最终的业务选项=3 AND 呼叫释放原因值 IN(9986,9987)GROUP BY IMSI,BscId,接入导频_CellIDORDER BY Num DESC,Page 16,2.SQL查询介绍小区掉话记录查询,USE Nastar_Genex_CDMA2K_11SELECT*FROM dbo.CHR_1X_BSC02_CDR_DetailWHERE 最终的业务选项=3AND 呼叫释放原因值=3077AND(呼叫资源释放时激活集1小区标识=664 AND 呼叫资源释放时激活集1扇区标识=0)OR(呼叫资源释放时激活集2小区标识=664 AND 呼叫资源释放时激活集2扇区标识=0)OR(呼叫资源释放时激活集3小区标识=664 AND 呼叫资源释放时激活集3扇区标识=0)SELECT*FROM dbo.CHR_1X_BSC03_CDR_DetailWHERE 最终的业务选项=3AND 呼叫释放原因值=3077AND(呼叫资源释放时激活集1小区标识=29 AND 呼叫资源释放时激活集1扇区标识 IN(0,1,2)OR(呼叫资源释放时激活集2小区标识=29 AND 呼叫资源释放时激活集2扇区标识 IN(0,1,2)OR(呼叫资源释放时激活集3小区标识=29 AND 呼叫资源释放时激活集3扇区标识 IN(0,1,2),Page 17,目录,华为CDR介绍SQL查询介绍CDR应用案例,Page 18,3.CDR应用案例1VIP掉话投诉分析,问题描述投诉时间：2009-5-14投诉原因：VIP投诉在广州大道沙河路往北走时出现掉话。CDR分析,Page 19,3.CDR应用案例1VIP掉话投诉分析,问题描述投诉时间：2009-5-14投诉原因：VIP投诉在广州大道沙河路往北走时出现掉话。CDR分析从地图上看，掉话周围小区较多，但掉话时只有单分支，且释放时EcIo很差，判断可能由于掉话小区201邻区漏配引起，检查邻区确实存在明显的漏配情况，优化邻区后问题得到解决。,Page 20,3.CDR应用案例2导频污染导致掉话分析,问题描述CDR发现用户IMSI460030302882832在20090510掉话7次，分别在2_642_0(祈福学校宿舍)、2_444_0(广地花园-D)掉话3次、2_420_2(锦绣香江-D）、2_420_1(锦绣香江-D)和2_646_1（迎宾酒店-D）小区上。CDR分析从接入延迟发现2_642_0(祈福学校宿舍)接入时延较大，在4公里左右，为越区覆盖，而释放小区2_444_0(广地花园-D)和2_420_1(锦绣香江-D)的最后一条PSMM上报的导频数目都大于4个，导频强度在-12.5db以上，该区域为导频污染所致。,Page 21,3.CDR应用案例2导频污染导致掉话分析,CDR分析从接入延迟发现2_642_0(祈福学校宿舍)接入时延较大，在4公里左右，而释放小区广地花园-D)和锦绣香江-D的最后一条PSMM上报的导频数目都大于4个，导频强度在-12.5db以上，该区域为导频污染所致。处理建议：对2_642_0_0(祈福学校宿舍)下调下倾角或是降导频功率1db，2_444_0_0(广地花园-D)和2_420_1_0(锦绣香江-D)、2_420_2_0(锦绣香江-D)各降导频功率1db。,
