ÁRBOL DE ALARMAS

Contenido

ÁRBOL DE ALARMAS.        2

1.        Alarmas brutas y alarmas deduplicadas        2

1.1 Nokia        2

1.2 Otros vendors        2

2.        Alarmas visualizadas por el Front Office        3

2.1 NSN        3

2.2 TX        5

2.3 PCRF        17

2.4 STP        18

2.5 NAP        19

2.6 Alcatel WNMS (Femtoceldas)        19

3.        Para alarmas clareadas antes de 5 minutos antes del group Agent añadir las siguientes condiciones        19

4.        Para alarmas clareadas antes de 20 minutos y después de 5 minutos añadir las siguientes condiciones        19

5.        Alarmas relacionadas a Remedy        20

6.        Conteo de alarmas relacionadas a manualmente a Maximo        20

7.        Enviadas a TEMIP        20

8.        Atendidas automatismo        20

9.        Consulta equipos descubiertos:        21

10.        Consulta incidentes enviados a remedy desde MAXIMO:        21

11.        Detalle ALARMAS RESTANTES        22

a.        Nokia        22

b.        TX        26

ÁRBOL DE ALARMAS.

1. Alarmas brutas y alarmas deduplicadas

Para la generación del reporte, es importante tener en cuenta la siguiente tabla de equivalencias entre Agente y los nombres reportados:

Servidor: GSR_CMDB_TRI02

RUTA Archivos CSV: D:\FTP-GESTOR\REPORTS\

1. Nokia (brutas_duplicadas_nokia.csv)

select  Agent, sum(tally+1), count(*)

from reporter2.reporter_status

where FirstOccurrence between to_date('06//2017 00:00:00','MM/DD/YYYY HH24:MI:SS') and to_date('05/21/2017 23:59:59','MM/DD/YYYY HH24:MI:SS')

and Agent like 'Nokia%'

and Type=1

and CODALARM is not null

group by Agent

1.2 Otros vendors (brutas_duplicadas_otrosvendor.csv)

select  Agent, sum(tally+1), count(*)

from reporter2.reporter_status

where FirstOccurrence between to_date('03/27/2017 00:00:00','MM/DD/YYYY HH24:MI:SS') and to_date('04/02/2017 23:59:59','MM/DD/YYYY HH24:MI:SS')

--and CollectionFirst between to_date('03/27/2017 00:00:00','MM/DD/YYYY HH24:MI:SS') and to_date('04/02/2017 23:59:59','MM/DD/YYYY HH24:MI:SS')

and Type=1

group by Agent

1. Alarmas visualizadas por el Front Office

2.1 NSN (visualizadas_fo_nokia.csv)

select  Agent,  count(*)

from reporter.reporter_status

where FirstOccurrence between to_date('05/15/2017 00:00:00','MM/DD/YYYY HH24:MI:SS') and to_date('05/21/2017 23:59:59','MM/DD/YYYY HH24:MI:SS')

 and Agent like 'Nokia%'

and Type=1

