historyreport

SELECT systemaction.mgm_id,

    systemaction.system_id,

    systemaction.action_id AS event_id,

    systemaction.hostname,

    systemaction.event,

    systemaction.completion_time AS event_time,

    systemaction.status,

    systemaction.event_data,

    systemaction.synced_date

   FROM systemaction

UNION ALL

 SELECT systemhistory.mgm_id,

    systemhistory.system_id,

    systemhistory.history_id AS event_id,

    systemhistory.hostname,

    systemhistory.event,

    systemhistory.event_time,

    'Done'::character varying AS status,

    systemhistory.event_data,

    systemhistory.synced_date

   FROM systemhistory;