告警監(jiān)控核查文檔

文檔狀態(tài)：___正式版__保密級(jí)別：內(nèi)部資料億陽信通億陽信通告警監(jiān)控核查文檔版權(quán)屬于億陽信通所有，無億陽信通的書面同意，任何個(gè)人或組織無權(quán)拷貝目錄TOC\o"1-4"\h\z\u1告警監(jiān)控 21.1告警監(jiān)控首頁 21.1.1告警統(tǒng)計(jì) 21.1.2派單統(tǒng)計(jì) 91.1.3關(guān)聯(lián)統(tǒng)計(jì) 91.1.4右側(cè)告警柱狀圖 91.1.5右側(cè)派單柱狀圖 91.1.6右側(cè)關(guān)聯(lián)統(tǒng)計(jì)柱狀圖 91.2當(dāng)班人員窗口/自定義窗口 91.2.1功能簡單介紹 91.2.2右鍵設(shè)置功能 91.3專題監(jiān)控 91.3.1功能模塊簡介 91.3.2右鍵設(shè)置功能 91.4告警過程監(jiān)控 91.5告警效能監(jiān)控 9告警查詢 9告警統(tǒng)計(jì) 10告警設(shè)置 10過濾器管理 10告警規(guī)則管理 10告警關(guān)聯(lián)規(guī)則 10告警采集管理 10告警視圖管理 10告警容量和預(yù)裝設(shè)置 10告警經(jīng)驗(yàn)庫管理 10告警標(biāo)準(zhǔn)化管理 101告警監(jiān)控1.1告警監(jiān)控首頁1.1.1告警統(tǒng)計(jì)核心網(wǎng)核查功能點(diǎn)名稱核心網(wǎng)告警統(tǒng)計(jì)矩陣中‘一級(jí)設(shè)備告警’、‘一級(jí)性能告警’對應(yīng)的JAVA服務(wù)告警統(tǒng)計(jì)服務(wù)配置文件所在目錄無配置文件名稱無數(shù)據(jù)來源來源于告警統(tǒng)計(jì)服務(wù)用到的庫表fmdb：tfa_alarm_act(詳情表)核查sql核心網(wǎng)：‘一級(jí)設(shè)備告警’數(shù)核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)一級(jí)性能告警’核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)此矩陣主要是統(tǒng)計(jì)一級(jí)活動(dòng)告警,以下是一，二，三，四級(jí)告警級(jí)別條件,僅供參考：查找出一級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=1andactive_status=1統(tǒng)計(jì)查找出二級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=2andactive_status=1統(tǒng)計(jì)查找出三級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=3andactive_status=1統(tǒng)計(jì)查找出四級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=4andactive_status=1統(tǒng)計(jì)專業(yè)：話務(wù)網(wǎng)：professional_type=1數(shù)據(jù)網(wǎng)：professional_type=2傳輸網(wǎng)：professional_type=3動(dòng)環(huán)：professional_type=4告警類別：select*fromtia_alarm_dictwheretype=7設(shè)備告警：org_type=非2、3、100性能告警：org_type=2專業(yè)網(wǎng)管性能告警：org_type=3綜合監(jiān)控性能告警：org_type=100核查步驟告警統(tǒng)計(jì)矩陣中專業(yè)為核心網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’，執(zhí)行上述各指標(biāo)sql語句（序號(hào)A），查看結(jié)果；檢查結(jié)果是否與界面呈現(xiàn)一致。點(diǎn)擊單元格后，在告警流水窗顯示告警明細(xì)。以核心網(wǎng)一級(jí)設(shè)備告警數(shù)單元格為例。輸出結(jié)果矩陣上核心網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’TD無線網(wǎng)核查功能點(diǎn)名稱TD無線網(wǎng)告警統(tǒng)計(jì)矩陣中‘一級(jí)設(shè)備告警’、‘一級(jí)性能告警’對應(yīng)的JAVA服務(wù)告警統(tǒng)計(jì)服務(wù)配置文件所在目錄無配置文件名稱無數(shù)據(jù)來源來源于告警統(tǒng)計(jì)服務(wù)用到的庫表fmdb：tfa_alarm_act(詳情表)核查sqlTD無線網(wǎng)：‘一級(jí)設(shè)備告警’數(shù)核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)一級(jí)性能告警’核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)此矩陣主要是統(tǒng)計(jì)一級(jí)活動(dòng)告警,以下是一，二，三，四級(jí)告警級(jí)別條件,僅供參考：查找出一級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=1andactive_status=1統(tǒng)計(jì)查找出二級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=2andactive_status=1統(tǒng)計(jì)查找出三級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=3andactive_status=1統(tǒng)計(jì)查找出四級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=4andactive_status=1統(tǒng)計(jì)專業(yè)：話務(wù)網(wǎng)：professional_type=1數(shù)據(jù)網(wǎng)：professional_type=2傳輸網(wǎng)：professional_type=3動(dòng)環(huán)：professional_type=4告警類別：select*fromtia_alarm_dictwheretype=7設(shè)備告警：org_type=非2、3、100性能告警：org_type=2專業(yè)網(wǎng)管性能告警：org_type=3綜合監(jiān)控性能告警：org_type=100核查步驟告警統(tǒng)計(jì)矩陣中專業(yè)為TD無線網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’執(zhí)行上述各指標(biāo)sql語句（序號(hào)A），查看結(jié)果；檢查結(jié)果是否與界面呈現(xiàn)一致。點(diǎn)擊單元格后，在告警流水窗顯示告警明細(xì)。以核心網(wǎng)一級(jí)設(shè)備告警數(shù)單元格為例。輸出結(jié)果矩陣上核心網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’2G無線網(wǎng)核查功能點(diǎn)名稱2G無線網(wǎng)告警統(tǒng)計(jì)矩陣中‘一級(jí)設(shè)備告警’、‘一級(jí)性能告警’對應(yīng)的JAVA服務(wù)告警統(tǒng)計(jì)服務(wù)配置文件所在目錄無配置文件名稱無數(shù)據(jù)來源來源于告警統(tǒng)計(jì)服務(wù)用到的庫表fmdb：tfa_alarm_act(詳情表)核查sql2G無線網(wǎng)：‘一級(jí)設(shè)備告警’數(shù)核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)一級(jí)性能告警’核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)此矩陣主要是統(tǒng)計(jì)一級(jí)活動(dòng)告警,以下是一，二，三，四級(jí)告警級(jí)別條件,僅供參考：查找出一級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=1andactive_status=1統(tǒng)計(jì)查找出二級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=2andactive_status=1統(tǒng)計(jì)查找出三級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=3andactive_status=1統(tǒng)計(jì)查找出四級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=4andactive_status=1統(tǒng)計(jì)專業(yè)：話務(wù)網(wǎng)：professional_type=1數(shù)據(jù)網(wǎng)：professional_type=2傳輸網(wǎng)：professional_type=3動(dòng)環(huán)：professional_type=4告警類別：select*fromtia_alarm_dictwheretype=7設(shè)備告警：org_type=非2、3、100性能告警：org_type=2專業(yè)網(wǎng)管性能告警：org_type=3綜合監(jiān)控性能告警：org_type=100核查步驟告警統(tǒng)計(jì)矩陣中專業(yè)為2G無線網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’，執(zhí)行上述各指標(biāo)sql語句（序號(hào)A），查看結(jié)果；檢查結(jié)果是否與界面呈現(xiàn)一致。點(diǎn)擊單元格后，在告警流水窗顯示告警明細(xì)。以核心網(wǎng)一級(jí)設(shè)備告警數(shù)單元格為例。輸出結(jié)果矩陣上核心網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’數(shù)據(jù)網(wǎng)核查功能點(diǎn)名稱數(shù)據(jù)網(wǎng)告警統(tǒng)計(jì)矩陣中‘一級(jí)設(shè)備告警’、‘一級(jí)性能告警’對應(yīng)的JAVA服務(wù)告警統(tǒng)計(jì)服務(wù)配置文件所在目錄無配置文件名稱無數(shù)據(jù)來源來源于告警統(tǒng)計(jì)服務(wù)用到的庫表fmdb：tfa_alarm_act(詳情表)核查sql數(shù)據(jù)網(wǎng)：‘一級(jí)設(shè)備告警’數(shù)核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)一級(jí)性能告警’核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)此矩陣主要是統(tǒng)計(jì)一級(jí)活動(dòng)告警,以下是一，二，三，四級(jí)告警級(jí)別條件,僅供參考：查找出一級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=1andactive_status=1統(tǒng)計(jì)查找出二級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=2andactive_status=1統(tǒng)計(jì)查找出三級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=3andactive_status=1統(tǒng)計(jì)查找出四級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=4andactive_status=1統(tǒng)計(jì)專業(yè)：話務(wù)網(wǎng)：professional_type=1數(shù)據(jù)網(wǎng)：professional_type=2傳輸網(wǎng)：professional_type=3動(dòng)環(huán)：professional_type=4告警類別：select*fromtia_alarm_dictwheretype=7設(shè)備告警：org_type=非2、3、100性能告警：org_type=2專業(yè)網(wǎng)管性能告警：org_type=3綜合監(jiān)控性能告警：org_type=100核查步驟告警統(tǒng)計(jì)矩陣中專業(yè)為數(shù)據(jù)網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’，執(zhí)行上述各指標(biāo)sql語句（序號(hào)A），查看結(jié)果；檢查結(jié)果是否與界面呈現(xiàn)一致。點(diǎn)擊單元格后，在告警流水窗顯示告警明細(xì)。以核心網(wǎng)一級(jí)設(shè)備告警數(shù)單元格為例。輸出結(jié)果矩陣上核心網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’傳輸網(wǎng)核查功能點(diǎn)名稱傳輸網(wǎng)告警統(tǒng)計(jì)矩陣中‘一級(jí)設(shè)備告警’、‘一級(jí)性能告警’對應(yīng)的JAVA服務(wù)告警統(tǒng)計(jì)服務(wù)配置文件所在目錄無配置文件名稱無數(shù)據(jù)來源來源于告警統(tǒng)計(jì)服務(wù)用到的庫表fmdb：tfa_alarm_act(詳情表)核查sql傳輸網(wǎng)：‘一級(jí)設(shè)備告警’數(shù)核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)一級(jí)性能告警’核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)此矩陣主要是統(tǒng)計(jì)一級(jí)活動(dòng)告警,以下是一，二，三，四級(jí)告警級(jí)別條件,僅供參考：查找出一級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=1andactive_status=1統(tǒng)計(jì)查找出二級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=2andactive_status=1統(tǒng)計(jì)查找出三級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=3andactive_status=1統(tǒng)計(jì)查找出四級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=4andactive_status=1統(tǒng)計(jì)專業(yè)：話務(wù)網(wǎng)：professional_type=1數(shù)據(jù)網(wǎng)：professional_type=2傳輸網(wǎng)：professional_type=3動(dòng)環(huán)：professional_type=4告警類別：select*fromtia_alarm_dictwheretype=7設(shè)備告警：org_type=非2、3、100性能告警：org_type=2專業(yè)網(wǎng)管性能告警：org_type=3綜合監(jiān)控性能告警：org_type=100核查步驟告警統(tǒng)計(jì)矩陣中專業(yè)為傳輸網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’，執(zhí)行上述各指標(biāo)sql語句（序號(hào)A），查看結(jié)果；檢查結(jié)果是否與界面呈現(xiàn)一致。點(diǎn)擊單元格后，在告警流水窗顯示告警明細(xì)。以核心網(wǎng)一級(jí)設(shè)備告警數(shù)單元格為例。輸出結(jié)果矩陣上核心網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’動(dòng)環(huán)網(wǎng)核查功能點(diǎn)名稱動(dòng)環(huán)網(wǎng)告警統(tǒng)計(jì)矩陣中‘一級(jí)設(shè)備告警’、‘一級(jí)性能告警’對應(yīng)的JAVA服務(wù)告警統(tǒng)計(jì)服務(wù)配置文件所在目錄無配置文件名稱無數(shù)據(jù)來源來源于告警統(tǒng)計(jì)服務(wù)用到的庫表fmdb：tfa_alarm_act(詳情表)核查sql動(dòng)環(huán)網(wǎng)：‘一級(jí)設(shè)備告警’數(shù)核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)一級(jí)性能告警’核查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)對應(yīng)告警詳情1）來自于告警統(tǒng)計(jì)服務(wù)此矩陣主要是統(tǒng)計(jì)一級(jí)活動(dòng)告警,以下是一，二，三，四級(jí)告警級(jí)別條件,僅供參考：查找出一級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=1andactive_status=1統(tǒng)計(jì)查找出二級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=2andactive_status=1統(tǒng)計(jì)查找出三級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=3andactive_status=1統(tǒng)計(jì)查找出四級(jí)告警的活動(dòng)告警數(shù)量：通過ORG_SEVERITY=4andactive_status=1統(tǒng)計(jì)專業(yè)：話務(wù)網(wǎng)：professional_type=1數(shù)據(jù)網(wǎng)：professional_type=2傳輸網(wǎng)：professional_type=3動(dòng)環(huán)：professional_type=4告警類別：select*fromtia_alarm_dictwheretype=7設(shè)備告警：org_type=非2、3、100性能告警：org_type=2專業(yè)網(wǎng)管性能告警：org_type=3綜合監(jiān)控性能告警：org_type=100核查步驟告警統(tǒng)計(jì)矩陣中專業(yè)為動(dòng)環(huán)網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’，執(zhí)行上述各指標(biāo)sql語句（序號(hào)A），查看結(jié)果；檢查結(jié)果是否與界面呈現(xiàn)一致。點(diǎn)擊單元格后，在告警流水窗顯示告警明細(xì)。以核心網(wǎng)一級(jí)設(shè)備告警數(shù)單元格為例。輸出結(jié)果矩陣上核心網(wǎng)的‘一級(jí)設(shè)備告警’，‘一級(jí)性能告警’1.1.2派單統(tǒng)計(jì)核查功能點(diǎn)名稱派單統(tǒng)計(jì)矩陣配置文件所在目錄場景監(jiān)控wcf服務(wù)配置文件C:\ProgramFiles\億陽信通\場景監(jiān)控wcf服務(wù)\Config\配置文件名稱場景WCF服務(wù)的SheetStatisticsConfig.xml數(shù)據(jù)來源來自WCF服務(wù)的資源服務(wù)用到的庫表Nmosdb：tfa_alarmsheetinfo核查sql按專業(yè)統(tǒng)計(jì)的‘工單數(shù)’，‘在處理工單數(shù)’，‘超時(shí)工單數(shù)’的sql。已派工單數(shù)：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--默認(rèn)查看最近24小時(shí)的匯總數(shù)據(jù)groupbytrunc(forward_time),professional_type在處理工單數(shù)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--默認(rèn)查看最近24小時(shí)的匯總數(shù)據(jù)groupbytrunc(forward_time),professional_type超時(shí)工單數(shù)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--默認(rèn)查看最近24小時(shí)的匯總數(shù)據(jù)groupbytrunc(forward_time),professional_type2、說明：select*fromtia_alarm_dictwheretype=1029專業(yè)字典數(shù)據(jù)：話務(wù)網(wǎng)：professional_type=1數(shù)據(jù)網(wǎng)：professional_type=2傳輸網(wǎng)：professional_type=3動(dòng)環(huán)：professional_type=4核查步驟執(zhí)行按話音專業(yè)，數(shù)據(jù)專業(yè)，傳輸專業(yè)，動(dòng)環(huán)專業(yè)統(tǒng)計(jì)的‘工單數(shù)’，‘在處理工單數(shù)’，‘超時(shí)工單數(shù)’的sql，查看界面呈現(xiàn)結(jié)果是否與sql執(zhí)行結(jié)果一致。輸出結(jié)果派單統(tǒng)計(jì)矩陣上的‘專業(yè)’‘派單數(shù)’，‘在處理工單數(shù)’，‘超時(shí)工單數(shù)’1.1.3關(guān)聯(lián)告警統(tǒng)計(jì)基站跨專業(yè)、其他跨專業(yè)、專業(yè)內(nèi)監(jiān)控、故障關(guān)聯(lián)預(yù)判核查功能點(diǎn)名稱關(guān)聯(lián)告警統(tǒng)計(jì)矩陣中類別為：基站跨專業(yè)、其他跨專業(yè)、專業(yè)內(nèi)監(jiān)控、故障關(guān)聯(lián)預(yù)判配置文件所在目錄無配置文件名稱無數(shù)據(jù)來源關(guān)聯(lián)服務(wù)用到的庫表nmosdb：tfa_alarm_act、tfa_alarm_relation、tfa_gaia_rule_maping_topic核查sql1、關(guān)聯(lián)前告警：子告警數(shù)目+主告警數(shù)目（排除即為主也為子的告警數(shù)目）子告警數(shù)目：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主告警數(shù)目（排除即為主也為子的告警數(shù)目）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、關(guān)聯(lián)后告警：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、關(guān)聯(lián)派單告警數(shù)：所有主告警和衍生告警已派單的告警數(shù)量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、等待派單告警數(shù)：該專業(yè)內(nèi)所有等待派單的主告警和衍生告警數(shù)量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、工程抑制派單數(shù)：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、各專業(yè)條件：專業(yè)內(nèi)監(jiān)控a.topic_id=1007基站跨專業(yè)a.topic_id=1003其他跨專業(yè)a.topic_id=1004故障關(guān)聯(lián)預(yù)判a.topic_id=1005核查步驟基站跨專業(yè)、其他跨專業(yè)、專業(yè)內(nèi)監(jiān)控、故障關(guān)聯(lián)預(yù)判，這四個(gè)專業(yè)的關(guān)聯(lián)前告警，關(guān)聯(lián)后告警，關(guān)聯(lián)派單告警數(shù)，等待派單告警數(shù)的統(tǒng)計(jì)方法如上面sql。通過sql統(tǒng)計(jì)出的數(shù)據(jù)與界面上的數(shù)據(jù)不一定能對的上，原因是通過程序?qū)⒁徊糠钟袉栴}的關(guān)聯(lián)關(guān)系的告警過濾掉了，例如：a、死循環(huán)的告警要舍掉這種關(guān)聯(lián)關(guān)系，1掛2,2掛3,3掛1.b、突發(fā)條件，act大部分主要條件沒有的也要去掉。C、其他異常情況，d、統(tǒng)計(jì)的時(shí)間與核查時(shí)間的參與關(guān)聯(lián)的告警數(shù)也不一定相同。因此不建議核查數(shù)量，通過有針對性的核查某些告警來進(jìn)行驗(yàn)證。輸出結(jié)果‘工程抑制派單數(shù)’仍保留?！こ桃种婆蓡螖?shù)’仍保留。集團(tuán)客戶監(jiān)控、集中性能監(jiān)控核查功能點(diǎn)名稱關(guān)聯(lián)告警統(tǒng)計(jì)矩陣中類別為：集團(tuán)客戶監(jiān)控、集中性能監(jiān)控配置文件所在目錄無配置文件名稱無數(shù)據(jù)來源關(guān)聯(lián)服務(wù)用到的庫表nmosdb：tfa_alarm_act、tfa_alarm_relation、tfa_gaia_rule_maping_topic核查sql1、關(guān)聯(lián)前告警：Selectcount(*)Fromtfa_alarm_actWhereactive_status=1andgcss_clientisnotnull;--集客告警--org_typein(2,3,100);--集中性能2、關(guān)聯(lián)后告警：主告警+衍生告警+本身沒有參與關(guān)聯(lián)的集客告警或者集中性能告警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;再加上本身沒有參與關(guān)聯(lián)的集客告警或者集中性能告警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、關(guān)聯(lián)派單告警數(shù)：已派單的主告警和衍生告警數(shù)量+未參與關(guān)聯(lián)的已派單的告警數(shù)量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再加上本身沒有參與關(guān)聯(lián)的已派單集客告警或者集中性能告警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、等待派單告警數(shù)：該專業(yè)內(nèi)所有等待派單的告警數(shù)Selectcount(*)Fromtfa_alarm_actWhereb.active_status=1andSHEET_SEND_STATUS=1anda.gcss_clientisnotnull;--集客告警--and_typein(2,3,100)—集中性能5、工程抑制派單數(shù)：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、各專業(yè)條件：集團(tuán)客戶監(jiān)控a.topic_id=1002集中性能a.topic_id=1006核查步驟基站跨專業(yè)、其他跨專業(yè)、專業(yè)內(nèi)監(jiān)控、故障關(guān)聯(lián)預(yù)判，這四個(gè)專業(yè)的關(guān)聯(lián)前告警，關(guān)聯(lián)后告警，關(guān)聯(lián)派單告警數(shù)，等待派單告警數(shù)的統(tǒng)計(jì)方法如上面sql。通過sql統(tǒng)計(jì)出的數(shù)據(jù)與界面上的數(shù)據(jù)不一定能對的上，原因是通過程序?qū)⒁徊糠钟袉栴}的關(guān)聯(lián)關(guān)系的告警過濾掉了，例如：a、死循環(huán)的告警要舍掉這種關(guān)聯(lián)關(guān)系，1掛2,2掛3,3掛1.b、突發(fā)條件，act大部分主要條件沒有的也要去掉。C、其他異常情況。d、統(tǒng)計(jì)的時(shí)間與核查時(shí)間的參與關(guān)聯(lián)的告警數(shù)也不一定相同。因此不建議核查數(shù)量，通過有針對性的核查某些告警來進(jìn)行驗(yàn)證。輸出結(jié)果‘工程抑制派單數(shù)’仍保留?！こ桃种婆蓡螖?shù)’仍保留。1.1.4告警統(tǒng)計(jì)趨勢圖核查功能點(diǎn)名稱告警統(tǒng)計(jì)趨勢圖配置文件所在目錄/opt/xdpp/indicator/loader/indicator.loader-1.0.3/conf/數(shù)據(jù)來源JAVA服務(wù)的指標(biāo)服務(wù)配置文件名稱dbIndaicator.xml指標(biāo)組260995066用到的庫表Nmosdb:tpa_alarm_compress_sum、region_city_local核查sql匯總表解釋：region_city_local表：主要用于找到province_name和province_id的關(guān)系。核查時(shí)先確定本省的.province_name和province_idtpa_alarm_compress_sum表：根據(jù)本省的province_id，在此表中找到本省的數(shù)據(jù)。通過以下sql分別計(jì)算各專業(yè)告警數(shù)。此表是匯總表。sql：數(shù)據(jù)/傳輸/動(dòng)環(huán)網(wǎng)一級(jí)告警數(shù)：selectfirst_result,province_id,sum(total_alarm_num)fromtpa_alarm_compress_sumwhereprofessional_type=2--數(shù)據(jù)網(wǎng)--professional_type=3–-傳輸網(wǎng)--professional_type=4–-動(dòng)環(huán)網(wǎng)andorg_severity=1–一級(jí)告警條件--andfirst_result>=sysdate-6groupbyfirst_result,province_id2g/3g無線/核心網(wǎng)一級(jí)告警數(shù)：selectfirst_result,province_id,sum(total_alarm_num)fromtpa_alarm_compress_sumwhereprofessional_type=1--話務(wù)網(wǎng)andorg_severity=1–一級(jí)告警條件andobject_classin(300,201,200)--2g無線網(wǎng)元類型--andobject_classin(9300,9201,9200)--2g無線網(wǎng)元類型--andeqp_object_classin(101,102,103,104,105,106,108,109,110,111,112,113,114,115,130,131)--核心網(wǎng)元類型--andfirst_result>=sysdate-1groupbyfirst_result,province_id一級(jí)告警總數(shù)數(shù)：selectfirst_result,province_id,sum(total_alarm_num)fromtpa_alarm_compress_sumwhereorg_severity=1–一級(jí)告警條件--andfirst_result>=sysdate-1groupbyfirst_result,province_id將上訴sql的org_severity=1去掉得出的結(jié)果就是1,2,3,4級(jí)告警總數(shù)。selectfirst_result,province_id,sum(total_alarm_num)fromtpa_alarm_compress_sumgroupbyfirst_result,province_id數(shù)據(jù)的整個(gè)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核查步驟詳細(xì)的資源統(tǒng)計(jì)核查方法為以下步驟：數(shù)據(jù)來自于JAVA服務(wù)的指標(biāo)服務(wù)。在C:\ProgramFiles\億陽信通\場景監(jiān)控WCF服務(wù)\Config\DbIndaicatorConfig.xml文件中找到指標(biāo)組id260995066。根據(jù)配置文件指標(biāo)組中指標(biāo)id，