and CODALARM in  ('89','111','175','1016','1024','1071','1078','1309','1597','1661','1662','1803','1860','2002','2004','2006','2007','2008','2009','2010','2012','2015','2017','2018','2022','2023','2024',

'2025','2026','2027','2028','2029','2054','2060','2061','2064','2065','2066','2068','2070','2072','2077','2099','2129','2137','2138','2139','2141','2142','2143','2160','2202','2227','2241','2249','2259',

'2262','2267','2268','2269','2271','2272','2274','2275','2282','2284','2294','2295','2311','2336','2347','2374','2375','2376','2379','2380','2381','2384','2385','2386','2388','2389','2390','2391','2393',

'2394','2397','2399','2403','2420','2424','2425','2426','2427','2430','2435','2437','2438','2439','2440','2441','2445','2447','2454','2479','2503','2518','2525','2530','2532','2536','2549','2550','2551',

'2562','2590','2614','2615','2616','2620','2632','2633','2634','2635','2636','2637','2638','2639','2640','2641','2642','2645','2650','2651','2652','2653','2660','2661','2662','2663','2664','2665','2666',

'2668','2670','2675','2679','2680','2683','2684','2690','2691','2692','2693','2696','2697','2698','2699','2703','2711','2731','2733','2735','2741','2742','2744','2745','2750','2751','2752','2754','2755',

'2756','2757','2758','2759','2760','2761','2762','2763','2764','2772','2786','2794','2798','2800','2801','2804','2806','2808','2809','2812','2813','2814','2816','2819','2823','2827','2828','2836','2844',

'2845','2860','2861','2862','2870','2871','2879','2891','2892','2896','2898','2899','2900','2915','3003','3010','3013','3015','3019','3025','3030','3031','3032','3035','3053','3056','3069','3070','3081',

'3089','3097','3114','3117','3122','3124','3125','3129','3140','3141','3142','3144','3146','3149','3157','3159','3162','3174','3177','3180','3184','3186','3188','3191','3197','3198','3199','3216','3225',

'3252','3253','3258','3266','3267','3289','3292','3293','3296','3306','3308','3314','3320','3334','3364','3365','3374','3388','3389','3406','3417','3422','3425','3427','3430','3432','3433','3434','3435',

'3438','3439','3440','3441','3446','3447','3448','3457','3473','3474','3478','3481','3487','3490','3503','3515','3533','3534','3535','3550','3562','3569','3575','3578','3579','3596','3604','3606','3644',

'3689','3691','3695','3746','3757','3778','3786','3794','3795','3797','3798','3900','3937','3947','4000','4001','4002','4003','4004','4005','4006','4007','4008','4009','4010','4011','4012','4013','4014',

'4015','4016','4017','4018','4019','4020','4021','4022','4023','4024','4025','4026','4027','4028','4029','4030','7401','7404','7408','7409','7410','7413','7414','7420','7422','7423','7600','7603','7650',

'7653','7656','7657','7701','7704','7706','7738','7750','7767','7771','7772','7776','7786','9047','9251','19001','19003','19008','19009','19010','19011','19012','19013','19014','19015','19016','19017',

'19018','19019','19020','19021','19039','19040','19054','19060','19800','32327','32337','32339','34009','34010','34011','34015','34016','34017','34018','34019','34020','34021','34022','34023','34025',

'34026','34027','34028','34029','34030','34031','34060','37407','37423','37429','37434','37437','37443','37444','37446','37447','37451','37456','40121','40122','40123','40124','40125','40127','40128',

'40130','40134','40135','40136','40137','40138','40139','40186','40338','42080','42081','42082','42083','42084','42085','42086','42087','42088','42101','42102','42103','42104','42105','42106','42107',

'42108','42109','42110','42111','42112','42113','42114','42115','42116','42117','42118','42119','42120','42121','42122','42123','42124','42125','42126','42127','42128','42129','42130','42131','42132',

'42133','42134','42135','42136','42137','42138','42139','42140','42141','42142','42143','42144','42145','42146','42147','42148','42149','42150','42151','42152','42153','42154','42155','42156','42157',

'42158','42159','42160','42161','42162','42163','42164','42165','42166','42167','42168','42169','42170','42171','42172','42173','42174','42175','42176','42177','42178','42179','42180','42181','42182',

'42183','42184','42185','42186','42187','42188','42189','42190','42191','42192','42193','42194','42195','42196','42197','42198','42199','42200','42262','42264','42265','42266','42267','42273','42274',

'42275','42276','42277','42278','42279','42280','42283','42285','42290','42291','42292','42293','42294','42296','42302','42303','42313','42314','42341','42342','42343','42344','42345','42346','42347',

'42348','42349','42350','42351','42352','42353','42354','42355','42356','42357','42358','42359','42360','42366','42367','42368','42369','42370','42371','42372','42373','42374','42381','42382','42383',

...