07-12-2018 01:10 AM - edited 03-19-2019 01:28 PM
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!
07-12-2018 01:24 AM
07-15-2018 11:29 PM
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.
07-18-2018 12:15 PM
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.
11-19-2018 10:56 PM
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'
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide