IcingaDB data is not up to date with the data displayed in Icingaweb

moreamazingnick · July 25, 2024, 8:56am

the reason for this is, that the most recent non hard state change information is stored in the redis server only.

The sql database hold the hard state relevant for “reboot consistant” sla calculation.

It is quite easy to implement something like this query in php as an icingaweb2 module.
Inside icingeweb2 you can easyily combine the redis data with the sql data.

github.com

RISE-GmbH/icingaweb2-module-checkreports/blob/d1a1ff68dbe3d69aa8cb73a43f85afbe316c2cf7/library/Checkreports/ProvidedHook/Reporting/Icingadb/ServiceCheckReport.php#L62


      
          protected function fetchChecks($config, $filter = null)
          {
          
              $query = Service::on($this->getDb())->with([
                  'state',
                  'icon_image',
                  'host',
                  'host.state'
              ]);
          
              $query
                  ->setResultSetClass(VolatileStateResults::class); #to get redis data
              if ($filter !== null) {
                  $query->filter(Filter::all(
                      Filter::any($filter)
                  ));
              }
          
              $query->resetOrderBy()->orderBy('host.display_name')->orderBy('display_name');
          
              $this->applyRestrictions($query);