Archive for the ‘CMS’ Category

clintSVR 1.3.6 Released

Posted: November 16, 2017 in CMS, News

clintSVR 1.3.6 just released, a custom real time report called “upsplitskillreport” which is modified from the standard Split/Skill Report is provided for customers who subscribe the annual email support service from UPINGET Technologies. This report provides additional CMS real time database items such as:

  1. Calls Offered
  2. Service Level in Seconds
  3. Direct Agent Calls Waiting
  4. EWT Top
  5. EWT High
  6. EWT Medium
  7. EWT Low
  8. Percent Within Service Level
  9. Percent Answered
  10. Percent Abandoned

The report template “upsplitskillreport” can be obtained via UPINGET support service. You can follow the procedure below to create and upload the template to your CMS server.

  1. Open CMS Terminal and create a new custom real time report called “upsplitskillreport”
  2. Select Screen Painter from the menu
  3. Select Save design from the menu
  4. Check the new file name in CMS server directory /cms/db/gem/r_custom
  5. For example, a new file called cr_r_15 is created. Delete the file cr_r_15 and copy the template file upsplitskillreport and rename it as cr_r_15
  6. The report is ready, you can execute it and get the data via clintSVR API, OCX, REST and WebSocket interfaces

Add and Delete Report in TcpGate Console 

  1. The tcpgate console command is
    • add upsplitskillreport 1 123;456;789 mycomment
      • Add upsplitskillreport for ACD 1 and skills 123, 456 and 789
    • delete upsplitskillreport 1 123;456;789
      • Delete upsplitskillreport

REST Interface 

  1. The REST interface to query the report is
Advertisements

AvayaECHI 1.1.11 Released

Posted: August 3, 2017 in CMS, News

AvayaECHI 1.1.11 just released. The updates are 

1. A parameter called “echi_splunk_logdir” is added for storing splunk log in specified directory. We can configure Splunk Universial Forwarder to import the splunk log to Splunk to prevent data loss when there is network issue.

clintSVR 1.3.5 Released

Posted: July 8, 2017 in CMS, News

clintSVR 1.3.5 just released, the updates are 

1. Supports CMS 18 Multi Agent Add/Change/Delete Skill features.
2. Fixed telnet malfunction after deletion of report for Linux 64 bit OS.
3. Add report type rtashuffling and rtasnapshot for CustomRTA Splunk logging.
4. Supports debug log and the log file name is debug.txt
5. Fixed trunk group report REST interface without trunk group name.
6. When input object mismatch with output result, the default action is to return immediately to prevent incorrect data logging for splunk and database interfaces. This is overridden by a parameter called cs_iomismatch when it’s value is set to true.
7. Add escape character for special character in database logging.

By using ClintSVR and Splunk, we can create wallboard or dashboard for a project very quickly. For example, the following Splunk dashboard can be created in 10 minutes.

Assuming you have a project which has of a group of skills, the first thing to do is to get the real time data from that group of skills. You can use ClintSVR SplitSkillReport which allows you to add a report with multiple skills and then output the real time data to Splunk. For example, the command to add a report in ClintSVR is

add splitskillreport 1 36;38;265;266;459;467;514;770 10 orange

Once you have configured ClintSVR to send data to Splunk, the real time data will be searched in Splunk every 10 seconds. Then you can create the Splunk dashboards by the following procedures.

Split Skill Report Table

  • The Splunk Search command (use 15 minutes time range) for a table of Split Skill Report is
  • index=cms report=splitskillreport [search index=cms report=splitskillreport skill=770 | head 1 | fields + timestamp] | dedup skill | table _time, skill, callswaiting, oldestcallwaiting, avgspeedans, acdcalls, avgacdtalktime, callsabandoned, avgabantime | sort + skill
  • The Splunk Visualization is
  • Add to Splunk Dashboard and edit the XML source to configure the refresh rate, for example 15 seconds
  • The Dashboard result is

Agent Status Bar Chart 

  • The Splunk Search command (use 15 minutes time range) for a bar chart of agent status is
  • index=cms report=splitskillreport [search index=cms report=splitskillreport skill=770 | head 1 | fields + timestamp] | table skill, agentsavailable, agentsringing, agentsacdcalls, agentsacw, agentsother, agentsauxwork | sort + skill
  • The Splunk Visualization is
  • Add to Splunk Dashboard, the result is

KPI Time Charts

  • The Splunk Search commands (use 4 hours time range) for KPI time charts such as calls waiting, oldest call waiting, average speed of answer are
  • index=cms report=splitskillreport | timechart avg(callswaiting) by skill usenull=f useother=f
  • index=cms report=splitskillreport | timechart avg(callsabandoned) by skill usenull=f useother=f
  • index=cms report=splitskillreport oldestcallwaiting > -1 | timechart avg(oldestcallwaiting) by skill usenull=f useother=f
  • index=cms report=splitskillreport avgspeedans > -1 | timechart avg(avgspeedans) by skill usenull=f useother=f
  • index=cms report=splitskillreport avgacdtalktime > -1 | timechart avg(avgacdtalktime) by skill usenull=f useother=f
  • index=cms report=splitskillreport avgabantime > -1 | timechart avg(avgabantime) by skill usenull=f useother=f
  • Add each of the result to Splunk Dashboard, the final Dashboard result is

 

clintSVR 1.3.4 Released

Posted: February 12, 2017 in CMS, News

12 Feb 2014, clintSVR 1.3.4 just released. This version has the following changes: 

1. Improve the SSH read function by increasing the buffer size.
2. Fixed SSH keyboard-interactive Authentication error when using libssh2.

clintSVR 1.3.3 Released

Posted: January 31, 2017 in CMS, News

31 Jan 2017, clintSVR 1.3.3 just released. This version has the following changes: 

1. Supports Multiple Active Result Sets (MARS) for MSSQL. A parameter cs_rtdb_mssqlmars is defined. Set it to true if this feature is enabled for MSSQL. Also, a parameter cs_rtdb_mssqlobject is introduced when database object name is needed.
2. Add multiAgentAddSkill, multiAgentDeleteSkill and multiAgentModifySkill functions. These function can be accessed by the REST, WebSocket, API ALL and OCX interfaces.

clintSVR 1.3.2 Released

Posted: December 16, 2016 in CMS, News

16 Dec 2016, clintSVR 1.3.2 just released. This version have the following minor changes

1. Linux version checks MySQL is available before creation of internal objects during startup.
2. Add additional checking to prevent SplitSkillStatus report with invalid entry.
3. Add additional coding to bypass 100% cpu issue for Linux CMS r18.