CUCM CDR anonymous calls

[Marc Richter]

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!

[Nashaatmusa]

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

[Marc Richter]

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.

[wpate]

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.

---

[Marc Richter]

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'