IcingaDBWeb additional colums for "Notifications"

Icinga DB
,
1

The “Notification”-history in icingaweb2/monitoring/list/notification has a “Sent to”-column where you can see the receivers of notifications. This column is missing in /icingaweb2/icingadb/notifications.

I didn’t manage to add columns with “&columns=” in the URL, e.g. “&columns=user.name_ci”.
The resulting php-error-message is: “Can’t require column ‘columns’ in model ‘Icinga\Module\Icingadb\Model\NotificationHistory’. Column not found.”

“user.name_ci” can be used to query the notifications so I assumed this column can be added to the output.
Any hints how to achieve this?

  • Icinga DB Web version (System - About): 1.0.2
  • Icinga Web 2 version (System - About): 2.11.4
  • Web browser: Firefox / Edge
  • Icinga 2 version (icinga2 --version): 2.14.0
  • Icinga DB version (icingadb --version): 1.1.1
  • PHP version used (php --version): 8.0.29
  • Server operating system and version: SLES 15 SP4
2

the columns query doesnt work, it makes icinga look for a column named “columns” which obviously doesnt exist. The way I see it you cannot add information to the output using url params.

I think to achieve this this file has to be patched:

BaseNotificationListItem.php
https://github.com/Icinga/icingadb-web/blob/master/library/Icingadb/Widget/ItemList/BaseNotificationListItem.php

actually that looks not too bad

Screenshot 2023-09-14 091024
Screenshot 2023-09-14 0910241214×240 23.4 KB

you can create a feature request on github

3

Thanks for your efforts. IMHO this additional column is helpful (as it was in “good old monitoring-module-times” too). We use it, amongst other things, in a daily meeting as a checklist for discussions about all alarms sent to our oncall-duty-team.