Introduction

AlarmLight is a system alarm visual notification software for Avaya Aura Communication Manager. The software integrated with a USB lighting device and showing system alarm by turning on the lighting device and change the color to YELLOW or RED when a MINOR or MAJOR alarm is found. The software is designed for the Avaya Aura Communication Manager, it requires bcmsSVR which gets the alarm information by OSSI interface. The AlarmLight provides the following features:

  • Display multiple system alarms on Service Desk or NOC desktops
  • Turn on the USB lighting device and change the color to YELLOW when MINOR alarm is found
  • Turn on the USB lighting device and change the color to RED when MAJOR alarm is found

Supported USB lighting device

  • Embrava
    • Blynclight PLUS
    • Blynclight Mini

Supported platform

  • AlarmLight software installed on
    • Windows 7, Windows 8 or Windows 10
    • No license required
  • bcmsSVR server software installed on
    • Windows 2008 R2 or above
    • CentOS 6.x or above
    • Ubuntu 14.04 or above
    • Server license is required

AlarmLight Supervisor Windows Installation

  • Download the AlarmLight zip file here.
  • Follow the installation steps below to install the software.
    • Extract all the files into directory c:\program files\AlarmLight
    • Copy AlarmLight.ini from the installation directory to c:\windows directory
    • Edit the _urlxx entry to define the REST interface of “display alarms” which provided by bcmsSVR

Thanks Plenom offers us free samples of Kuando Busylight UC, we have enhanced the AgentLight to support Kuando Busylight UC. The new version of AgentLight 1.2.0 is just released, it has the following enhancement.

1. Supports Kuando Busylight UC.
2. A new parameter called _vendor is added in agentlight.ini to specify the busylight vendor. Please input “kuando” for Kuando Busylight UC.
3. Enter the following command using Administrator right to register the Kuando Busylight DLL if you are using Kuando Busylight UC.
cd c:\program files\AgentLight
%windir%\Microsoft.NET\Framework\v4.0.30319\regasm.exe busylightsdk.dll /tlb:busylightsdk.tlb /codebase

AvayaCDR 1.5.18 Released

Posted: March 10, 2018 in Avaya CDR, News

AvayaCDR 1.5.18 just release, the updates are 

1. Supports IP Office added fields 31 to 34. These fields are used to uniquely identify a call made in an IP Office Server Edition solution.

Customers who subscribed the annual email support service are entitled to software upgrade. Please contact support for the download URL.

CallAnalytics 2.0.6 Released

Posted: February 12, 2018 in News, TSAPI

CallAnalytics 2.0.6 just released. This release has the following updates

1. Fixed a minor bug without releasing device in the Splunk and databaes logging.
2. Added a REST interface to query call answer extensions.
3. Fixed a bug to prevent multi-threading dead locking.

QueueLight

Posted: January 28, 2018 in AgentLight

Introduction

QueueLight is a call queue visual notification software for Avaya contact center. The software integrated with a USB lighting device and showing the call queue status by turning on the lighting device and change the color to YELLOW or RED when a warning threshold or critical threshold is reached respectively. The software is designed for the Avaya contact center environment; it integrated with Avaya AES to get the call queue status with TSAPI library. The QueueLight has GUI software installed on supervisor workstations and server software installed on server such as Windows 2008R2 or above. The QueueLight provides the following features:

  • Display multiple queue call status on supervisor desktops
  • Turn on the USB lighting device and change the color to YELLOW when warning threshold is reached
  • Turn on the USB lighting device and change the color to RED when critical threshold is reached

Supported USB lighting device

  • Embrava
    • Blynclight PLUS
    • Blynclight Mini

Supported platform

  • QueueLight supervisor software installed
    • Windows 7, Windows 8 or Windows 10
  • QueueLight server software installed on
    • Windows 2008 R2 or above

