What line is this number calling in on? Query Analyzer Ques:

[rossporubski]

I'm trying to execute a query on CDR in query analyzer on our ccm server.

The request is to find out if a specific number is calling in to our office and what time/date/number it is calling in on, if in fact it is.

I tried this query, but it retrieves no results.

select *

from calldetailrecord

where (callingPartyNumber = '1111')

[Jaime Valencia]

if you're trying to find i PSTN number i seriously doubt you will receive 1111 as the ANI. use the ANI you want to look in the query

HTH

java

if this helps, please rate

[rossporubski]

1111 would be my example. The DDI [UK telephone number] I would like to query does not need to be shown publicly.

In this case 1111 is equal to xxxx