systemhistoryconfigurationreport

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['Upload config file data to server'::character varying, 'Verify deployed config files'::character varying, 'Show differences between profiled config files and deployed config files'::character varying, 'Upload config file data based upon mtime to server'::character varying, 'Deploy config files to system'::character varying])::text[]))

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