Extracting the Alerts acknowledged data

[aditya.c.anand]

Hello Team,

Can we extract the number of alerts acknowledged(with alert details) by the engineers on our NagiosXI tool for past an year.
If there is any way to get this data from the logs then please suggest for the same.

Regards,
Aditya Anand

[benjaminsmith]

Hello @aditya.c.anand,

Acknowledgements are stored in the nagios database in the nagios_acknowledgements table. So for example, you can run the following command to see the acknowledgement history:

Code: Select all

echo "SELECT * FROM nagios_acknowledgements" | mysql -uroot -pnagiosxi nagios

You can also generate a report of Acknowledgements and Comments by going to Home > Incident Management > Acknowledgements.