Pandora FMS Community

Agent alert "hanging" in Tactical View

Patrick8516 · 18 feb 2022, 9:09 · 2 mensajes · 72 visitas

AlertTactical
  1. Inicio del debate

    An agent fired a critical alert. Before the alert was resolved, we deleted the whole agent.

    Even though the agent was deleted, the critical alert is still displayed in the Tactical View. The "agent-name"-column is empty, which makes sense because the agent no longer exists.

    The problem now is, we cannot find a way to delete this alert out of Tactical View.

    Any idea how to solve this issue would be greatly appreciated!

  2. Hi,

    The only option you have to delete the alert is through the database.

    You can delete the alert via the database interface of the console:

    http://X.X.X.X/pandora\_console/index.php?extension\_in\_menu=gextensions&sec=gbman&sec2=extensions/dbmanager

    The table where the configured alerts are stored is as follows:

    talert_template_modules

    You can search which ID is the one that corresponds to the configured alert and delete the corresponding row, here I leave you a SQL query so you can search all the results.

    SELECT  * FROM  talert_template_modules;
    

    Once you have the ID, you must use the following query to delete the fired alert (replace the XX with the alert ID).

    DELETE  FROM  talert_template_modules  WHERE  id=XX;
    

    Best regards,

    Vic.

Entra en tu cuenta para publicar.