Skype for Business (Microsoft Lync)

...

Configuring the SMDR output

The Skype for Business phone system writes its CDR data to a MSSQL database called LcsCDR on the Monitoring Server. In order for TIM Plus to connect to the database and collect the call logging data, a Windows or SQL authenticated login will have to be created to allow access. Contact your system maintainer if you are not familiar with this procedure.

The following information is required for TIM Plus to connect to the LcsCDR database:

• IP address or hostname of the Monitoring Server where the LcsCDR database resides.
• Username and Password of the LcsCDR database.

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

...

1. Open Windows Control Panel and select the

   Buttonmacro
   Label Administrative Tools

    icon

2. Double-click on the Data Sources (ODBC) icon to open the ODBC Data Source Administrator window

   Info
   For a 64 bit system, access the ODBC Data Source Administrator from the following location C:\Windows\SysWOW64\odbcad32.exe

3. Click on the System DSN tab.
4. Click on the Add button.
5. Select SQL Native Client from the driver list and click Finish.
6. In the Name field, enter lync.
7. In the Description field, enter TIM Plus link to LcsCDR.
   
8. In the Server field, enter the IP address or hostname of your SQL server Monitoring Server.
9. In the Username field, enter the username for your 

   Referencemacro
   Label LcsCdr

   databaseLcsCDR database.
10. In the Password field, enter the password for your LcsCDR database.
11. In the Database drop-down list, select select  LcsCDR.
12. Click on the Test button to confirm the information you entered is correct and that the connection is successful.
13. Click on the OK button to close the window.
    
    

An example of an ODBC entry is shown below:

<a id="Configure TIM Plus"></a>

Configuring TIM Plus

Once the DSN connection has been set up, log in to TIM Plus and perform the steps below:

1. Click on the Directory tab.
2. Choose the site you want to configure and click Properties.
   

   Screenshotmacro
   Border false URL http://docs.tri-line.com/download/attachments/16712081/Lync_1.png

3. In the Site Properties window, select Skype for Business 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 lync from the drop-down list.
6. In the Frequency field, enter 5.
7. In the DB script field, select Skype for Business from the drop-down list.
8. Click on the Save button to apply the settings.