<IndicatorDefineid="99506601"name="VIRCOLUMN_01"label="數(shù)據(jù)網(wǎng)"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506602"name="VIRCOLUMN_02"label="傳輸網(wǎng)"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506603"name="VIRCOLUMN_03"label="動(dòng)環(huán)"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="核心網(wǎng)"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506607"name="VIRCOLUMN_07"label="一級(jí)告警總數(shù)"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506608"name="VIRCOLUMN_08"label="數(shù)據(jù)網(wǎng)"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506609"name="VIRCOLUMN_09"label="傳輸網(wǎng)"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506610"name="VIRCOLUMN_10"label="動(dòng)環(huán)"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="核心網(wǎng)"minvalue=""maxvalue=""gradechange="0"/>

<IndicatorDefineid="99506614"name="VIRCOLUMN_14"label="告警總數(shù)"minvalue=""maxvalue=""gradechange="0"/>上述指標(biāo)id01~07對應(yīng)的是一級(jí)設(shè)備告警，08~14對應(yīng)的是全部告警輸出結(jié)果1.1.5派單統(tǒng)計(jì)視圖核查功能點(diǎn)名稱派單統(tǒng)計(jì)視圖配置文件所在目錄/opt/xdpp/indicator/loader/indicator.loader-1.0.3/conf/數(shù)據(jù)來源JAVA服務(wù)的指標(biāo)服務(wù)配置文件名稱dbindicator.xml指標(biāo)組260995067用到的庫表Nmosdb:tfa_alarmsheetinfo(用于派單統(tǒng)計(jì))，region_city_local（用于取得本province_id）核查sql話務(wù)數(shù)據(jù)/傳輸/動(dòng)環(huán)網(wǎng)派單總數(shù)：Selecttrunc(forward_time),Count(*)Fromtfa_alarmsheetinfoWhereprofessional_type=1--話務(wù)--professional_type=2--數(shù)據(jù)網(wǎng)--professional_type=3--傳輸網(wǎng)--professional_type=4--動(dòng)環(huán)網(wǎng)Andsheet_noisnotnullandforward_time>=trunc(sysdate)-6groupbytrunc(forward_time)2、派單總數(shù)：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,--話務(wù)網(wǎng)sum(decode(fessional_type,2,1,0))VIRCOLUMN_02,--數(shù)據(jù)網(wǎng)sum(decode(s.professional_type,3,1,0))VIRCOLUMN_03,--傳輸sum(decode(s.professional_type,4,1,0))VIRCOLUMN_04,--動(dòng)環(huán)count(*)VIRCOLUMN_05--總數(shù)fromnmosdb.tfa_alarmsheetinfos,(selectmax(province_id)province_id,max(province_name)province_namefromregion_city_local)p--主要用于取得本省province_idwhereforward_time>=trunc(sysdate)-6--默認(rèn)最近6天ands.sheet_noisnotnullgroupbytrunc(forward_time),vince_id,vince_name核查步驟詳細(xì)的資源統(tǒng)計(jì)核查方法為以下步驟：指標(biāo)的數(shù)據(jù)來自于JAVA服務(wù)的指標(biāo)服務(wù)，在/opt/xdpp/indicator/loader/indicator.loader-1.0.3/conf/DbIndaicator.xml文件中找到指標(biāo)組id260995067。根據(jù)配置文件指標(biāo)組中指標(biāo)id，

<<<IndicatorGroup><IndicatorGroupDefineid="260995067"name="gezhuanyegongdanliang"label="各專業(yè)工單量"><IndicatorDefineid="99506701"name="VIRCOLUMN_01"label="話音網(wǎng)"minvalue=""maxvalue=""gradechange="0"/><IndicatorDefineid="99506702"name="VIRCOLUMN_02"label="數(shù)據(jù)網(wǎng)"minvalue=""maxvalue=""gradechan