I'm trying to write a SQL query in order to find out how often a translation pattern is being hit.
I'm using a query similar to this select * from CallDetailRecord where finalcalledpartynumber='4xxxx'and having it search through the CDR database. Of course the translation pattern is not the finalcalledpartynumber so I do not get any results. Any help is appreciated. Thanks
when you check difference between original and final called number you'll see how often TP adds numbers. Any other call to PSTN has original and final called number the same.
select * from calldetailrecord where originalcalledpartynumber like '4[0-9][0-9][0-9][0-9]' AND finalcalledpartynumber like '83263[0-9][0-9][0-9][0-9][0-9]'