cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
415
Views
0
Helpful
3
Replies
Highlighted
Beginner

How to remote query the CAR database for Call History Detail

I would like a run some custom reports programmatically via remote sql queries if possible. I cannot find any documentation on this.  The AXL doc is great and is working well for us but I beleive AXL is for configuration only, correct?  How can I remotely connect to the CUCM call logs database to access call record details? What sort of sql database is it, eg mysql postgres etc? Is there schema documentation anywhere for this database? Also, when running sql on the CUCM it appears to only show a small subset of records, does that sound right?

Everyone's tags (7)
3 REPLIES 3
Cisco Employee

Re: How to remote query the CAR database for Call History Detail

Hi Matt,

Apologies for delay in responding to you. Moving your question under AXL community for more visibility of support engineers.

Thanks and Regards,

Geevarghese

Beginner

Re: How to remote query the CAR database for Call History Detail

I'm also looking for the call history per user and their personal contacts. I've queried a lot of tables in the CUCM database but none of them contained what I was looking for.

Cisco Employee

Re: How to remote query the CAR database for Call History Detail

The CAR database is not accessible for external access.

The general mechanism for creating custom 3rd party CUCM CDR reports is to configure the CDR Repository Manager to periodically deliver the CDR records to a designated 3rd party SFTP server (up to 3), where a custom app could process them - i.e. import into a database, and combine with data from AXL to produce detailed reports.

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards
This widget could not be displayed.