External Queue Reports

Feature Description

The UCx External Queue Reports application was developed to give a simple method of allowing read only access to Queue related information from a remote server. This allows the user to access the data with a standard MySQL client or third party application to access the data directly for their specific purposes.The External Queue Reports Interface application has the following attributes:

  • Configuration is done through the UCx web interface 
  • A user name and password can be configured with remote read only access privileges to the Queue Reports records
  • Remote access can be enabled and disabled
This functionality is not supported on the Galaxy Mini hardware platform.

 

Pre-Requisites

  1. UCx server is installed with the latest E-Metrotel software.
  2. An updated license to include the UCX External Contact Center Reports Interface software.
  3. An external MySQL client or third party application to access data.

Back Up MySQL Database

The MySQL database should be backed up when installing, upgrading or uninstalling the UCX External Contact Center Reports Interface feature.

Go to Backup page for details on how to create a backup.

From the Perform a Backup panel:

  1. Select the MySQL Database checkbox
  2. Press the Process button to create the backup

Install License String

Go to Licenses page for details on how to:

  • Obtain a new license for the UCX External Contact Center Reports Interface
  • Enter the updated license. 

Install Software Package

First you will need to have the latest UCx software. Go to Software Update page in the Administration Guide for details on updating your software.

Next you need to install the ucx-eci package. Go to Packages page in the Administration Guide for details on installing packages.

From the Packages panel:

  1. Select the Show Filter tab and enter ucx-eqr for the Name, enter All for the Status
  2. Click the Install link under the Status column to install the package

EQR_Install_0.png

Enable External Access

To access the External Queue Reports configuration page, perform the following steps:

  1. Open the UCx Web-based Configuration Utility
  2. From the System tab, select Accessories
  3. From the left side column, select External Queue Reports
  4. In the External Access field, select Enabled from the drop-down list
  5. Enter a user name in the User ID field
  6. Enter a password in the Password field
  7. Press the Save button

EQR-Enable.png

Disable External Access

To disable external access to CDR records, follow the steps in the previous section to access the External CDR Interface configuration page.

From the External CDR Interface page:

  1. In the External Access field, select Disabled from the drop-down list
  2. Press the Save button

EQR-Disable.png

Testing the Interface

The following steps describe a simple method to test the External CDR Interface application: 

  1. Complete the setup and configuration as described on this page, making sure that External Access is Enabled
  2. Download and install a MySQL Client application (e.g. Heidi SQL).
  3. Launch the MySQL Client application, create a session that connects to the UCx Server. Enter the IP address of the UCx Server and the External Queue Reports interface account that was created.
    If the client is located outside of the firewall where the UCx resides, the firewall is required to be configured to allow inbound TCP packets on the Port configured in the above dialog box (i.e. TCP port 3306 by default).

       

  4. Open the session and you should see two database schema files: information_schema and asteriskcdrdb.
  5. Expand the schemas to see the data as desired.
Page Tags: 
cdr
external interface