Preparation and Password Encryption

  • The access MDB file stored the username and password of AE server. For security reason, a tool called encryptpasswd.exe is provided to generate an encrypted password for the installation and configuration of the software
  • Execute the program, generate an encrypted passwords for the user of AE server, then paste the encrypted password to parameter ivr_tlink. For example, the encrypted password for “p@ssword” is “R3NIw1yJMLlnPFzEQtuh2A==”
  • encryptpasswd

64 bit Windows System 

  • For 64 bit Windows system, please follow the steps below
    • Download and install the Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package MFC Security Update http://www.microsoft.com/en-hk/download/details.aspx?id=26368, select the x86 version
    • Configure ODBC System DSN using
    • C:\Windows\SysWOW64\odbcad32.exe
    • Configure the Windows firewall for the application. By default telnet port 15013 and handler port 9002 are required on the QueueLightSVR

QueueLight Server Windows Installation

  • Download and install the TSAPI client for Windows 32-bit from Avaya web site, it contains the library files. DevConnect registration is required before you can access the download page.
  • Download the QueueLightSVR zip file here or backup site.
  • Follow the installation steps below to install the software.
    • Extract all the files into directory c:\program files\QueueLightSVR
    • Open Windows Command Prompt, enter the following commands to register the program as Windows Service
      • cd c:\program files\QueueLightSVR
      • QueueLightSVR -i
    • Open ODBC Setting, create a System DSN called QUEUELIGHTSVRCFG for Microsoft Access Driver and point to QueueLightSVR.mdb which is located in the directory c:\program files\QueueLightSVR
    • Open the Access file, edit the value of parameters ivr_tlink_01 and ivr_tlink_02 to the TLINK of your AES servers in the tParameter table
    • Start the Windows Service QueueLightSVR
    • Telnet to localhost and port number 15013, enter username tcpgate and password tcpgate01 to access the program console
    • Enter the following command to add agentlight handler port
      • add tcp 9002 * * custom queuelightapi
    • Enter the following command to add IP address of supervisor desktop
      • add client 10.1.1.100
    • Enter the following command in the program console, you will receive debug information
      • trace on asc
    • Enter the following command in the program console, you will get the help message
      • help

QueueLight Supervisor Windows Installation

  • Download the QueueLight zip file here.
  • Follow the installation steps below to install the software.
    • Extract all the files into directory c:\program files\QueueLight
    • Copy QueueLight.ini from the installation directory to c:\windows directory
    • Edit the _server entry to point to the QueueLightSVR IP address
    • Edit the _port entry to point to the QueueLightSVR queuelightapi handler port
    • Edit the _warning entry to define the warning threshold
    • Edit the _critical entry to define the critical threshold
    • Edit the _skillxx entry to define the ACD skill number and its name

AgentLight

Posted: January 19, 2018 in AgentLight

Introduction

AgentLight is software for Avaya agent status notification. The software integrated with a USB lighting device and showing the agent status by turning on or flashing the device with different color. For example, the software can be configured to show agent idle with green color and on call with red color. The software is designed for the Avaya contact center environment; it integrated with Avaya AES to get the agent status with TSAPI library. The AgentLight has agent software installed on agent workstations and server software installed on server such as Windows 2008R2 or above. The AgentLight provides the following features:

  • Agent presence with different color and flashing
  • Identification of assist calls or hold calls
  • Identification of shuffling among nearby agents
  • Identification of short duration calls among nearby agents
  • Identification of long ACW time
  • Identification of long AUX time with specific reason

Supported USB lighting device

  • Embrava
    • Blynclight PLUS
    • Blynclight Mini
  • Plenom
    • Kuando BUSYLIGHT UC Omega
    • Kuando BUSYLIGHT UC Alpha

Supported platform

  • AgentLight agent installed on
    • Windows 7, Windows 8 or Windows 10
  • AgentLight server installed on
    • Windows 2008 R2 or above

The configuration is centrally managed on the AgentLight Server. The default configurations for agent on call and ACD state as follow:

Agent on Call

Call State Color Flashing
alerting orange 1
connect red 0
fail orange 1
hold red 1
idle off 0
initiate orange 1
null off 0

