Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Configuring the SMDR output

By default, the Skype for  The Skype for Business phone system writes its CDR data to a MSSQL database called LcsCdr LcsCDR on the Monitoring Server. In order for TIM Enterprise 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 Enterprise to connect to the LcsCdr LcsCDR database:

  • IP address or hostname of the SQL Monitoring Server where the LcsCdr LcsCDR database resides.
  • Username and Password of the LcsCdr LcsCDR database.
HTML
<a id="Set up a DSN connection"></a>

Setting up a DSN connection

To enable TIM Plus Enterprise to work with your Skype for Business phone system, you first need to set up a DSN connection by following the steps below:

  1. Open Windows Control Panel and select the
    Buttonmacro
    LabelAdministrative Tools
    icon. icon
  2. Double-click on the ButtonmacroLabelthe Data Sources (ODBC) icon to open the ReferencemacroLabelODBC Data Source AdministrationAdministrator 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 Enterprise link to LcsCdrLcsCDR.
  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 LcsCdr LcsCDR database.
  10. In the Password field, enter the password for your LcsCdr LcsCDR database.
  11. In the Database drop-down list, select  LcsCdrselect 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:

Screenshotmacro
Borderfalse
Shadowfalse
URL/download/attachments/16712081/Lync_ODBC.png

HTML
<a id="Configure TIM Enterprise"></a>

Configuring TIM Enterprise

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

  1. Click on the Directory tab.
  2. Locate the PBX object you want to configure in the Directory, right-click on it and select Properties.
  3. A new window will open, displaying the general properties of your PBX object. Select Skype for Business from the Data format list and tick the Keep a local backup of data box, as shown below:
    Screenshotmacro
    Borderfalse
    Shadowfalse
    URL/download/attachments/16712117/skype_for_business_1.png

  4. Click on the Connection tab and select System DSN connection from the Connection method list.
  5. In the DSN field, select lync from the drop-down list.
  6. In the Frequency field, enter to check for data every five seconds.
  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.
    Screenshotmacro
    Borderfalse
    Shadowfalse
    URL/download/attachments/16712117/skype_for_business_2.png