Á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',

...