@stefanp74
also es gibt keine direkte Ansicht aber es lassen sich einfach SQL Queries für den Report Manager nutzen.
Da muss dann jedes mal die ID geändert werden, hier 2 Beispiele:
Beispiel 1:
SELECT
DATE(c.isys_cmdb_status_changes__timestamp) AS change_date,
CASE s.isys_cmdb_status__const
WHEN 'C__CMDB_STATUS__PLANNED' THEN 'Geplant'
WHEN 'C__CMDB_STATUS__ORDERED' THEN 'Bestellt'
WHEN 'C__CMDB_STATUS__DELIVERED' THEN 'Geliefert'
WHEN 'C__CMDB_STATUS__ASSEMBLED' THEN 'In Arbeit'
WHEN 'C__CMDB_STATUS__TESTED' THEN 'Getestet'
WHEN 'C__CMDB_STATUS__IN_OPERATION' THEN 'In Betrieb'
WHEN 'C__CMDB_STATUS__DEFECT' THEN 'Defekt'
WHEN 'C__CMDB_STATUS__UNDER_REPAIR' THEN 'In Reparatur'
WHEN 'C__CMDB_STATUS__DELIVERED_FROM_REPAIR' THEN 'Aus Reparatur zurück'
WHEN 'C__CMDB_STATUS__INOPERATIVE' THEN 'Außer Betrieb'
WHEN 'C__CMDB_STATUS__STORED' THEN 'Gelagert'
WHEN 'C__CMDB_STATUS__SCRAPPED' THEN 'Verschrottet'
WHEN 'C__CMDB_STATUS__SWAPPED' THEN 'Getauscht'
ELSE s.isys_cmdb_status__title
END AS status
FROM isys_cmdb_status_changes c
JOIN isys_cmdb_status s ON s.isys_cmdb_status__id = c.isys_cmdb_status_changes__isys_cmdb_status__id
WHERE c.isys_cmdb_status_changes__isys_obj__id = 275
ORDER BY c.isys_cmdb_status_changes__timestamp ASC;
[image: 2baadea2-48d2-4a6d-8f26-ebb94d040872-image.jpeg]
Beispiel2:
SELECT
o.isys_obj__id AS object_id,
o.isys_obj__title AS object_title,
DATE(c.isys_cmdb_status_changes__timestamp) AS change_date,
c.isys_cmdb_status_changes__timestamp AS change_time,
s.isys_cmdb_status__title AS status_constant,
CASE s.isys_cmdb_status__const
WHEN 'C__CMDB_STATUS__PLANNED' THEN 'Geplant'
WHEN 'C__CMDB_STATUS__ORDERED' THEN 'Bestellt'
WHEN 'C__CMDB_STATUS__DELIVERED' THEN 'Geliefert'
WHEN 'C__CMDB_STATUS__ASSEMBLED' THEN 'In Arbeit'
WHEN 'C__CMDB_STATUS__TESTED' THEN 'Getestet'
WHEN 'C__CMDB_STATUS__IN_OPERATION' THEN 'In Betrieb'
WHEN 'C__CMDB_STATUS__DEFECT' THEN 'Defekt'
WHEN 'C__CMDB_STATUS__UNDER_REPAIR' THEN 'In Reparatur'
WHEN 'C__CMDB_STATUS__DELIVERED_FROM_REPAIR' THEN 'Aus Reparatur zurück'
WHEN 'C__CMDB_STATUS__INOPERATIVE' THEN 'Außer Betrieb'
WHEN 'C__CMDB_STATUS__STORED' THEN 'Gelagert'
WHEN 'C__CMDB_STATUS__SCRAPPED' THEN 'Verschrottet'
WHEN 'C__CMDB_STATUS__SWAPPED' THEN 'Getauscht'
ELSE s.isys_cmdb_status__title
END AS status_label
FROM isys_cmdb_status_changes c
JOIN isys_obj o ON o.isys_obj__id = c.isys_cmdb_status_changes__isys_obj__id
JOIN isys_cmdb_status s ON s.isys_cmdb_status__id = c.isys_cmdb_status_changes__isys_cmdb_status__id
WHERE o.isys_obj__id = 12345
ORDER BY c.isys_cmdb_status_changes__timestamp ASC;
Hier noch die Vorschau:
[image: e3ab569b-0d7b-45f0-8ecf-e7e2118d977a-image.jpeg]
