I found a good doc on searching CDR using SQL Query Analyzer. Is there any thing similar for searching CMR? What I would like to do is search for CMR records eiher from a particular number or search for records from a time frame.
Just check out the Call Detail Record Definition document for the particular version of CallManager that you are interested in.
The dateTimeStamp field of CMR is in the same format as the timestamp fields from CDR (such as dateTimeOrigination, dateTimeConnect) etc, so you can search on that field, and the directoryNumber field contains the extension that the CMR record is for. You can relate the CDR and CMR using the globalCallID_callManagerId and globalCallID_callId fields though you may want to use the timestamp fields as well if you need to be exact, since those fields are reset when CallManager resets, so they aren't unique within the table/database.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...