Agent ACD State

State Reasoncode Color Threshold
acw 0 white 60
auto 0 green 0
aux 0 blue 0
aux 1 blue 30
aux 2 blue 30
aux 3 blue 30
aux 4 blue 30
aux 5 blue 30
aux 6 blue 30
aux 7 blue 30
aux 8 blue 30
aux 9 blue 30
manual 0 green 0
null 0 off 0

Supported Color

  • red
  • green
  • blue
  • cyan
  • magenta
  • yellow
  • white
  • orange
  • off

Preparation and Password Encryption

  • The access MDB file stored the username and password of AE server. For security reason, a tool called encryptpasswd.exe is provided to generate an encrypted password for the installation and configuration of the software
  • Execute the program, generate an encrypted passwords for the user of AE server, then paste the encrypted password to parameter ivr_tlink. For example, the encrypted password for “p@ssword” is “R3NIw1yJMLlnPFzEQtuh2A==”
  • encryptpasswd

64 bit Windows System

  • For 64 bit Windows system, please follow the steps below
    • Download and install the Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package MFC Security Update http://www.microsoft.com/en-hk/download/details.aspx?id=26368, select the x86 version
    • Configure ODBC System DSN using
    • C:\Windows\SysWOW64\odbcad32.exe
    • Configure the Windows firewall for the application. By default telnet port 15012 and handler port 9002 are required on the AgentLightSVR

AgentLight Server Windows Installation

  • Download and install the TSAPI client for Windows 32-bit from Avaya web site, it contains the library files. DevConnect registration is required before you can access the download page.
  • Download the AgentLightSVR zip file here or backup site.
  • Follow the installation steps below to install the software.
    • Extract all the files into directory c:\program files\AgentLightSVR
    • Open Windows Command Prompt, enter the following commands to register the program as Windows Service
      • cd c:\program files\AgentLightSVR
      • AgentLightSVR -i
    • Open ODBC Setting, create a System DSN called AGENTLIGHTSVRCFG for Microsoft Access Driver and point to AgentLightSVR.mdb which is located in the directory c:\program files\AgentLightSVR
    • Open the Access file, edit the value of parameters ivr_tlink_01 and ivr_tlink_02 to the TLINK of your AES servers in the tParameter table
    • Start the Windows Service AgentLightSVR
    • Telnet to localhost and port number 15012, enter username tcpgate and password tcpgate01 to access the program console
    • Enter the following command to add agentlight handler port
      • add tcp 9002 * * custom agentlightapi
    • Enter the following command to add extension, the AgentLightSVR can control the extension once it is added to the database
      • add extension 60123
    • Enter the following command to map IP address with extension
      • add ipextnmap 10.1.1.100 60123
    • Enter the following command in the program console, you will receive debug information
      • trace on asc
    • Enter the following command in the program console, you will get the help message
      • help

AgentLight Agent Windows Installation

  • Download the AgentLight zip file here.
  • Follow the installation steps below to install the software.
    • Extract all the files into directory c:\program files\AgentLight
    • Open Windows Command Prompt, enter the following commands to register the program as Windows Service
      • cd c:\program files\AgentLight
      • AgentLight -i
    • Copy AgentLight.ini from the installation directory to c:\windows directory
    • Edit the _server entry to point to the AgentLightSVR IP address
    • Edit the _port entry to point to the AgentLightSVR agentlightapi handler port
    • Edit the _extension entry to define extension number locally, this is useful when the PC is configured DHCP

AvayaECHI Splunk Use Cases

Posted: January 1, 2018 in CMS

Background

With reference to the Avaya CMS External Call History Interface document and the data fields, we can produce many use cases by using AvayaECHI tool and Splunk. The following guide assumes you already installed the AvayaECHI tool and imported the data to Splunk.

