Need to find out how oftern a translation pattern is getting hit
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
Re: Need to find out how oftern a translation pattern is getting
I follow your logic but with my situation I don't think it is going to work. The numbers we add with the translation would match any PSTN call. The scenerio is that we have phones that are not on the callmanager yet and need to route to the PSTN but we make it appear seemless. So the route patter adds 83263XXXXX but this also matches any call to the PSTN.
I'm trying to find a way to find out how many people are hitting that translation pattern to find out if I can get rid of that translation patter.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...