This query helps find accounts where the signaling doesn't match the account programming. Specifically, where there is 4X2 programming on the account and the account is sending in Contact ID.
-- this query is used to find where the customer programming doesn't match the signaling. use manitou select customer.contid 'Cust ID' ,contact.fullname 'Cust Name' ,clog201408.* from customer join contact on customer.serialno = contact.serialno and contact.conttype = 1 join CLOG201408 on customer.serialno = CLOG201408.serialno and CLOG201408.keyalm like '[e,r][0-9][0-9][0-9]' where customer.serialno in (select serialno from stxprg where stxprg.des = '*A')
