cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
813
Views
0
Helpful
4
Replies
Marc Richter
Beginner

CUCM CDR anonymous calls

Hi community,

 

is there a way to search for incoming anonymous calls in CUCM CDR search?

 

I've tryed "null" "anonymous" "unknown" also with different wildcards but I'm just able to find the calls if I search for the destination number. Is there any trick to search just for those kind of calls, or is there no possibility?

 

Thanks!

4 REPLIES 4
Nashaatmusa
Beginner

So you are searching on the CSV (CDR) file exported from CUCM , or you are searching from the Cisco Unified CM CDR Analysis and Reporting GUI ?

I used to file all Calls searching for NULL ... all caps

I'm using the GUI cause its faster for me for Troubleshooting purpose.

 

Its working via the export.

 

By the way, I've found a fast solution by using SQL.

Could you share the way you found it via SQL?


@Marc Richter wrote:

I'm using the GUI cause its faster for me for Troubleshooting purpose.

 

Its working via the export.

 

By the way, I've found a fast solution by using SQL.


 

Hey almost forgot to answer. The SQL Statement would be:

 

run sql car SELECT datetimestamporigination,callingpartynumber,originalcalledpartynumber,destdevicename FROM car:tbl_billing_data WHERE datetimestamporigination BETWEEN '2018-07-11 10:00:00' AND '2018-07-11 23:59:59' AND callingpartynumber like 'anonymous'
Create
Recognize Your Peers
Content for Community-Ad