Use this query to find Customers that have a specific event code in their customer Transmitter programming translations.
-- Use this query to find customers with a specific event code in their programming. USE MANITOU select c.CONTID , co.FULLNAME , p.DES , p.ZONE , p.STCODE , p.OZONE from CUSTOMER c join CONTACT co on co.SERIALNO=c.SERIALNO and co.CONTTYPE=1 join STXPRG p on p.SERIALNO=c.SERIALNO where p. STCODE = 'UT' --Change the code between the single quotes to the event code you seek
