Page History

...

The following query will obtain the Planned Maintenance from the otrs database on test-msr.geant.net:

SELECT a.id,a.tn,a.title,a.create_time,a.change_time,b.name,c.field_id,c.value_date,UNIX_TIMESTAMP(c.value_date) as 'Time As Epoch',c.value_text
FROM otrs.ticket a
LEFT JOIN otrs.ticket_type b ON (b.id = a.type_id)
LEFT JOIN otrs.dynamic_field_value c ON (c.object_id = a.id)
WHERE a.queue_id IN (4,5,6,10,15,19,20,22,24,40,45,46,62,63,64)
AND a.type_id = 6
AND c.field_id in (6,7,22)
AND YEAR(a.change_time) = 2017
AND MONTH(a.change_time) = 7
ORDER BY a.id, field_id ASC;

...