systemhistorychannelsreport

SELECT systemhistory.mgm_id,

    systemhistory.system_id,

    systemhistory.history_id,

    systemhistory.event_time,

    'Done'::text AS status,

    systemhistory.event,

    systemhistory.event_data,

    systemhistory.synced_date

   FROM systemhistory

  WHERE ((systemhistory.event)::text = ANY ((ARRAY['Subscribed to channel'::character varying, 'Unsubscribed from channel'::character varying])::text[]))

  ORDER BY systemhistory.mgm_id, systemhistory.system_id, systemhistory.history_id;