Steffen.Baier Wed, 03/28/2007 - 04:52
User Badges:

You can use sql query analyzer for this and query the CDR records in there.


You can write a command to query for one certain number only


select * from CallDetailRecord where callingPartyNumber like 'include your number'


% can be used as a wildcard


select * from CallDetailRecord where callingPartyNumber like '91212%'


would look for numbers with a new york area code


_ can be used as a place holder


select * from CallDetailRecord where callingPartyNumber like '91212123456_8' would look for numbers with this pattern and _ can be anything from 0 to 9


Best Regards


Steffen

jalston45 Wed, 03/28/2007 - 06:45
User Badges:

Chris you can also go into CDR Analysis and Reporting. From there CDR>>Search>>By User/Extension that's assuming that you have a specific IP Phone's number that you want to search for this outside number on.

Actions

This Discussion