Page 1 of 1

Extracting the Alerts acknowledged data

Posted: Wed Jan 23, 2019 3:30 am
by 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

Re: Extracting the Alerts acknowledged data

Posted: Wed Jan 23, 2019 12:28 pm
by 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.