systemhistorypackagesreport

SELECT systemaction.mgm_id,

    systemaction.system_id,

    systemaction.action_id,

    systemaction.earliest_action,

    systemaction.pickup_time,

    systemaction.completion_time,

    systemaction.status,

    systemaction.event,

    systemaction.event_data,

    systemaction.synced_date

   FROM systemaction

  WHERE ((systemaction.event)::text = ANY ((ARRAY['Package Upgrade'::character varying, 'Package Removal'::character varying])::text[]))

  ORDER BY systemaction.mgm_id, systemaction.system_id, systemaction.action_id;