01-09-2008 11:08 AM - last edited on 03-25-2019 06:55 PM by ciscomoderator
Hello not sure if I am on the right forum but I need to know where do my Call logs are located on my call manager 4.1. Need to track incoming and outgoing calls.
01-09-2008 12:29 PM
Hi Damon,
The Call Logs or Records are saved and viewed via CDR/CAR. Have a look;
Cisco Unified CallManager Serviceability Administration Guide, Release 4.0(1)
CDR Analysis and Reporting
Hope this helps!
Rob
01-09-2008 12:32 PM
Thanks!
04-23-2008 05:45 PM
Hi Rob,
in relation to the question above, did the CDR have any logs in text file or any format?
Or it's only on the SQL database?
If it has, by default, where is it located?
got CM 4.1 too!
We're trying to import the CDR logs to a freeware VQmanager voip monitoring tool...just testing.
thanks
04-24-2008 04:59 AM
Hi Robert,
Hope all is well! This is an excellent question :) My understanding of the CDR process is that in CCM Versions up to 5.x SQL is the only way to see CDR's with all the requisite details. The calls are collected originally as "flat files" on the Subscribers servers and then moved/merged/compiled in the CDR db.
Cisco CDR Insert reads transferred files, places contents into the call detail record (CDR) database, and removes old files. When you enable CDR collection, Cisco CallManager writes CDRs to flat files on the subscriber hard drive as calls are made. The Cisco CDR Insert service periodically inserts the records from these files into the publisher centralized SQL database. The Cisco CDR Insert service does not insert a record if the CDRFormat enterprise parameter has a value of Flat. For more information on CDRs and related parameters
When CDR collection is enabled through the CDR Enabled Flag Cisco CallManager service parameter, Cisco CallManager writes call detail records (CDRs) to flat files on the subscriber servers as calls are completed. When CDR Diagnostic collection is enabled through the Call Diagnostics Enabled Cisco CallManager service parameter, Cisco CallManager writes call detail diagnostic records to flat files on the subscriber servers as calls are completed. The Cisco Database Layer Monitor service periodically moves the CDR files from the subscriber to the publisher server (or configured server), and the Cisco CDR Insert Service inserts the records into the configured CDR database.
Here are two great descriptions from two of my favourite NetPros;
From Jorge;
From Jaime;
Hope this helps!
Rob
04-24-2008 04:32 PM
Thanks Rob for the great info.
You're the man!
One last question:
How to find out when is that transfering of the CDR from the Subs to (Pubs)SQL DB? Can it(schedule) be change? how?
thanks again
04-24-2008 07:28 PM
not sure if you're asking about when the data from CDR goes to ART or when the data from SUBs go to the PUB
the flat files that are generated in the SUBs once the call finished are immediately sent to the PUB and loaded into the CDR DB. I believe it's every minute the info is sent to the PUB to keep it in real-time
about the CDR to ART load it's set by default between midnight and 5 am, you can change that but since it's a high CPU process we recommend leaving the default time
Configuring the CDR Load Schedule
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/4_1_3/ccmsrva/sacar2.html#wp1093752
HTH
javalenc
if this helps, please rate
04-25-2008 06:08 AM
Hi Robert,
You are most welcome my friend! Thanks so much for the very kind words as well :) As Jaime nicely noted, the movement of the "Flat Files" between the Sub's/Pub is constantly happening.
Take care and thanks again!
Rob
01-18-2018 12:12 AM
Hi,
In our network 3900 series router but i have not getting the more than 50 to 60 Mbps bandwidth.
In our oraganization are total bandwidth 200 Mbps
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide