1
SELECT systemaction.mgm_id,
2
systemaction.system_id,
3
systemaction.action_id AS event_id,
4
systemaction.hostname,
5
systemaction.event,
6
systemaction.completion_time AS event_time,
7
systemaction.status,
8
systemaction.event_data,
9
systemaction.synced_date
10
FROM systemaction
11
UNION ALL
12
SELECT systemhistory.mgm_id,
13
systemhistory.system_id,
14
systemhistory.history_id AS event_id,
15
systemhistory.hostname,
16
systemhistory.event,
17
systemhistory.event_time,
18
'Done'::character varying AS status,
19
systemhistory.event_data,
20
systemhistory.synced_date
21
FROM systemhistory;