Pandora FMS Community

Outage Report

crazytaxi · 2 oct 2012, 9:07 · 2 mensajes · 63 visitas

  1. Inicio del debate

    How do I create a monthly report of outage equipment? For example. Equipment name | IP      | Status | Duration  | Date      | Router A            x.x.x.x    UP        1:23:00  x-xx-xxxx I can see the outage report from raw data. How do I put that raw data using pandora FMS report?

  2. Hello crazytaxi, Test with this sql query:

    select t1.nombre, t2.datos, t2.utimestamp from tagente_modulo as t1, tagente_datos as t2 where t2.id_agente_modulo=2011 and t1.id_agente_modulo=t2.id_agente_modulo;
    

    You only have to change 2011 for the id of the module you want to report. You can obtain it from the url, in the module edition page. Regards.

Entra en tu cuenta para publicar.