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

Unanswered Question
Jul 29th, 2008
User Badges:

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Jaime Valencia Tue, 07/29/2008 - 08:43
User Badges:
  • Cisco Employee,
  • Hall of Fame,


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



if this helps, please rate

rossporubski Tue, 07/29/2008 - 08:48
User Badges:

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


This Discussion