Page tree
Skip to end of metadata
Go to start of metadata

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.

The Query

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

What It Does

This queries against a table of all subscribed and unsubscribed events. 

Sample Output

Screen Shot 2017-11-21 at 2.36.20 PM.png


  • No labels