cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
530
Views
0
Helpful
4
Replies
Highlighted
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!

Everyone's tags (3)
4 REPLIES 4
Highlighted
Beginner

Re: CUCM CDR anonymous calls

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
Highlighted
Beginner

Re: CUCM CDR anonymous calls

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.

Highlighted
Beginner

Re: CUCM CDR anonymous calls

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.


 

Highlighted
Beginner

Re: CUCM CDR anonymous calls

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'
CreatePlease to create content
Content for Community-Ad
Future of Work Virtual Summit Day 5

Cisco COVID-19 Survey