Caller On Hold Reports

  • Caller On Hold Details Report
    index=echi ANSHOLDTIME>0 HELD>0 TRANSFERRED=0 | table ACD, CALLID, SEGMENT, SEGSTART, SEGSTOP, DISPSPLIT, DISPVDN, CALLING_PTY, DIALED_NUM, ANSLOGIN, AGT_RELEASED, TALKTIME, ANSHOLDTIME, HELD, QUEUETIME
  • Caller On Hold Abandons Details Report
    index=echi ANSLOGIN=* DISPSPLIT=* TRANSFERRED=0 HOLDABN=1 | table ACD, ANSLOGIN, DISPSPLIT, TALKTIME, ANSHOLDTIME, HELD, HOLDABN
  • Caller On Hold Abandon Top 10 Agents Report
    index=echi ANSLOGIN=* DISPSPLIT=* TRANSFERRED=0 HOLDABN=1 | table ACD, ANSLOGIN | stats count as AbandonCalls by ACD, ANSLOGIN | sort limit=10 - AbandonCalls

Caller Calls Reports

  • Search Calls by Specific CALLING_PTY
    index=echi CALLING_PTY=XXXXXXXX
  • Search Calls by Prefix and Wildcard
    index=echi CALLING_PTY=123*

Outbound Calls Reports

  • Search Calls by Specific ORIGLOGIN
    index=echi ORIGLOGIN=XXXXX
  • Search Calls by Specific CALLING_PTY
    index=echi CALLING_PTY=XXXXX

Queue Wait Time Reports

  • Search Calls by QUEUETIME
    index=echi QUEUETIME>=60 | table ACD, CALLID, SEGMENT, SEGSTART, SEGSTOP, DISPSPLIT, DISPVDN, CALLING_PTY, DIALED_NUM, ANSLOGIN, AGT_RELEASED, TALKTIME, ANSHOLDTIME, HELD, QUEUETIME | sort - QUEUETIME

Short Duration Reports

  • Search Calls by TALKTIME
    index=echi TALKTIME>0 TALKTIME<5 TRANSFERRED=0 | table ACD, CALLID, SEGMENT, SEGSTART, SEGSTOP, DISPSPLIT, DISPVDN, CALLING_PTY, DIALED_NUM, ANSLOGIN, AGT_RELEASED, TALKTIME, ANSHOLDTIME, HELD, QUEUETIME
  • Short Duration Top 10 Agents Report
    index=echi TALKTIME>0 TALKTIME<5 TRANSFERRED=0 | stats count as ShortCalls by ACD, ANSLOGIN | sort limit=10 - ShortCalls

Call Profile Reports

  • Call Abandon by Call Profile Report (Split)
    index=echi ACD=X CALL_DISP=3 DISPSPLIT=Y | rangemap field=QUEUETIME short=0-15 medium=16-60 default=long | bucket _time span=1h | timechart count by range
  • Call Abandon by Call Profile Report (VDN)
    index=echi ACD=X CALL_DISP=3 DISPVDN=Y | rangemap field=QUEUETIME short=0-15 medium=16-60 default=long | bucket _time span=1h | timechart count by range
  • Call Answered by Call Profile Report (Split)
    index=echi ACD=X CALL_DISP=2 DISPSPLIT=Y | rangemap field=QUEUETIME short=0-15 medium=16-60 default=long | bucket _time span=1h | timechart count by range
  • Call Answered by Call Profile Report (VDN)
    index=echi ACD=X CALL_DISP=2 DISPVDN=Y | rangemap field=QUEUETIME short=0-15 medium=16-60 default=long | bucket _time span=1h | timechart count by range

Find All Activity For A Specific Agent

  • index=echi ACD=X (ANSLOGIN=YYYYY OR ORIGLOGIN=YYYYY)

Find Long Or Short Customer Calls

  • index=echi ACD=X TALKTIME<Y CALLING_PTY=* ANSLOGIN=* | table ACD, ANSLOGIN, DISPVDN, DISPSPLIT, CALLING_PTY
  • index=echi ACD=X TALKTIME>Z CALLING_PTY=* ANSLOGIN=* | table ACD, ANSLOGIN, DISPVDN, DISPSPLIT, CALLING_PTY

