告警监控核查文档

文档状态：___正式版__保密级别：内部资料亿阳信通亿阳信通告警监控核查文档版权属于亿阳信通所有，无亿阳信通的书面同意，任何个人或组织无权拷贝目录TOC\o"1-4"\h\z\u1告警监控 21.1告警监控首页 21.1.1告警统计 21.1.2派单统计 91.1.3关联统计 91.1.4右侧告警柱状图 91.1.5右侧派单柱状图 91.1.6右侧关联统计柱状图 91.2当班人员窗口/自定义窗口 91.2.1功能简单介绍 91.2.2右键设置功能 91.3专题监控 91.3.1功能模块简介 91.3.2右键设置功能 91.4告警过程监控 91.5告警效能监控 9告警查询 9告警统计 10告警设置 10过滤器管理 10告警规则管理 10告警关联规则 10告警采集管理 10告警视图管理 10告警容量和预装设置 10告警经验库管理 10告警标准化管理 101告警监控1.1告警监控首页1.1.1告警统计核心网核查功能点名称核心网告警统计矩阵中‘一级设备告警’、‘一级性能告警’对应的JAVA服务告警统计服务配置文件所在目录无配置文件名称无数据来源来源于告警统计服务用到的库表fmdb：tfa_alarm_act(详情表)核查sql核心网：‘一级设备告警’数核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(102,108,130,131,600)andweek_of_daybetween1and7andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=1andnetwork_type=1andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)对应告警详情1）来自于告警统计服务一级性能告警’核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(102,108,130,131,600)--使用的是告警的eqp_object_classandactive_status=1andorg_severity=1andorg_type=2unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=1andnetwork_type=1andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typein(2,3,100)对应告警详情1）来自于告警统计服务此矩阵主要是统计一级活动告警,以下是一，二，三，四级告警级别条件,仅供参考：查找出一级告警的活动告警数量：通过ORG_SEVERITY=1andactive_status=1统计查找出二级告警的活动告警数量：通过ORG_SEVERITY=2andactive_status=1统计查找出三级告警的活动告警数量：通过ORG_SEVERITY=3andactive_status=1统计查找出四级告警的活动告警数量：通过ORG_SEVERITY=4andactive_status=1统计专业：话务网：professional_type=1数据网：professional_type=2传输网：professional_type=3动环：professional_type=4告警类别：select*fromtia_alarm_dictwheretype=7设备告警：org_type=非2、3、100性能告警：org_type=2专业网管性能告警：org_type=3综合监控性能告警：org_type=100核查步骤告警统计矩阵中专业为核心网的‘一级设备告警’，‘一级性能告警’，执行上述各指标sql语句（序号A），查看结果；检查结果是否与界面呈现一致。点击单元格后，在告警流水窗显示告警明细。以核心网一级设备告警数单元格为例。输出结果矩阵上核心网的‘一级设备告警’，‘一级性能告警’TD无线网核查功能点名称TD无线网告警统计矩阵中‘一级设备告警’、‘一级性能告警’对应的JAVA服务告警统计服务配置文件所在目录无配置文件名称无数据来源来源于告警统计服务用到的库表fmdb：tfa_alarm_act(详情表)核查sqlTD无线网：‘一级设备告警’数核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(9200,9201,9300)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=1andnetwork_type=2andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)对应告警详情1）来自于告警统计服务一级性能告警’核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(9200,9201,9300)andactive_status=1andorg_severity=1andorg_typein(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=1andnetwork_type=2andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typein(2,3,100)对应告警详情1）来自于告警统计服务此矩阵主要是统计一级活动告警,以下是一，二，三，四级告警级别条件,仅供参考：查找出一级告警的活动告警数量：通过ORG_SEVERITY=1andactive_status=1统计查找出二级告警的活动告警数量：通过ORG_SEVERITY=2andactive_status=1统计查找出三级告警的活动告警数量：通过ORG_SEVERITY=3andactive_status=1统计查找出四级告警的活动告警数量：通过ORG_SEVERITY=4andactive_status=1统计专业：话务网：professional_type=1数据网：professional_type=2传输网：professional_type=3动环：professional_type=4告警类别：select*fromtia_alarm_dictwheretype=7设备告警：org_type=非2、3、100性能告警：org_type=2专业网管性能告警：org_type=3综合监控性能告警：org_type=100核查步骤告警统计矩阵中专业为TD无线网的‘一级设备告警’，‘一级性能告警’执行上述各指标sql语句（序号A），查看结果；检查结果是否与界面呈现一致。点击单元格后，在告警流水窗显示告警明细。以核心网一级设备告警数单元格为例。输出结果矩阵上核心网的‘一级设备告警’，‘一级性能告警’2G无线网核查功能点名称2G无线网告警统计矩阵中‘一级设备告警’、‘一级性能告警’对应的JAVA服务告警统计服务配置文件所在目录无配置文件名称无数据来源来源于告警统计服务用到的库表fmdb：tfa_alarm_act(详情表)核查sql2G无线网：‘一级设备告警’数核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(200,201,300)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=1andnetwork_type=3andobject_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)对应告警详情1）来自于告警统计服务一级性能告警’核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(200,201,300)andactive_status=1andorg_severity=1andorg_typein(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=1andnetwork_type=3andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typein(2,3,100)对应告警详情1）来自于告警统计服务此矩阵主要是统计一级活动告警,以下是一，二，三，四级告警级别条件,仅供参考：查找出一级告警的活动告警数量：通过ORG_SEVERITY=1andactive_status=1统计查找出二级告警的活动告警数量：通过ORG_SEVERITY=2andactive_status=1统计查找出三级告警的活动告警数量：通过ORG_SEVERITY=3andactive_status=1统计查找出四级告警的活动告警数量：通过ORG_SEVERITY=4andactive_status=1统计专业：话务网：professional_type=1数据网：professional_type=2传输网：professional_type=3动环：professional_type=4告警类别：select*fromtia_alarm_dictwheretype=7设备告警：org_type=非2、3、100性能告警：org_type=2专业网管性能告警：org_type=3综合监控性能告警：org_type=100核查步骤告警统计矩阵中专业为2G无线网的‘一级设备告警’，‘一级性能告警’，执行上述各指标sql语句（序号A），查看结果；检查结果是否与界面呈现一致。点击单元格后，在告警流水窗显示告警明细。以核心网一级设备告警数单元格为例。输出结果矩阵上核心网的‘一级设备告警’，‘一级性能告警’数据网核查功能点名称数据网告警统计矩阵中‘一级设备告警’、‘一级性能告警’对应的JAVA服务告警统计服务配置文件所在目录无配置文件名称无数据来源来源于告警统计服务用到的库表fmdb：tfa_alarm_act(详情表)核查sql数据网：‘一级设备告警’数核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(121,502,900,901,905,1001,1002)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=2andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)对应告警详情1）来自于告警统计服务一级性能告警’核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(121,502,900,901,905,1001,1002)andactive_status=1andorg_severity=1andorg_typein(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=2andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typein(2,3,100)对应告警详情1）来自于告警统计服务此矩阵主要是统计一级活动告警,以下是一，二，三，四级告警级别条件,仅供参考：查找出一级告警的活动告警数量：通过ORG_SEVERITY=1andactive_status=1统计查找出二级告警的活动告警数量：通过ORG_SEVERITY=2andactive_status=1统计查找出三级告警的活动告警数量：通过ORG_SEVERITY=3andactive_status=1统计查找出四级告警的活动告警数量：通过ORG_SEVERITY=4andactive_status=1统计专业：话务网：professional_type=1数据网：professional_type=2传输网：professional_type=3动环：professional_type=4告警类别：select*fromtia_alarm_dictwheretype=7设备告警：org_type=非2、3、100性能告警：org_type=2专业网管性能告警：org_type=3综合监控性能告警：org_type=100核查步骤告警统计矩阵中专业为数据网的‘一级设备告警’，‘一级性能告警’，执行上述各指标sql语句（序号A），查看结果；检查结果是否与界面呈现一致。点击单元格后，在告警流水窗显示告警明细。以核心网一级设备告警数单元格为例。输出结果矩阵上核心网的‘一级设备告警’，‘一级性能告警’传输网核查功能点名称传输网告警统计矩阵中‘一级设备告警’、‘一级性能告警’对应的JAVA服务告警统计服务配置文件所在目录无配置文件名称无数据来源来源于告警统计服务用到的库表fmdb：tfa_alarm_act(详情表)核查sql传输网：‘一级设备告警’数核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(2001,2008,2011,2012,2030,2031)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=3andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)对应告警详情1）来自于告警统计服务一级性能告警’核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(2001,2008,2011,2012,2030,2031)andactive_status=1andorg_severity=1andorg_typein(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=3andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typein(2,3,100)对应告警详情1）来自于告警统计服务此矩阵主要是统计一级活动告警,以下是一，二，三，四级告警级别条件,仅供参考：查找出一级告警的活动告警数量：通过ORG_SEVERITY=1andactive_status=1统计查找出二级告警的活动告警数量：通过ORG_SEVERITY=2andactive_status=1统计查找出三级告警的活动告警数量：通过ORG_SEVERITY=3andactive_status=1统计查找出四级告警的活动告警数量：通过ORG_SEVERITY=4andactive_status=1统计专业：话务网：professional_type=1数据网：professional_type=2传输网：professional_type=3动环：professional_type=4告警类别：select*fromtia_alarm_dictwheretype=7设备告警：org_type=非2、3、100性能告警：org_type=2专业网管性能告警：org_type=3综合监控性能告警：org_type=100核查步骤告警统计矩阵中专业为传输网的‘一级设备告警’，‘一级性能告警’，执行上述各指标sql语句（序号A），查看结果；检查结果是否与界面呈现一致。点击单元格后，在告警流水窗显示告警明细。以核心网一级设备告警数单元格为例。输出结果矩阵上核心网的‘一级设备告警’，‘一级性能告警’动环网核查功能点名称动环网告警统计矩阵中‘一级设备告警’、‘一级性能告警’对应的JAVA服务告警统计服务配置文件所在目录无配置文件名称无数据来源来源于告警统计服务用到的库表fmdb：tfa_alarm_act(详情表)核查sql动环网：‘一级设备告警’数核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=4andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typenotin(2,3,100)对应告警详情1）来自于告警统计服务一级性能告警’核查sql：selectcount(*)fromstd_fmdb.tfa_alarm_actwhereeqp_object_classin(30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typein(2,3,100)unionallselectcount(*)fromstd_fmdb.tfa_alarm_actwhereprofessional_type=4andeqp_object_classnotin(102,108,130,131,600,200,201,300,9200,9201,9300,121,502,900,901,905,1001,1002,2001,2008,2011,2012,2030,2031,30004,30005,30007,30008,30011,30012,30014,30015,30016,30020,30021,30044)andactive_status=1andorg_severity=1andorg_typein(2,3,100)对应告警详情1）来自于告警统计服务此矩阵主要是统计一级活动告警,以下是一，二，三，四级告警级别条件,仅供参考：查找出一级告警的活动告警数量：通过ORG_SEVERITY=1andactive_status=1统计查找出二级告警的活动告警数量：通过ORG_SEVERITY=2andactive_status=1统计查找出三级告警的活动告警数量：通过ORG_SEVERITY=3andactive_status=1统计查找出四级告警的活动告警数量：通过ORG_SEVERITY=4andactive_status=1统计专业：话务网：professional_type=1数据网：professional_type=2传输网：professional_type=3动环：professional_type=4告警类别：select*fromtia_alarm_dictwheretype=7设备告警：org_type=非2、3、100性能告警：org_type=2专业网管性能告警：org_type=3综合监控性能告警：org_type=100核查步骤告警统计矩阵中专业为动环网的‘一级设备告警’，‘一级性能告警’，执行上述各指标sql语句（序号A），查看结果；检查结果是否与界面呈现一致。点击单元格后，在告警流水窗显示告警明细。以核心网一级设备告警数单元格为例。输出结果矩阵上核心网的‘一级设备告警’，‘一级性能告警’1.1.2派单统计核查功能点名称派单统计矩阵配置文件所在目录场景监控wcf服务配置文件C:\ProgramFiles\亿阳信通\场景监控wcf服务\Config\配置文件名称场景WCF服务的SheetStatisticsConfig.xml数据来源来自WCF服务的资源服务用到的库表Nmosdb：tfa_alarmsheetinfo核查sql按专业统计的‘工单数’，‘在处理工单数’，‘超时工单数’的sql。已派工单数：Selecttrunc(forward_time),professional_type,Count(*)Fromtfa_alarmsheetinfoWheresheet_status

in(1,2,3,4,5,7,8,9,10,31,32,33)Andsheet_noisnotnullandforward_time>=trunc(sysdate)-1--默认查看最近24小时的汇总数据groupbytrunc(forward_time),professional_type在处理工单数Selecttrunc(forward_time),professional_type,Count(*)Fromtfa_alarmsheetinfoWheresheet_status

in(1,2,3,4,7,8,9,10,31,32,33)Andsheet_noisnotnullandforward_time>=trunc(sysdate)-1--默认查看最近24小时的汇总数据groupbytrunc(forward_time),professional_type超时工单数Selecttrunc(forward_time),professional_type,Count(*)Fromtfa_alarmsheetinfoWheresheet_status

in(1,2,3,4,7,8,9,10,31,32,33)anddeal_time_limit>=sysdateAndsheet_noisnotnullandforward_time>=trunc(sysdate)-1--默认查看最近24小时的汇总数据groupbytrunc(forward_time),professional_type2、说明：select*fromtia_alarm_dictwheretype=1029专业字典数据：话务网：professional_type=1数据网：professional_type=2传输网：professional_type=3动环：professional_type=4核查步骤执行按话音专业，数据专业，传输专业，动环专业统计的‘工单数’，‘在处理工单数’，‘超时工单数’的sql，查看界面呈现结果是否与sql执行结果一致。输出结果派单统计矩阵上的‘专业’‘派单数’，‘在处理工单数’，‘超时工单数’1.1.3关联告警统计基站跨专业、其他跨专业、专业内监控、故障关联预判核查功能点名称关联告警统计矩阵中类别为：基站跨专业、其他跨专业、专业内监控、故障关联预判配置文件所在目录无配置文件名称无数据来源关联服务用到的库表nmosdb：tfa_alarm_act、tfa_alarm_relation、tfa_gaia_rule_maping_topic核查sql1、关联前告警：子告警数目+主告警数目（排除即为主也为子的告警数目）子告警数目：Selectc.topic_id,count(distincta.CORR_ALARM_FP0)Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andc.topic_idin(1007,1003,1004,1005)Anda.CORR_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDGroupbyc.topic_idUnionallSelect1007c.topic_id,count(distincta.CORR_ALARM_FP0)Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andc.topic_idnotin(1007,1003,1004,1005)Anda.CORR_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDGroupbyc.topic_id主告警数目（排除即为主也为子的告警数目）Selectc.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relsa,tfa_alarm_actb,,tfa_gaia_rule_maping_topiccWhereb.active_status=1andc.topic_idin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDAnda.ORIG_ALARM_FP0notin(selectdistinctCORR_ALARM_FP0fromtfa_alarm_relation)Groupbyc.topic_idUnionallSelect1007c.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relsa,tfa_alarm_actb,,tfa_gaia_rule_maping_topiccWhereb.active_status=1andc.topic_idnotin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDAnda.ORIG_ALARM_FP0notin(selectdistinctCORR_ALARM_FP0fromtfa_alarm_relation)Groupbya.topic_id2、关联后告警：Selectc.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relsa,tfa_alarm_actb,,tfa_gaia_rule_maping_topiccWhereb.active_status=1andc.topic_idin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDGroupbyc.topic_idUnionallSelect1007c.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relsa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andc.topic_idnotin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDGroupbya.topic_id3、关联派单告警数：所有主告警和衍生告警已派单的告警数量Selectc.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andc.topic_idin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDAndb.SHEET_SEND_STATUSin(5,6,7)Groupbyc.topic_idSelect1007c.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andc.topic_idnotin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDAndb.SHEET_SEND_STATUSin(5,6,7)Groupbyc.topic_id4、等待派单告警数：该专业内所有等待派单的主告警和衍生告警数量Selectc.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andb.SHEET_SEND_STATUS=1Andc.topic_idin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDGroupbyc.topic_idUnionallSelect1007c.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andb.SHEET_SEND_STATUS=1Andc.topic_idnotin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDGroupbyc.topic_idUnionall5、工程抑制派单数：Selectc.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andb.SHEET_SEND_STATUS=3andb.unsend_reasonlike‘%工程%’Andc.topic_idin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDGroupbyc.topic_idUnionallSelect1007c.topic_id,count(distincta.ORIG_ALARM_FP0)Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andb.SHEET_SEND_STATUS=3andb.unsend_reasonlike‘%工程%’Andc.topic_idnotin(1007,1003,1004,1005)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDGroupbyc.topic_id6、各专业条件：专业内监控a.topic_id=1007基站跨专业a.topic_id=1003其他跨专业a.topic_id=1004故障关联预判a.topic_id=1005核查步骤基站跨专业、其他跨专业、专业内监控、故障关联预判，这四个专业的关联前告警，关联后告警，关联派单告警数，等待派单告警数的统计方法如上面sql。通过sql统计出的数据与界面上的数据不一定能对的上，原因是通过程序将一部分有问题的关联关系的告警过滤掉了，例如：a、死循环的告警要舍掉这种关联关系，1挂2,2挂3,3挂1.b、突发条件，act大部分主要条件没有的也要去掉。C、其他异常情况，d、统计的时间与核查时间的参与关联的告警数也不一定相同。因此不建议核查数量，通过有针对性的核查某些告警来进行验证。输出结果‘工程抑制派单数’仍保留。‘工程抑制派单数’仍保留。集团客户监控、集中性能监控核查功能点名称关联告警统计矩阵中类别为：集团客户监控、集中性能监控配置文件所在目录无配置文件名称无数据来源关联服务用到的库表nmosdb：tfa_alarm_act、tfa_alarm_relation、tfa_gaia_rule_maping_topic核查sql1、关联前告警：Selectcount(*)Fromtfa_alarm_actWhereactive_status=1andgcss_clientisnotnull;--集客告警--org_typein(2,3,100);--集中性能2、关联后告警：主告警+衍生告警+本身没有参与关联的集客告警或者集中性能告警Selectc.topic_id,count(distincta.ORIG_ALARM_FP0)--主告警+衍生告警Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWherec.topic_idin(1002,1006)1006是集中性能，1002是集客Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDAndb.active_status=1Groupbyc.topic_id;再加上本身没有参与关联的集客告警或者集中性能告警SelectCount(*)Fromtfa_alarm_actWhereactive_status=1andgcss_clientisnotnull--集客告警--andorg_typein(2,3,100)--集中性能andfp0notin(selectORIG_ALARM_FP0fromtfa_alarm_relation)andfp0notin(selectCORR_ALARM_FP0fromtfa_alarm_relation)3、关联派单告警数：已派单的主告警和衍生告警数量+未参与关联的已派单的告警数量Selectc.topic_id,count(distincta.ORIG_ALARM_FP0)--已派单的主告警+衍生告警Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.SHEET_SEND_STATUSin(5,6,7)Anda.topic_idin(1002,1006)1006是集中性能，1002是集客Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDAndb.active_status=1Groupbya.topic_id再加上本身没有参与关联的已派单集客告警或者集中性能告警SelectCount(*)Fromtfa_alarm_actbWhereb.active_status=1andb.gcss_clientisnotnull--集客告警--and_typein(2,3,100)--集中性能andfp0notin(selectORIG_ALARM_FP0fromtfa_alarm_relation)andfp0notin(selectCORR_ALARM_FP0fromtfa_alarm_relation)andb.SHEET_SEND_STATUSin(5,6,7);4、等待派单告警数：该专业内所有等待派单的告警数Selectcount(*)Fromtfa_alarm_actWhereb.active_status=1andSHEET_SEND_STATUS=1anda.gcss_clientisnotnull;--集客告警--and_typein(2,3,100)—集中性能5、工程抑制派单数：Selectc.topic_id,count(distinctmain_alarm_id)Fromtfa_alarm_relationa,tfa_alarm_actb,tfa_gaia_rule_maping_topiccWhereb.active_status=1andb.SHEET_SEND_STATUS=3andb.unsend_reasonlike‘%工程%’Andc.topic_idin(1002,1006)Anda.ORIG_ALARM_FP0=b.fp0Andc.rule_id=a.SER_FILE_IDGroupbyc.topic_id;6、各专业条件：集团客户监控a.topic_id=1002集中性能a.topic_id=1006核查步骤基站跨专业、其他跨专业、专业内监控、故障关联预判，这四个专业的关联前告警，关联后告警，关联派单告警数，等待派单告警数的统计方法如上面sql。通过sql统计出的数据与界面上的数据不一定能对的上，原因是通过程序将一部分有问题的关联关系的告警过滤掉了，例如：a、死循环的告警要舍掉这种关联关系，1挂2,2挂3,3挂1.b、突发条件，act大部分主要条件没有的也要去掉。C、其他异常情况。d、统计的时间与核查时间的参与关联的告警数也不一定相同。因此不建议核查数量，通过有针对性的核查某些告警来进行验证。输出结果‘工程抑制派单数’仍保留。‘工程抑制派单数’仍保留。1.1.4告警统计趋势图核查功能点名称告警统计趋势图配置文件所在目录/opt/xdpp/indicator/loader/indicator.loader-1.0.3/conf/数据来源JAVA服务的指标服务配置文件名称dbIndaicator.xml指标组260995066用到的库表Nmosdb:tpa_alarm_compress_sum、region_city_local核查sql汇总表解释：region_city_local表：主要用于找到province_name和province_id的关系。核查时先确定本省的.province_name和province_idtpa_alarm_compress_sum表：根据本省的province_id，在此表中找到本省的数据。通过以下sql分别计算各专业告警数。此表是汇总表。sql：数据/传输/动环网一级告警数：selectfirst_result,province_id,sum(total_alarm_num)fromtpa_alarm_compress_sumwhereprofessional_type=2--数据网--professional_type=3–-传输网--professional_type=4–-动环网andorg_severity=1–一级告警条件--andfirst_result>=sysdate-6groupbyfirst_result,province_id2g/3g无线/核心网一级告警数：selectfirst_result,province_id,sum(total_alarm_num)fromtpa_alarm_compress_sumwhereprofessional_type=1--话务网andorg_severity=1–一级告警条件andobject_classin(300,201,200)--2g无线网元类型--andobject_classin(9300,9201,9200)--2g无线网元类型--andeqp_object_classin(101,102,103,104,105,106,108,109,110,111,112,113,114,115,130,131)--核心网元类型--andfirst_result>=sysdate-1groupbyfirst_result,province_id一级告警总数数：selectfirst_result,province_id,sum(total_alarm_num)fromtpa_alarm_compress_sumwhereorg_severity=1–一级告警条件--andfirst_result>=sysdate-1groupbyfirst_result,province_id将上诉sql的org_severity=1去掉得出的结果就是1,2,3,4级告警总数。selectfirst_result,province_id,sum(total_alarm_num)fromtpa_alarm_compress_sumgroupbyfirst_result,province_id数据的整个sql如下：selectvince_idne_id,'贵州省'ne_name,10000ne_type,press_datefirst_result,sum(t.shuju1)VIRCOLUMN_01,sum(t.chuanshu1)VIRCOLUMN_02,sum(t.donghuan1)VIRCOLUMN_03,sum(t.wuxian2G1)VIRCOLUMN_04,sum(t.wuxian3G1)VIRCOLUMN_05,sum(t.hexinwang1)VIRCOLUMN_06,sum(t.yijigaojingzongshu)VIRCOLUMN_07,sum(t.shuju)VIRCOLUMN_08,sum(t.chuanshu)VIRCOLUMN_09,sum(t.donghuan)VIRCOLUMN_10,sum(t.wuxian2G)VIRCOLUMN_11,sum(t.wuxian3G)VIRCOLUMN_12,sum(t.hexinwang)VIRCOLUMN_13,sum(t.total_alarm)VIRCOLUMN_14from(selectvince_id,trunc(s.first_result)compress_date,sum(casewhenfessional_type=2and_severity=1thentotal_alarm_numelse0end)shuju1,sum(casewhenfessional_type=3and_severity=1thentotal_alarm_numelse0end)chuanshu1,sum(casewhenfessional_type=4and_severity=1thentotal_alarm_numelse0end)donghuan1,sum(casewhens.professional_type=1and_severity=1ands.object_classin(300,201,200)thentotal_alarm_numelse0end)wuxian2G1,sum(casewhens.professional_type=1and_severity=1ands.object_classin(9300,9201,9200)thentotal_alarm_numelse0end)wuxian3G1,sum(casewhenfessional_type=1and_severity=1ands.eqp_object_classin(101,102,103,104,105,106,108,109,110,111,112,113,114,115,130,131)thentotal_alarm_numelse0end)hexinwang1,sum(decode(_severity,1,total_alarm_num,0))yijigaojingzongshu,sum(decode(fessional_type,2,total_alarm_num,0))shuju,sum(decode(s.professional_type,3,total_alarm_num,0))chuanshu,sum(decode(s.professional_type,4,total_alarm_num,0))donghuan,sum(casewhens.professional_type=1ands.object_classin(300,201,200)thentotal_alarm_numelse0end)wuxian2G,sum(casewhens.professional_type=1ands.object_classin(9300,9201,9200)thentotal_alarm_numelse0end)wuxian3G,sum(casewhenfessional_type=1ands.eqp_object_classin(101,102,103,104,105,106,108,109,110,111,112,113,114,115,130,131)thentotal_alarm_numelse0end)hexinwang,sum(total_alarm_num)total_alarmfromtpa_alarm_compress_sumswheres.first_result>=sysdate-6ands.sum_level=1groupbyfirst_result,vince_id)t,(selectmax(province_id)province_id,max(province_name)province_namefromregion_city_local)pwherevince_id=vince_idgroupbypress_date,vince_id,vince_name核查步骤详细的资源统计核查方法为以下步骤：数据来自于JAVA服务的指标服务。在C:\ProgramFiles\亿阳信通\场景监控WCF服务\Config\DbIndaicatorConfig.xml文件中找到指标组id260995066。根据配置文件指标组中指标id，

<IndicatorDefineid="99506601"name="VIRCOLUMN_01"label="数据网"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506602"name="VIRCOLUMN_02"label="传输网"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506603"name="VIRCOLUMN_03"label="动环"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506604"name="VIRCOLUMN_04"label="2G无线"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506605"name="VIRCOLUMN_05"label="3G无线"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506606"name="VIRCOLUMN_06"label="核心网"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506607"name="VIRCOLUMN_07"label="一级告警总数"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506608"name="VIRCOLUMN_08"label="数据网"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506609"name="VIRCOLUMN_09"label="传输网"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506610"name="VIRCOLUMN_10"label="动环"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506611"name="VIRCOLUMN_11"label="2G无线"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506612"name="VIRCOLUMN_12"label="3G无线"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506613"name="VIRCOLUMN_13"label="核心网"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506614"name="VIRCOLUMN_14"label="告警总数"minvalue=""maxvalue=""gradechange="0"/>上述指标id01~07对应的是一级设备告警，08~14对应的是全部告警输出结果1.1.5派单统计视图核查功能点名称派单统计视图配置文件所在目录/opt/xdpp/indicator/loader/indicator.loader-1.0.3/conf/数据来源JAVA服务的指标服务配置文件名称dbindicator.xml指标组260995067用到的库表Nmosdb:tfa_alarmsheetinfo(用于派单统计)，region_city_local（用于取得本province_id）核查sql话务数据/传输/动环网派单总数：Selecttrunc(forward_time),Count(*)Fromtfa_alarmsheetinfoWhereprofessional_type=1--话务--professional_type=2--数据网--professional_type=3--传输网--professional_type=4--动环网Andsheet_noisnotnullandforward_time>=trunc(sysdate)-6groupbytrunc(forward_time)2、派单总数：Selecttrunc(forward_time),Count(*)Fromtfa_alarmsheetinfoWhereprofessional_typein(1,2,3,4)andsheet_noisnotnullandforward_time>=trunc(sysdate)-6groupbytrunc(forward_time)3、总sql：selectvince_idne_id,province_namene_name,10000ne_type,trunc(s.forward_time)first_result,sum(decode(fessional_type,1,1,0))VIRCOLUMN_01,--话务网sum(decode(fessional_type,2,1,0))VIRCOLUMN_02,--数据网sum(decode(s.professional_type,3,1,0))VIRCOLUMN_03,--传输sum(decode(s.professional_type,4,1,0))VIRCOLUMN_04,--动环count(*)VIRCOLUMN_05--总数fromnmosdb.tfa_alarmsheetinfos,(selectmax(province_id)province_id,max(province_name)province_namefromregion_city_local)p--主要用于取得本省province_idwhereforward_time>=trunc(sysdate)-6--默认最近6天ands.sheet_noisnotnullgroupbytrunc(forward_time),vince_id,vince_name核查步骤详细的资源统计核查方法为以下步骤：指标的数据来自于JAVA服务的指标服务，在/opt/xdpp/indicator/loader/indicator.loader-1.0.3/conf/DbIndaicator.xml文件中找到指标组id260995067。根据配置文件指标组中指标id，

<<<IndicatorGroup><IndicatorGroupDefineid="260995067"name="gezhuanyegongdanliang"label="各专业工单量"><IndicatorDefineid="99506701"name="VIRCOLUMN_01"label="话音网"minvalue=""maxvalue=""gradechange="0"/><IndicatorDefineid="99506702"name="VIRCOLUMN_02"label="数据网"minvalue=""maxvalue=""gradechan