Hi!
I need to create reports for all the alerts sent from Icinga (mainly to count them) and I can’t seem to understand how to do it. Would be great if the reports can be sent to an email address.
Welcome Oleksandra,
All the Notifications are under History → Notifications.
Did you notice, that in a lot of places in icingaweb2 one can choose the format and it gets added to the URL like so &format=sql
?
Sadly the format SQL option isn’t in the menu.
- https://icinga/icingaweb2/monitoring/list/notifications?notification_timestamp>=-7%20days&format=sql
This gives you the starting point to generate your reports directly from the database.
Another option is to create a autologon to get the CSV and send a mail in a little script triggered by scheduled task or cronjob.
1 Like