CUCM 11.5 "run sql" CLI command results in "No suitable driver found"

[d.haeni]

I am a big fan of troubleshooting calls using the CDR database, such as:

run sql car select callingpartynumber Calling, originalCalledPartyNumber origCalled, finalcalledpartynumber finalCalled, datetimestamporigination origination, datetimestampconnect connect, dateTimestampDisconnect disconnect, duration, origCause_value origCause, destCause_value destCause from tbl_billing_data

This works on a CUCM 11.5.1.12900-21 , but two systems running later code (11.5.1.13902-2, 11.5.1.14900-11)  just pop an error:

No suitable driver found for NO_JDBCURL_PROVIDEDuser=[..]

Is anyone else seeing this?

Thanks

/David

[gersomor1]

Hello d.haeni,

You might need to use run sql car select + column + from car:tbl_billing_data where + column + (like,in,between,etc).

Example:

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.

Result:

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  datetimestamporigination between "2018-03-01 00:00:00" and "2018-03-29 23:00:00"

I hope this helps!!

Thanks,

Gerson Fabian Morales Marin