I have recently preformed a CCM upgrade (4.1->6.1) at one of my customer's. The customer (his admin to be correct) is used to collecting CDRs with SQL queries and making his own reports out of them. Now as we upgraded CCM he wants the same. I showed him how he can now get csv files, export them to Excel an perform whatever he needs. However he still wants to be able to preform queries on DB itself. Is this possible? How? If it's not done like this anymore, I want to prove it to him so he can get used to excel...
Since CCM release 5.x direct access to the database is not allowed anymore so the recommendation for processing CDRs is to move the CDR text based records off the CCM to an external application and process the CDRs there. CCM periodically uploads the CDRs to an external server using FTP.
If database style processing of records (SQL queries) is a must, any medium level programmer can develop an small script so you can insert each CDR record into a true SQL database (MS SQL Server, MySQL, Postgres, whatever suits your mood), then you can have all the tools, statements, etc. provided by the chosen database at your dipsosal.
I myself made such an script some months ago in order to transfer all the TXT records from CCM 5.x / 6.x to a MySQL database), I may post it here if you're interested.
You have reached the Cisco Logistics Support Center.. To Check Status of
your RMA, visit Product Returns & Replacements (RMA). Need help? Contact
us by Phone or Email. North Americas Phone: 1800 553 2447 Option 4
Email: email@example.com Europe Phone: +3...
The short answer is that you don't.... That isn't entirely true while at
the same time it kind of is, but for the most part you don't configure
the softkeys. You enable or disable them via TCL. Here is the long
answer. Be sure to read the whole thing or e...
Topology: IP Phone > Switches > Microsoft NPS setup to forward 802.1x
proxy to > ISE 2.1 patch 3 Authentication: EAP-TLS using Cisco MIC SANs
Phone Models 802.1X support? 802.1x flavor Addtl Comment EAP-MD5 EAP-TLS
Cisco 3905 Y Y N Cisco 6911 Y Y N Cisco ...