Difference in reports and user stats

[lyxn2011]

Hello,

The 'AGENT TIME' in the 'Agent Time Detail' report and the total of login/logout time in 'User stats' for a user does not match. Does both of these indicate different values?

Can someone please explain me what these figures indicate and how it is calculated.

Scratch install
Operating sys: Slackware 13.37
mysql: 5.1.56
Asterisk: 1.4.26.2
VicidialVERSION: 2.4-364a BUILD: 120409-1136
No Digium/Sangoma Hardware | No Extra Software After Installation

[williamconley]

they are generated from different logs. In many cases you can use "&DB=1" in the URL to see the SQL queries that generated the numbers which will give you an idea of how they are generated.

if you want a more detailed answer, you'll need to provide the detailed url and cut/paste the lines you have issue with (preferably noting the column that has the questionable data). make it easy for the person reading this post to duplicate your method of bringing up the data ... and it's easier to get help.

you should also post a link to your installation instructions, as some problems can be traced back to specific installers.

[lyxn2011]

This is from the 'Agent Time Detail' report generated by selecting all campaigns, all user groups and all shifts for a day.

Code: Select all

+-----------------+----------+----------+------------+------------+------------+------------+------------+------------+------------+------------+   +------------+------------+------------+
| USER NAME       | ID       | CALLS    | TIME CLOCK | AGENT TIME | WAIT       | TALK       | DISPO      | PAUSE      | DEAD       | CUSTOMER   |   |      LOGIN |            |     LAGGED |
+-----------------+----------+----------+------------+------------+------------+------------+------------+------------+------------+------------+   +------------+------------+------------+
| Agent 67  ABCD  | 7767     |       75 |       0:00 |    6:47:22 |    3:10:26 |    1:31:40 |       8:29 |    1:56:47 |       1:05 |    1:30:35 |   |       4:53 |    1:51:54 |       0:00 |

This is from the 'User stats' for the user for the same day

Code: Select all

                        AGENT LOGIN/LOGOUT TIME:
EVENT   DATE    CAMPAIGN        GROUP   HOURS:MM:SS     SESSION SERVER  PHONE   COMPUTER
LOGIN   2013-04-10 11:30:26     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 11:31:06     7000    agents  0:40     
LOGIN   2013-04-10 11:31:08     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 13:16:26     7000    agents  1:45:18         
LOGIN   2013-04-10 13:16:29     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 13:19:51     7000    agents  3:22     
LOGIN   2013-04-10 13:19:54     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 13:20:11     7000    agents  0:17     
LOGIN   2013-04-10 13:20:22     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 13:20:37     7000    agents  0:15     
LOGIN   2013-04-10 13:20:51     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 13:20:59     7000    agents  0:08     
LOGIN   2013-04-10 13:21:52     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 13:22:12     7000    agents  0:20     
LOGIN   2013-04-10 13:23:04     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 13:28:04     7000    agents  5:00     
LOGIN   2013-04-10 13:28:06     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 13:29:55     7000    agents  1:49     
LOGIN   2013-04-10 13:29:59     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 13:32:37     7000    agents  2:38     
LOGIN   2013-04-10 13:32:40     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 16:05:12     7000    agents  2:32:32         
LOGIN   2013-04-10 16:05:16     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 16:05:39     7000    agents  0:23     
LOGIN   2013-04-10 16:05:45     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 16:06:03     7000    agents  0:18     
LOGIN   2013-04-10 16:07:04     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 16:45:49     7000    agents  38:45   
LOGIN   2013-04-10 16:46:36     7000    agents          8600057         192.168.1.1     SIP/cc8811      192.168.1.20
LOGOUT  2013-04-10 17:02:46     7000    agents  16:10   
TOTAL                           5:27:55

The 'AGENT TIME' in the time detail report and the 'TOTAL' time from user stats does not match. What does the 'AGENT TIME' indicate?

Which report should I consider if I want to know the total time that an agent was logged in?

I have not used any vicidial installer. I have done a scratch install from the source.

[williamconley]

if you performed a scratch install from source, you should post the directions you used (link would be good, even if you need to strip off the http:// to avoid a spam lock). This may link you and others to problems inherent in those installation instructions.

to get the answers to your questions, we'll need the URL from which each of these reports was generated, but even then you'll likely need to use the &DB=1 addition to the URL to get the queries used to generate the report. This will give you the ability to use mysql to identify which logs generated the data ... and that will give you an idea of how the data was Stored in the first place.

you may also want to look at upgrading to a later version in case you are experiencing bugs that have already been fixed (why fight a battle that has already been fought and won ...)

[lyxn2011]

I followed the scratch install instructions in the txt document in the vicidial source.