Find The Destination Of Transfer or Conference Calls

  • index=echi TRANSFERRED=1 OR CONFERENCE=1 ORIGLOGIN=* DIALED_NUM=* | table ACD, ORIGLOGIN, CALLING_PTY, DIALED_NUM

Find Abandoned Calls For A Specific Skill

  • index=echi CALL_DISP=3 DISPSPLIT=X | table CALLING_PTY, DIALED_NUM

Identify Repeat Callers Whether Answered Or Abandoned

  • index=echi DISPSPLIT=X CALL_DISP=3 OR CALL_DISP=2 | stats count by CALLING_PTY | sort - count

List Last Call Work Codes By Agent

  • index=echi LASTCWC=*

Outbound Calls with Aux Reason Code Reports

  • index=echi ORIGLOGIN=* ORIGREASON=X | table ORIGLOGIN, ORIGREASON, DIALED_NUM, TALKTIME, DURATION

Agent Disconnects First Reports

  • Agent Disconnects Details Report
    index=echi ANSLOGIN=* AGT_RELEASED=1 CONFERENCE=0 TRANSFERRED=0 | table ACD, ANSLOGIN, DISPSPLIT, CALLING_PTY, TALKTIME, AGT_RELEASED
  • Agent Disconnects Top 10 Report
    index=echi ANSLOGIN=* AGT_RELEASED=1 CONFERENCE=0 TRANSFERRED=0 | stats count as DropCalls by ACD, ANSLOGIN | sort limit=10 - DropCalls

Agent Transferred Call to Same VDN Reports

  • Agent Transferred Same VDN Calls Details Report
    index=echi ANSLOGIN=* TRANSFERRED=1 DIALED_NUM=* | where DISPVDN=DIALED_NUM | table ACD, ANSLOGIN, TRANSFERRED, DISPVDN, DIALED_NUM
  • Agent Transferred Same VDN Calls Top 10 Agents Report
    index=echi ANSLOGIN=* TRANSFERRED=1 DIALED_NUM=* | where DISPVDN=DIALED_NUM | stats count as TransferredCalls by ACD, ANSLOGIN | sort limit=10 - TransferredCalls

Calls Answered Skill Level Reports  

  • Call Answered by Skill Level Details Report 
    index=echi ACD=X DISPSPLIT=Y ANSLOGIN=* | table ACD, DISPSPLIT, ANSLOGIN, DISPSKLEVEL, TALKTIME | sort + DISPSPLIT, DISPSKLEVEL
  • Call Answered by Skill Level Distribution Report 
    index=echi ACD=X DISPSPLIT=Y ANSLOGIN=* | stats count as NumCalls by DISPSKLEVEL

Long Wrap-up Time Reports

  • Long Wrap-Up Time Details Report
    index=echi ANSLOGIN=* ACWTIME>0 | table ACD, ANSLOGIN, DISPSPLIT, TALKTIME, ACWTIME, ANSHOLDTIME | sort - ACWTIME
  • Long Wrap-Up Time Top 10 Agents Report
    index=echi ANSLOGIN=* ACWTIME>0 | stats sum(ACWTIME) as WrapUpTime by ACD, ANSLOGIN | sort limit=10 - WrapUpTime

Call Handling Time Reports

  • Call Handling Time Details Report
    index=echi ACD=X DISPSPLIT=Y ANSLOGIN=* | eval TotalTime=TALKTIME+ANSHOLDTIME+ACWTIME | table ACD, ANSLOGIN, DISPSPLIT, TALKTIME, ANSHOLDTIME, HELD, ACWTIME, TotalTime | sort + ACD, ANSLOGIN
  • Call Handling Time Distribution Report
    index=echi ACD=X DISPSPLIT=Y ANSLOGIN=* | stats sum(ACWTIME) as ACWTime, sum(TALKTIME) as TalkTime, sum(ANSHOLDTIME) as HoldTime by ACD, ANSLOGIN | fields - ACD