Das Datenmodell des Logbuchs hat sich in der letzten Version geändert, darin sind einige Tabellen gelöscht worden. Zur kommenden Version wird der Logbuch Report entsprechend verbessert. Bis dahin haben wir erstmal ein funktionierndes SQL-Query zur aktualisierung des Reports (Ist ebenfalls über den Report-Browser verfügbar):
SELECT
isys_logbook__id as __id__,
isys_logbook__user_name_static as User,
isys_logbook__event_static as Event,
isys_logbook__obj_name_static as Object,
isys_logbook__category_static as Category,
isys_logbook__title AS `Title (old-format)`,
isys_logbook__date AS Date,
isys_logbook_level__title AS Alarmlevel,
(CASE isys_logbook_level__const
WHEN 'C__LOGBOOK__ALERT_LEVEL__0' THEN 'color: #777;'
WHEN 'C__LOGBOOK__ALERT_LEVEL__1' THEN 'color: #880; background: #ffb; border-color: #eea;'
WHEN 'C__LOGBOOK__ALERT_LEVEL__2' THEN 'color: #099; background: #e7ffff; border-color: #cee;'
WHEN 'C__LOGBOOK__ALERT_LEVEL__3' THEN 'color: #a22; background: #fdc; border-color: #e88;' END) AS __style__
FROM isys_logbook
INNER JOIN isys_logbook_level ON isys_logbook__isys_logbook_level__id = isys_logbook_level__id
LEFT OUTER JOIN isys_catg_logb_list ON isys_catg_logb_list__isys_logbook__id = isys_logbook__id
ORDER BY isys_logbook__date DESC;
