Pandora FMS Community

DB interface (SQL)

thusitha · 15 ene 2013, 15:55 · 3 mensajes · 90 visitas

  1. Inicio del debate

    hi, i have a situation.I need to get a SQL query to get some informations to use in DB interface page. I work on that. But the thing is (Link not available anymore) is not eassy to read .Because it is in Spanish.(!$#$%%^#). So give me some help. Here's my situation, When a alert fired, i have to get some informations such as , - module name(that alert fired) - agent name(that module belongs to) - user details (user means who involved/assigned to  that agent group to check)(such as email/tp)     *In my agents pool ,I have made agent groups -customer details(who owns that agent)(such as email/tp) please help me. thank you.

  2. Hello You can see alerts fired in "select * from talert_template_modules where last_fired=1". This query show id_agente_modulo and you can find the module information with this other query select * from tagente_modulo when id_agente_modulo=X.  You can find agent name  and id_grupo (is the group id) in "tagente" table  to find in "tusario" table the user name. Regards

  3. hello, thank you very much for your help.actually i want is, get above mentioned situations as a one table.but any way thanks for the help. i can fix that now. thanks.

Entra en tu cuenta para publicar.