I’m still new to InfluxDB and Grafana, even though I’ve been using them for a couple years now. However, I’m having issues displaying data how I want in a table. I have a script (see code below) that runs every 5 seconds (kinda… still working on making that precise) to pull data from our Cisco UCCX api (see api json below) and send it to InfluxDB. The API contains text and numerical values, so I send those to separate measurements (test and test2, respectively). I’m able to get data to display in the table, but I want to show only 1 row per user ($jName), and ensure that the row is display the latest data.
How the table is configured:
https://imgur.com/8L5Qi73
https://imgur.com/WdNXP2y
https://imgur.com/uPz2KmP
https://imgur.com/vGnUNo4
Note: I did try to set Metrics > Options > Min time interval and Time range > Override relative time | Last to 5s, but only 1 user would display in the table, but it was at least the last/latest value… If only I can get the table to show all of the users 1 time… Any help is greatly appreciated, as I’m quite stuck.
Bash Script:
#!/bin/bash
getdatasend () {
#get system time
jsystime=$(date +%s%3N)
#convert to influxdb timestamp format
jtime=$((jsystime*1000000))
curl 'http://10.10.66.16:9080/realtime/ResourceIAQStats' > ResourceIAQStats-temp
while read -r jID
read -r jName
read -r jState
read -r jReason
read -r jResourceState
read -r jDurState
read -r jHanCon
read -r jPresCon
read -r jAvgTalkDur
read -r jLongTalkDur
read -r jAvgHoldDur
read -r jLongHoldDur
read -r jAvgHanDur
read -r jAvgWorkDur
read -r jTotTalkTime
read -r jTotHoldTime
read -r jMaxReadyTime
read -r jAvgReadyTime
read -r jTotReadyTime
read -r jMaxNotReadyTime
read -r jAvgNotReadyTime
read -r jTotNotReadyTime
read -r jMaxWorkTime
read -r jTotWorkTime
read -r jLogonDur
read -r jTotResTime
read -r jOtherTime
read -r jAvgAnsSpeed
read -r jReasonCode
read -r jAvgTalkWin1
read -r jAvgHoldWin1
read -r jAvgTalkWin2
read -r jAvgHoldWin2; do
echo "Time in nanoseconds: $jtime"
echo "resourceId: $jID"
echo "resourceName: $jName"
echo "resourceState: $jState"
echo "rsrcCurrentStateReason: $jReason"
echo "strResourceState: $jResourceState"
echo "durationInStateMillis: $jDurState"
echo "nHandledContacts: $jHanCon"
echo "nPresentedContacts: $jPresCon"
echo "avgTalkDuration: $jAvgTalkDur"
echo "longestTalkDuration: $jLongTalkDur"
echo "avgHoldDuration: $jAvgHoldDur"
echo "longestHoldDuration: $jLongHoldDur"
echo "avgHandleDuration: $jAvgHanDur"
echo "avgWorkDuration: $jAvgWorkDur"
echo "totalTalkTime: $jTotTalkTime"
echo "totalHoldTime: $jTotHoldTime"
echo "maxReadyTime: $jMaxReadyTime"
echo "avgReadyTime: $jAvgReadyTime"
echo "totalReadyTime: $jTotReadyTime"
echo "maxNotReadyTime: $jMaxNotReadyTime"
echo "avgNotReadyTime: $jAvgNotReadyTime"
echo "totalNotReadyTime: $jTotNotReadyTime"
echo "maxWorkTime: $jMaxWorkTime"
echo "totalWorkTime: $jTotWorkTime"
echo "logonDuration: $jLogonDur"
echo "totalReservedTime: $jTotResTime"
echo "otherTime: $jOtherTime"
echo "avgSpeedOfAnswer: $jAvgAnsSpeed"
echo "rsrcCurrentStateReasonCode: $jReasonCode"
echo "avgTalkingWindow1: $jAvgTalkWin1"
echo "avgHoldWindow1: $jAvgHoldWin1"
echo "avgTalkingWindow2: $jAvgTalkWin2"
echo "avgHoldWindow2: $jAvgHoldWin2"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test,user=$jID,sensor=ResourceName value=$jName $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test,user=$jID,sensor=AgentState value=$jState $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test,user=$jID,sensor=StateReason value=$jReason $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=resourceState value=$jResourceState $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=durationInStateMillis value=$jDurState $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=nHandledContacts value=$jHanCon $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=nPresentedContacts value=$jPresCon $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgTalkDuration value=$jAvgTalkDur $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=longestTalkDuration value=$jLongTalkDur $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgHoldDuration value=$jAvgHoldDur $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=longestHoldDuration value=$jLongHoldDur $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgHandleDuration value=$jAvgHanDur $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgWorkDuration value=$jAvgWorkDur $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=totalTalkTime value=$jTotTalkTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=totalHoldTime value=$jTotHoldTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=maxReadyTime value=$jMaxReadyTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgReadyTime value=$jAvgReadyTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=totalReadyTime value=$jTotReadyTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=maxNotReadyTime value=$jMaxNotReadyTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgNotReadyTime value=$jAvgNotReadyTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=totalNotReadyTime value=$jTotNotReadyTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=maxWorkTime value=$jMaxWorkTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=totalWorkTime value=$jTotWorkTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=logonDuration value=$jLogonDur $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=totalReservedTime value=$jTotResTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=otherTime value=$jOtherTime $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgSpeedOfAnswer value=$jAvgAnsSpeed $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=rsrcCurrentStateReasonCode value=$jReasonCode $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgTalkingWindow1 value=$jAvgTalkWin1 $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgHoldWindow1 value=$jAvgHoldWin1 $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgTalkingWindow2 value=$jAvgTalkWin2 $jtime"
curl -i -XPOST "http://myinfluxdbserver:8086/write?db=nocdb" --data-binary "test2,user=$jID,sensor=avgHoldWindow2 value=$jAvgHoldWin2 $jtime"
done < <(jq -c '.[]|.ResourceIAQStats.resourceId,.ResourceIAQStats.resourceName,.ResourceIAQStats.strResourceState,.ResourceIAQStats.rsrcCurrentStateReason,.ResourceIAQStats.resourceState,.ResourceIAQStats.durationInStateMillis,.ResourceIAQStats.nHandledContacts,.ResourceIAQStats.nPresentedContacts,.ResourceIAQStats.avgTalkDuration,.ResourceIAQStats.longestTalkDuration,.ResourceIAQStats.avgHoldDuration,.ResourceIAQStats.longestHoldDuration,.ResourceIAQStats.avgHandleDuration,.ResourceIAQStats.avgWorkDuration,.ResourceIAQStats.totalTalkTime,.ResourceIAQStats.totalHoldTime,.ResourceIAQStats.maxReadyTime,.ResourceIAQStats.avgReadyTime,.ResourceIAQStats.totalReadyTime,.ResourceIAQStats.maxNotReadyTime,.ResourceIAQStats.avgNotReadyTime,.ResourceIAQStats.totalNotReadyTime,.ResourceIAQStats.maxWorkTime,.ResourceIAQStats.totalWorkTime,.ResourceIAQStats.logonDuration,.ResourceIAQStats.totalReservedTime,.ResourceIAQStats.otherTime,.ResourceIAQStats.avgSpeedOfAnswer,.ResourceIAQStats.rsrcCurrentStateReasonCode,.ResourceIAQStats.avgTalkingWindow1,.ResourceIAQStats.avgHoldWindow1,.ResourceIAQStats.avgTalkingWindow2,.ResourceIAQStats.avgHoldWindow2' < ResourceIAQStats-temp)
}
while :
do
getdatasend
#sleep 5
done
Cisco UCCX API JSON:
[
{
"id": "bdole",
"operation": "UPDATE",
"ResourceIAQStats": {
"resourceId": "bdole",
"resourceName": "Bob Dole",
"resourceState": 7,
"durationInStateMillis": 836314,
"nHandledContacts": 3,
"nPresentedContacts": 3,
"avgTalkDuration": 269421,
"longestTalkDuration": 378213,
"avgHoldDuration": 0,
"longestHoldDuration": 0,
"avgHandleDuration": 0,
"avgWorkDuration": 180001,
"totalTalkTime": 1375159,
"totalHoldTime": 0,
"maxReadyTime": 2318523,
"avgReadyTime": 1059775,
"totalReadyTime": 8478207,
"maxNotReadyTime": 868582,
"avgNotReadyTime": 202730,
"totalNotReadyTime": 1216385,
"maxWorkTime": 180001,
"totalWorkTime": 360002,
"logonDuration": 11445336,
"totalReservedTime": 0,
"otherTime": -7,
"avgSpeedOfAnswer": 4972,
"rsrcCurrentStateReasonCode": 0,
"rsrcCurrentStateReason": "",
"nOutboundOfferedContacts": 0,
"nOutboundActiveOfferedContacts": 0,
"nOutboundTimedOutContacts": 0,
"nOutboundVoiceContacts": 0,
"nOutboundAcceptedContacts": 0,
"nOutboundActiveVoiceContacts": 0,
"nOutboundActiveAcceptedContacts": 0,
"nOutboundRejectedContacts": 0,
"nOutboundClosedContacts": 0,
"avgOutboundTalkDuration": 0,
"activeOutboundTalkDuration": 0,
"avgOutboundHoldDuration": 0,
"activeOutboundHoldDuration": 0,
"longestOutboundTalkDuration": 0,
"longestOutboundHoldDuration": 0,
"totalOutboundTalkTime": 0,
"totalOutboundHoldTime": 0,
"avgOutboundWorkTime": 0,
"maxOutboundWorkTime": 0,
"totalOutboundWorkTime": 0,
"avgOutboundTalkWindow1": 0,
"avgOutboundHoldWindow1": 0,
"avgOutboundTalkWindow2": 0,
"avgOutboundHoldWindow2": 0,
"nOutboundHandledContacts": -1,
"avgTalkingWindow1": 300000,
"avgHoldWindow1": 0,
"avgTalkingWindow2": 836445,
"avgHoldWindow2": 0,
"strResourceState": "Talking"
}
},
{
"id": "iturner",
"operation": "UPDATE",
"ResourceIAQStats": {
"resourceId": "iturner",
"resourceName": "Ike Turner",
"resourceState": 2,
"durationInStateMillis": 521582,
"nHandledContacts": 0,
"nPresentedContacts": 0,
"avgTalkDuration": 0,
"longestTalkDuration": 0,
"avgHoldDuration": 0,
"longestHoldDuration": 0,
"avgHandleDuration": 0,
"avgWorkDuration": 0,
"totalTalkTime": 0,
"totalHoldTime": 0,
"maxReadyTime": 6616766,
"avgReadyTime": 2085567,
"totalReadyTime": 10427836,
"maxNotReadyTime": 211627,
"avgNotReadyTime": 83486,
"totalNotReadyTime": 939016,
"maxWorkTime": 0,
"totalWorkTime": 0,
"logonDuration": 11366852,
"totalReservedTime": 0,
"otherTime": 0,
"avgSpeedOfAnswer": 0,
"rsrcCurrentStateReasonCode": 32761,
"rsrcCurrentStateReason": "Non ACD Busy",
"nOutboundOfferedContacts": 0,
"nOutboundActiveOfferedContacts": 0,
"nOutboundTimedOutContacts": 0,
"nOutboundVoiceContacts": 0,
"nOutboundAcceptedContacts": 0,
"nOutboundActiveVoiceContacts": 0,
"nOutboundActiveAcceptedContacts": 0,
"nOutboundRejectedContacts": 0,
"nOutboundClosedContacts": 0,
"avgOutboundTalkDuration": 0,
"activeOutboundTalkDuration": 0,
"avgOutboundHoldDuration": 0,
"activeOutboundHoldDuration": 0,
"longestOutboundTalkDuration": 0,
"longestOutboundHoldDuration": 0,
"totalOutboundTalkTime": 0,
"totalOutboundHoldTime": 0,
"avgOutboundWorkTime": 0,
"maxOutboundWorkTime": 0,
"totalOutboundWorkTime": 0,
"avgOutboundTalkWindow1": 0,
"avgOutboundHoldWindow1": 0,
"avgOutboundTalkWindow2": 0,
"avgOutboundHoldWindow2": 0,
"nOutboundHandledContacts": -1,
"avgTalkingWindow1": 0,
"avgHoldWindow1": 0,
"avgTalkingWindow2": 0,
"avgHoldWindow2": 0,
"strResourceState": "Not Ready"
}
},
{
"id": "bcornholio",
"operation": "UPDATE",
"ResourceIAQStats": {
"resourceId": "bcornholio",
"resourceName": "Beavis Cornholio",
"resourceState": 2,
"durationInStateMillis": 2826976,
"nHandledContacts": 1,
"nPresentedContacts": 1,
"avgTalkDuration": 395767,
"longestTalkDuration": 395767,
"avgHoldDuration": 0,
"longestHoldDuration": 0,
"avgHandleDuration": 0,
"avgWorkDuration": 180002,
"totalTalkTime": 395767,
"totalHoldTime": 0,
"maxReadyTime": 7548722,
"avgReadyTime": 3124606,
"totalReadyTime": 9373819,
"maxNotReadyTime": 86916,
"avgNotReadyTime": 53884,
"totalNotReadyTime": 2934745,
"maxWorkTime": 180002,
"totalWorkTime": 180002,
"logonDuration": 12893173,
"totalReservedTime": 0,
"otherTime": -13,
"avgSpeedOfAnswer": 7630,
"rsrcCurrentStateReasonCode": 33,
"rsrcCurrentStateReason": "Supervisor Initiated",
"nOutboundOfferedContacts": 0,
"nOutboundActiveOfferedContacts": 0,
"nOutboundTimedOutContacts": 0,
"nOutboundVoiceContacts": 0,
"nOutboundAcceptedContacts": 0,
"nOutboundActiveVoiceContacts": 0,
"nOutboundActiveAcceptedContacts": 0,
"nOutboundRejectedContacts": 0,
"nOutboundClosedContacts": 0,
"avgOutboundTalkDuration": 0,
"activeOutboundTalkDuration": 0,
"avgOutboundHoldDuration": 0,
"activeOutboundHoldDuration": 0,
"longestOutboundTalkDuration": 0,
"longestOutboundHoldDuration": 0,
"totalOutboundTalkTime": 0,
"totalOutboundHoldTime": 0,
"avgOutboundWorkTime": 0,
"maxOutboundWorkTime": 0,
"totalOutboundWorkTime": 0,
"avgOutboundTalkWindow1": 0,
"avgOutboundHoldWindow1": 0,
"avgOutboundTalkWindow2": 0,
"avgOutboundHoldWindow2": 0,
"nOutboundHandledContacts": -1,
"avgTalkingWindow1": 0,
"avgHoldWindow1": 0,
"avgTalkingWindow2": 0,
"avgHoldWindow2": 0,
"strResourceState": "Not Ready"
}
},
{
"id": "dtrickle",
"operation": "UPDATE",
"ResourceIAQStats": {
"resourceId": "dtrickle",
"resourceName": "Dick Trickle",
"resourceState": 2,
"durationInStateMillis": 1335314,
"nHandledContacts": 2,
"nPresentedContacts": 4,
"avgTalkDuration": 192922,
"longestTalkDuration": 334191,
"avgHoldDuration": 0,
"longestHoldDuration": 0,
"avgHandleDuration": 0,
"avgWorkDuration": 100716,
"totalTalkTime": 385844,
"totalHoldTime": 0,
"maxReadyTime": 1896995,
"avgReadyTime": 566309,
"totalReadyTime": 10759886,
"maxNotReadyTime": 562214,
"avgNotReadyTime": 190067,
"totalNotReadyTime": 7562194,
"maxWorkTime": 180001,
"totalWorkTime": 201433,
"logonDuration": 18934093,
"totalReservedTime": 0,
"otherTime": -14,
"avgSpeedOfAnswer": 4809,
"rsrcCurrentStateReasonCode": 23,
"rsrcCurrentStateReason": "Lunch",
"nOutboundOfferedContacts": 0,
"nOutboundActiveOfferedContacts": 0,
"nOutboundTimedOutContacts": 0,
"nOutboundVoiceContacts": 0,
"nOutboundAcceptedContacts": 0,
"nOutboundActiveVoiceContacts": 0,
"nOutboundActiveAcceptedContacts": 0,
"nOutboundRejectedContacts": 0,
"nOutboundClosedContacts": 0,
"avgOutboundTalkDuration": 0,
"activeOutboundTalkDuration": 0,
"avgOutboundHoldDuration": 0,
"activeOutboundHoldDuration": 0,
"longestOutboundTalkDuration": 0,
"longestOutboundHoldDuration": 0,
"totalOutboundTalkTime": 0,
"totalOutboundHoldTime": 0,
"avgOutboundWorkTime": 0,
"maxOutboundWorkTime": 0,
"totalOutboundWorkTime": 0,
"avgOutboundTalkWindow1": 0,
"avgOutboundHoldWindow1": 0,
"avgOutboundTalkWindow2": 0,
"avgOutboundHoldWindow2": 0,
"nOutboundHandledContacts": -1,
"avgTalkingWindow1": 0,
"avgHoldWindow1": 0,
"avgTalkingWindow2": 0,
"avgHoldWindow2": 0,
"strResourceState": "Not Ready"
}
},
{
"id": "lburton",
"operation": "UPDATE",
"ResourceIAQStats": {
"resourceId": "lburton",
"resourceName": "LaVar Burton",
"resourceState": 3,
"durationInStateMillis": 115058,
"nHandledContacts": 2,
"nPresentedContacts": 2,
"avgTalkDuration": 85355,
"longestTalkDuration": 137448,
"avgHoldDuration": 0,
"longestHoldDuration": 0,
"avgHandleDuration": 0,
"avgWorkDuration": 180001,
"totalTalkTime": 170709,
"totalHoldTime": 0,
"maxReadyTime": 1498543,
"avgReadyTime": 429209,
"totalReadyTime": 4836357,
"maxNotReadyTime": 5122741,
"avgNotReadyTime": 644678,
"totalNotReadyTime": 7091467,
"maxWorkTime": 180002,
"totalWorkTime": 360003,
"logonDuration": 12466364,
"totalReservedTime": 0,
"otherTime": -9,
"avgSpeedOfAnswer": 2901,
"rsrcCurrentStateReasonCode": 0,
"rsrcCurrentStateReason": "",
"nOutboundOfferedContacts": 0,
"nOutboundActiveOfferedContacts": 0,
"nOutboundTimedOutContacts": 0,
"nOutboundVoiceContacts": 0,
"nOutboundAcceptedContacts": 0,
"nOutboundActiveVoiceContacts": 0,
"nOutboundActiveAcceptedContacts": 0,
"nOutboundRejectedContacts": 0,
"nOutboundClosedContacts": 0,
"avgOutboundTalkDuration": 0,
"activeOutboundTalkDuration": 0,
"avgOutboundHoldDuration": 0,
"activeOutboundHoldDuration": 0,
"longestOutboundTalkDuration": 0,
"longestOutboundHoldDuration": 0,
"totalOutboundTalkTime": 0,
"totalOutboundHoldTime": 0,
"avgOutboundWorkTime": 0,
"maxOutboundWorkTime": 0,
"totalOutboundWorkTime": 0,
"avgOutboundTalkWindow1": 0,
"avgOutboundHoldWindow1": 0,
"avgOutboundTalkWindow2": 0,
"avgOutboundHoldWindow2": 0,
"nOutboundHandledContacts": -1,
"avgTalkingWindow1": 0,
"avgHoldWindow1": 0,
"avgTalkingWindow2": 33261,
"avgHoldWindow2": 0,
"strResourceState": "Ready"
}
},
{
"id": "eidle",
"operation": "UPDATE",
"ResourceIAQStats": {
"resourceId": "eidle",
"resourceName": "Eric Idle",
"resourceState": 2,
"durationInStateMillis": 3009274,
"nHandledContacts": 0,
"nPresentedContacts": 0,
"avgTalkDuration": 0,
"longestTalkDuration": 0,
"avgHoldDuration": 0,
"longestHoldDuration": 0,
"avgHandleDuration": 0,
"avgWorkDuration": 0,
"totalTalkTime": 0,
"totalHoldTime": 0,
"maxReadyTime": 0,
"avgReadyTime": 0,
"totalReadyTime": 0,
"maxNotReadyTime": 5641945,
"avgNotReadyTime": 3975156,
"totalNotReadyTime": 10959587,
"maxWorkTime": 0,
"totalWorkTime": 0,
"logonDuration": 10959587,
"totalReservedTime": 0,
"otherTime": 0,
"avgSpeedOfAnswer": 0,
"rsrcCurrentStateReasonCode": 32760,
"rsrcCurrentStateReason": "Agent Logon",
"nOutboundOfferedContacts": 0,
"nOutboundActiveOfferedContacts": 0,
"nOutboundTimedOutContacts": 0,
"nOutboundVoiceContacts": 0,
"nOutboundAcceptedContacts": 0,
"nOutboundActiveVoiceContacts": 0,
"nOutboundActiveAcceptedContacts": 0,
"nOutboundRejectedContacts": 0,
"nOutboundClosedContacts": 0,
"avgOutboundTalkDuration": 0,
"activeOutboundTalkDuration": 0,
"avgOutboundHoldDuration": 0,
"activeOutboundHoldDuration": 0,
"longestOutboundTalkDuration": 0,
"longestOutboundHoldDuration": 0,
"totalOutboundTalkTime": 0,
"totalOutboundHoldTime": 0,
"avgOutboundWorkTime": 0,
"maxOutboundWorkTime": 0,
"totalOutboundWorkTime": 0,
"avgOutboundTalkWindow1": 0,
"avgOutboundHoldWindow1": 0,
"avgOutboundTalkWindow2": 0,
"avgOutboundHoldWindow2": 0,
"nOutboundHandledContacts": -1,
"avgTalkingWindow1": 0,
"avgHoldWindow1": 0,
"avgTalkingWindow2": 0,
"avgHoldWindow2": 0,
"strResourceState": "Not Ready"
}
},
{
"id": "aalda",
"operation": "UPDATE",
"ResourceIAQStats": {
"resourceId": "aalda",
"resourceName": "Alan Alda",
"resourceState": 2,
"durationInStateMillis": 12792,
"nHandledContacts": 1,
"nPresentedContacts": 2,
"avgTalkDuration": 146929,
"longestTalkDuration": 146929,
"avgHoldDuration": 0,
"longestHoldDuration": 0,
"avgHandleDuration": 0,
"avgWorkDuration": 180003,
"totalTalkTime": 146929,
"totalHoldTime": 0,
"maxReadyTime": 2498518,
"avgReadyTime": 877703,
"totalReadyTime": 7899331,
"maxNotReadyTime": 3804789,
"avgNotReadyTime": 692007,
"totalNotReadyTime": 5548855,
"maxWorkTime": 180003,
"totalWorkTime": 180003,
"logonDuration": 13792856,
"totalReservedTime": 0,
"otherTime": -7,
"avgSpeedOfAnswer": 7268,
"rsrcCurrentStateReasonCode": 23,
"rsrcCurrentStateReason": "Lunch",
"nOutboundOfferedContacts": 0,
"nOutboundActiveOfferedContacts": 0,
"nOutboundTimedOutContacts": 0,
"nOutboundVoiceContacts": 0,
"nOutboundAcceptedContacts": 0,
"nOutboundActiveVoiceContacts": 0,
"nOutboundActiveAcceptedContacts": 0,
"nOutboundRejectedContacts": 0,
"nOutboundClosedContacts": 0,
"avgOutboundTalkDuration": 0,
"activeOutboundTalkDuration": 0,
"avgOutboundHoldDuration": 0,
"activeOutboundHoldDuration": 0,
"longestOutboundTalkDuration": 0,
"longestOutboundHoldDuration": 0,
"totalOutboundTalkTime": 0,
"totalOutboundHoldTime": 0,
"avgOutboundWorkTime": 0,
"maxOutboundWorkTime": 0,
"totalOutboundWorkTime": 0,
"avgOutboundTalkWindow1": 0,
"avgOutboundHoldWindow1": 0,
"avgOutboundTalkWindow2": 0,
"avgOutboundHoldWindow2": 0,
"nOutboundHandledContacts": -1,
"avgTalkingWindow1": 0,
"avgHoldWindow1": 0,
"avgTalkingWindow2": 0,
"avgHoldWindow2": 0,
"strResourceState": "Not Ready"
}
}
]