actionsreport

SELECT DISTINCT systemaction.mgm_id,

    systemaction.action_id,

    systemaction.earliest_action,

    systemaction.event,

    systemaction.action_name,

    systemaction.scheduler_id,

    systemaction.scheduler_username,

    string_agg((systemaction.hostname)::text, ';'::text) FILTER (WHERE (((systemaction.status)::text = 'Picked Up'::text) OR ((systemaction.status)::text = 'Queued'::text))) OVER (PARTITION BY systemaction.action_id) AS in_progress_systems,

    string_agg((systemaction.hostname)::text, ';'::text) FILTER (WHERE ((systemaction.status)::text = 'Completed'::text)) OVER (PARTITION BY systemaction.action_id) AS completed_systems,

    string_agg((systemaction.hostname)::text, ';'::text) FILTER (WHERE ((systemaction.status)::text = 'Failed'::text)) OVER (PARTITION BY systemaction.action_id) AS failed_systems,

    systemaction.archived,

    systemaction.synced_date

   FROM systemaction

  ORDER BY systemaction.mgm_id, systemaction.action_id;