client matter code and forced authorized in cisco call manager

Hi there,
While configuring route patterns in Cisco call manager, it has the option to tick Client Matter code (CMC) and forced authorization code ? Now I've read the theory behind it and understand that when the dialer enters the required CMC code, it appends the code to the Call Manager's CDR database for accounting and billing purposes. But my question is where is the database of the CMC itself ? i.e. The codes the user enters ? where are they stored ? Is that somewhere in the CUCM configuration or is that a third party tool that is integrated with CUCM ? Thanks !
Am using CUCM 6.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

It stored in the informix database that runs in the background on the CUCM server. Can you not see them don't really understand your question?
nabeel92Author Commented:
How can i add CMC codes to the informix database ? So consider a scenario where I want certain users who dials an International call would need to enter a CMC before they dial out. Where can i configure such an option ?
Well, there's two parts to this :
1) You configure your Route patterns accordingly with the CMC / FAC options so that the CCM service will request a FAC / CMC code from the caller when dialing out.
2) You retrieve the call data, CUCM creates a CDR (Call Detail Record) for each call and stores them in flat files on the Publisher. From there, you have two options on how to use that raw CDR data:
- use the built-in CAR webpage to do you reporting, it has some templates for CMC / FAc by default, see this page for more info :
Remember to activate the CDR Analysis & Reporting Service or you won't find the option in the menu
- or if it does not fit your requirements, from Serviceability - Tools - CDR Management you can configure the CUCM publisher to deliver the CDR records to an SFTP server, from there you can do whatever you want with the data, search the Cisco website for 'CDR Schema' to know how to interpret the data

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nabeel92Author Commented:
Ahh my bad, I found the CMC codes on CM under Bulk admin tools in CM menu ... But thanks for the above info ... i'll dig deep into what you mentioned above but right now just familiarizing myself with the basic CM...thxn
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
IP Telephony

From novice to tech pro — start learning today.