Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

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

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

2 REPLIES
Cisco Employee

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

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

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

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

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

114
Views
0
Helpful
2
Replies