In response to customer interest in knowing what changes users have made to collectors, we are providing a new advanced query, which itemizes those changes.
select ena.id as "Id", ena.type as "Notification Type", ena.message as "Message", ena.details as "Details", zz.name as "Zone Name" from events as ena join zone as zz on zz.id=ena.zone_id where type like '%COLLECTOR%'::STRING and time < current_timestamp order by time desc
This queries against a table of all subscribed and unsubscribed events.