Hi, > On 02 May 2016, at 22:01, Hasan Akgöz <[email protected]> wrote: > > Hi guys; > > I saw the records of the old host of looking at the MySQL database. when we > delete a host? It does not delete all records ?
Deleted objects are marked is_active=0 inside the icinga_objects table. That way historical tables preserve old data for sla reports etc. More information on the database schema can be found here: http://docs.icinga.org/latest/en/db_model.html Your queries should take that into account, similar to what Icinga Web 2 does. You can extract the current view’s query like so for example: http://localhost/icingaweb2/monitoring/list/services?service_problem=1&sort=service_severity&dir=desc&format=sql Kind regards, Michael -- Michael Friedrich, DI (FH) Senior Developer NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg Tel: +49 911 92885-0 | Fax: +49 911 92885-77 CEO: Julian Hein, Bernd Erk | AG Nuernberg HRB18461 http://www.netways.de | [email protected] ** OSBConf 2016 - September - osbconf.org ** **OSMC 2016 - November - netways.de/osmc** _______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users
