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

Unanswered Question
Jul 29th, 2008

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')

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Jaime Valencia Tue, 07/29/2008 - 08:43

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 Tue, 07/29/2008 - 08:48

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

Actions

This Discussion