Re: CUCM 11.5 "run sql" CLI command results in "No suitable driver found"
You might need to use run sql car select + column + from car:tbl_billing_data where + column + (like,in,between,etc).
run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from car:tbl_billing_data where callingpartynumber in ("7140","5750")
This will provide the calls where the calling party number was 7140 and 5750 for example.
call_type callingpartynumber originalcalledpartynumber datetimestamporigination ========= ================== ========================= ======================== S 5750 1208743XXXX 2018-02-05 15:23:10 S 5750 1209401XXXX 2018-02-05 11:47:56
You can also use a Date Range by adding the "and" and "Between" statement as the example below:
run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from car:tbl_billing_data where callingpartynumber in ("7140","5750") and datetimestamporiginationbetween "2018-03-01 00:00:00" and "2018-03-29 23:00:00"
AI is going to change many tasks and, as a result, many jobs.
In this podcast on artificialintelligence in the workplace, we explore how jobs may change--and what companies can do to keep workers ahead of the shift:
Check out the podcast:...
Join this featured IT Admin Control Hub session where you’ll hear about the improved Meeting diagnostics capability in Control Hub which provides IT Admins richer insights about their meetings, the participants and the quality of service. See metrics to h...
This document explains how to register a Cisco TelePresence or WebEx device to Cisco WebEx Cloud Service Using API or Local Web Interface use. This procedure is applicable for Collaboration Endpoint Software 9.8 and later. In previous versi...