How can I find if this number is calling 'In' to our business?

[cdiross]

I know very little about sql query. We've been asked by management to find out if this number xxxx xxxx is calling in to our business. If it is, when.

I opened query analyzer and ran this query against the cdr database:

select *
from calldetailrecord
where (callingPartyNumber = 'xxxx xxxx')

I don't think this is right though. It produces nothing based on the actual number I'm requesting.

Can anybody help? Thank you in advance.

 

[pndscm]

Do you have CAR installed and running on your CallManager? If so, run a CDR Search by Extension and put the calling number in where it asks for the extension number. It will find when and how many times the number called into the system.

 

[cdiross]

This is actually an outside number. They're asking for any time is called in to any available DDI.....It's in the UK.

 

[pndscm]

Doesn't matter if it's an outside number or not. CAR will find it as long as the Calling number is delivered. If it's in the CDR database CAR should find it.
If I were looking for when an outside call from 414-555-1212 was placed to any of my internal numbers, I'd open CAR and put in 4145551212 in the Extension Number field and CAR will find the call.

 

[Riktov]

pndscm is right, with CAR you can search for the original calling number.

Caos is the natural order of things...