cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays

CUCM Informix 12.5 (CDR information via informix @ command line level)

492
Views
0
Helpful
2
Comments
Beginner

Hello everyone!

Long ago, because CDR search is awful, I used to use run sql select at the CLI level on CUCM.  Seems the tbl_billing_data is no longer a thing?  I'm having a heck of a time finding any documentation on what to query off of for CDR lookups.  Anything I find is all the old stuff I already know that doesn't work anymore :(

 

I pulled all the tables out and I don't even see any that I recognize as a CDR table either. 

 

Any suggestions or links to read stuff is appreciated!

 

What i'm trying to do:
run sql select callingPartyNumber, finalCalledPartyNumber, duration from tbl_billing_data where callingpartynumber = '<number here>' order by datetimeOrigination

2 Comments
Beginner

I found my error :(  run sql car select

Beginner

Another option would be to run a free CDR tool.  Check out either the SolarWinds free CDR tool, or VoIP Detective.  Both should help you analyze CDRs.

 

Many people would prefer to use CAR to either do the search you're looking for, or to export data into excel, then search from that.

Content for Community-Ad