CDR

chris.damore · ‎03-27-2007

How can you use CDR's to search to see if an outside number called in to an IP phone. Do you have to search by gateways or what?

Thanks,

Chris

Steffen.Baier · ‎03-28-2007

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 · ‎03-28-2007

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.