CUCM CLI SQL Query for calls history

[denis.morgen]

Hello,

I want to know calls history by a query.

It's possible?

I don't find appropriate tables.

More specifically, I search :
- All calls history
- All calls history of one number (if I know the previous query, it's not a problem...)
- All cals history of one number with statistic : how many time this number is called, on what periods (day, month, year), how many times he pick up the call ...

I have the database schema (https://developer.cisco.com/media/UCM10.5DataDictionary/UCM10.5DataDictionary.htm) but I don't find...

[Manish Gogna]

Hi Denis,

Have you checked the CDR Analysis and Reporting tool on CUCM which can provide this and lot of other reports as well.

Manish

[denis.morgen]

Hi Manish,

Yes, I checked. But I must use SQL Query, because I want make statistic with other tool by using AXL SOAP Toolkil (or other) for retrieve data.

[denis.morgen]

I found this table : tbl_billing_data

It's not referenced in the database schema... Why? => EDIT : ok... CAR database and CUCM database...

I have a first query but the history is not long :

run sql car SELECT callingpartynumber, originalcalledpartynumber, finalcalledpartynumber, lastredirectdn, user_id, datetimestamporigination, datetimestampconnect, datetimestampdisconnect, origmobiledevicename, destmobiledevicename FROM tbl_billing_data where originalcalledpartynumber='xxxxx'