...
This version of the Cisco UCM stores its CDRs ( call detail records ) in a Microsoft SQL Server database. However, by default, this functionality is not enabled. To enable CDR output to the databaseit, the following 'Service' parameters must settings must be configured on the Publisher using the Service Parameters Configuration configuration window:
- CDR Enabled
- CDR Log CallsWith Calls With Zero Duration Flag
- Call Diagnostics Enabled
This version of the UCM outputs its CDRs call records to a table named
in a database entitled
. Rather than have TIM Plus read and remove CDRs from the live
table, we recommend you replicate this into a second table
, - leaving the original intact
- so that it may be used by other applications that
may require it. Normally, there already exists a SQL User with the following credentials:
...
To set up replication you may need to speak to your database administrator or your Cisco UCM maintainer.Here, we will assume you will use a replicated table name of
.Ensure that the SQL user described above also has full access rights to this replicated table. You need to know the following information for TIM Plus to connect successfully to the Cisco UCM CDR database:
- IP address or hostname of the Microsoft SQL Server database located on the Publisher node.
- Username and Password to connect to the database.
...