This query is used to find customers with specific Event Actions Programming on their customer record. Please Note, they may request this information be updated or deleted after this information is located. This query only finds the information.
USE Manitou
select distinct
c.CONTID
, co.FULLNAME
--, p.STCODE
--, p.ACTIONS
from CUSTOMER c
join CONTACT co on c.SERIALNO=co.SERIALNO and co.CONTTYPE=1
join MONITORING m on m.SERIALNO=c.SERIALNO and m.COMMSTATE=1
join EVENTPRG p on p.SERIALNO=c.SERIALNO
where
p.ACTIONS like '%notify%'and p.STCODE like '*H%' or p.STCODE like 'HA%'
