mirror of
https://github.com/Icinga/icingadb.git
synced 2026-02-03 20:40:34 -05:00
9 lines
579 B
SQL
9 lines
579 B
SQL
SELECT fh.flappinghistory_id, UNIX_TIMESTAMP(fh.event_time) event_time,
|
|
fh.event_time_usec, fh.event_type, fh.percent_state_change, fh.low_threshold,
|
|
fh.high_threshold, o.objecttype_id, o.name1, COALESCE(o.name2, '') name2
|
|
FROM icinga_flappinghistory fh USE INDEX (PRIMARY)
|
|
INNER JOIN icinga_objects o ON o.object_id=fh.object_id
|
|
WHERE fh.flappinghistory_id BETWEEN :fromid AND :toid
|
|
AND fh.flappinghistory_id > :checkpoint -- where we were interrupted
|
|
ORDER BY fh.flappinghistory_id -- this way we know what has already been migrated from just the last row's ID
|
|
LIMIT :bulk
|