Cisco Unified Call Manager up to V4.x

...

Configuring your SMDR output

The This version of the Cisco UCM stores its Call Detail Records CDRs (call detail records) in a MSSQL Microsoft SQL Server database. However, however, the output by default, this functionality is not enabled by default.

To enable the CDR output to the database, the following 'Service' parameters need to must be configured on the Publisher, using  using the Service Parameters Configuration window:

• CDR Enabled
• CDR Log CallsWith Zero Duration Flag
• Call Diagnostics Enabled

The database that TIM Plus will connect to is called 'CDR'. Within this database there is a table called 'CallDetailRecord'. Rather than TIM Plus reading and removing data from the 'CallDetailRecord' table we highly recommend that you setup a second table which is a replication of the 'CallDetailRecord' table. This leaves the original table intact and can This UCM outputs its CDRs to a table named

• Username: CiscoCCMCDR
• Password: dipsy

To setup set up replication you will may need to speak to your Database Administrator database administrator or your Cisco UCM maintainer. The

Here, we will assume you will use a replicated table name should be called 'calldetailrecord2'.Please make sure that when the replication is setup that the above user of

Ensure that the SQL user described above also has full access to the new this replicated table.

You will need to know the following information for TIM Plus to connect successfully to the Cisco UCM CDR database:

• IP /DNS address or hostname of the MS SQL Database which is Microsoft SQL Server database located on the Publisher node.
• Username and Password to connect to the CDR database (you may need to speak to your maintainer about this)

  Referencemacro
  Label CDR

   database.

<a id="Set up a DSN connection"></a>

...

To enable TIM Plus to work with your Cisco UCM, you will first need to set up a DSN connection. Below you will find instructions on how to do this Follow the steps below to perform this task within Microsoft Windows:

1. Click on Windows Start.
2. Click on Control panel.Open Windows Control Panel
3. Double click on the Administrative tools icon.
4. Double click on the Data Sources (ODBC) icon.
5. Click on Select the System DSN tab .Click on the and click the Add button.
6. Select SQL Server from the list of available drivers and click Finish.
7. In the Name field, enter the following:  CCM.
8. In the Description field enter the following: TIM Plus link to CCM.
9. In the Database name field enter the database type e.g SQL, MySQL etc.
10. In the Server drop-down list select the Cisco UCM Publisher IP address or machine name.
11. Click on the Next button.
12. Click on the radio button Select the option  With SQL Server authentication using a login ID and password entered by the user and  , then click on the Next button.
13. Click on the check box Enable the checkbox  Change the default database to: and  , select CDR and , then click on the Next button.
14. Click on the Finish button.
15. Click on the Test Data Source button and once you make sure to verify your settings and, if the test is completed successfullysuccessful, click on the OK button.
16. Now Finally, click on the OK button to close the control panel applet.

An example of ODBC setup is shown below:

...

1. Click on the Directory tab.
2. Select Choose the site configured during the setup wizard you want to configure and click Properties.
   

   Screenshotmacro
   Border false URL http://docs.call-logger.com:8090/download/attachments/4817081/cisco_ucm_2.png

3. Within In the Site Properties window, select Cisco UCM v4 DSN from the PBX model drop-down list.
4. In the Connection method field, select Connect to a system DSN from the drop-down list.
5. In the DSN name field, select Cisco UCM v4 DSN from the drop-down list.
6. Set the Frequency option to 5.
7. In the DB script field, select Cisco UCM v4 DSN from the drop-down list.
8. Click on the Save button to apply the your settings.