07-29-2008 07:25 AM - edited 03-13-2019 05:31 PM
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')
07-29-2008 08:43 AM
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
07-29-2008 08:48 AM
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
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: