I reviewed our SQL tables and found CDR (we enabled CDR and diagnostic CDR and ART) had 1.2 million rows using a lot of disk space. Art was almost as big. We wanted to delete everything older than Jan 2002 (we export is to Infotel for billing on a daily basis).
Not sure if this was best done via SQL commands, or if Cisco had any tools.
Our last upgrade took forever due to a large CDR database. How can we best regulary minimize these tables ?
You could either set up a DTS Package on the CallManager publisher to delete records older than a certain date, or you could use ARTs Database Purge feature. By default, I believe that ART is configured to purge the database of all ART records older than 180 days (approx 6 months) and CDR records older than 60 days, but it is disabled unless changed by a user.
You can perform a manual or automatic purge. Look up the "Database Purge" topic in the ART help files, and it will show you how to configure ART to purge old CDR and ART records when ART retrieves it's data. Or, in ART on the System menu, go to Database and choose Database Purge, and that will bring up the Purge options screen.
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 ...