Reports do not match

[AlSam]

I was looking at today's user stats for a particular user and found that the total talk time by disposition equals 14:54:15 but the agent was only logged in to the system for 7:41:54. I have posted a screenshot of this at http://s1192.photobucket.com/albums/aa334/AlSam1/Report/. Any help in figuring out this discrepancy would be appreciated. This occurs with other users and other days as well, not just the user/date in the screenshot.

[mflorell]

Please post the contents of your "crontab -l"

[AlSam]

crontab -l
### recording mixing/compressing/ftping scripts
0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_mix.pl
#0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_VDonly.pl
1,4,7,10,13,16,19,22,25,28,31,34,37,40,43,46,49,52,55,58 * * * * /usr/share/astguiclient/AST_CRON_audio_2_compress.pl --GSM
#2,5,8,11,14,17,20,23,26,29,32,35,38,41,44,47,50,53,56,59 * * * * /usr/share/astguiclient/AST_CRON_audio_3_ftp.pl --GSM

### keepalive script for astguiclient processes
* * * * * /usr/share/astguiclient/ADMIN_keepalive_ALL.pl

### kill Hangup script for Asterisk updaters
* * * * * /usr/share/astguiclient/AST_manager_kill_hung_congested.pl

### updater for voicemail
* * * * * /usr/share/astguiclient/AST_vm_update.pl

### updater for conference validator
* * * * * /usr/share/astguiclient/AST_conf_update.pl

### flush queue DB table every hour for entries older than 1 hour
11 * * * * /usr/share/astguiclient/AST_flush_DBqueue.pl -q

### fix the vicidial_agent_log once every hour
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl

### updater for VICIDIAL hopper
* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q

### adjust the GMT offset for the leads in the vicidial_list table
1 1 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug

### reset several temporary-info tables in the database
2 1 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl

### optimize the database tables within the asterisk database
3 1 * * * /usr/share/astguiclient/AST_DB_optimize.pl

## adjust time on the server with ntp
30 * * * * /usr/sbin/ntpdate -u pool.ntp.org 2>/dev/null 1>&2

### VICIDIAL agent time log weekly and daily summary report generation
2 0 * * 0 /usr/share/astguiclient/AST_agent_week.pl
22 0 * * * /usr/share/astguiclient/AST_agent_day.pl

### VICIDIAL campaign export scripts (OPTIONAL)
#32 0 * * * /usr/share/astguiclient/AST_VDsales_export.pl
#42 0 * * * /usr/share/astguiclient/AST_sourceID_summary_export.pl

### remove old recordings more than 7 days old
#24 0 * * * /usr/bin/find /var/spool/asterisk/monitorDONE -maxdepth 2 -type f -mtime +7 -print | xargs rm -f

### remove old vicidial logs and asterisk logs more than 2 days old
28 0 * * * /usr/bin/find /var/log/astguiclient -maxdepth 1 -type f -mtime +2 -print | xargs rm -f
29 0 * * * /usr/bin/find /var/log/asterisk -maxdepth 3 -type f -mtime +2 -print | xargs rm -f
30 0 * * * /usr/bin/find / -maxdepth 1 -name "screenlog.0*" -mtime +4 -print | xargs rm -f

[mflorell]

Try adding this to your crontab:


50 0 * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl --last-24hours


It does a recalculation of the vicidial_agent_log time nightly to ensure there are no inaccuracies.

[AlSam]

Just added it. When should I see the results?

[mflorell]

it runs at night for the previous 24 hours of logs.

[AlSam]

Ran a report on the same agent for the 8th and the results are the same, the talk time is much higher than the amount of time the agent was logged in to the VD server. Link to report.

[mflorell]

I am seeing multiple logouts in a row on these samples, are you having issues with agents closing their web browsers in session, or with network connections?

How do these numbers compare to the summaries further down the page?

[AlSam]

I guess sometimes agents are forgetful and close the browser without properly logging out first...no network issues (thankfully). It seems that the total length in the inbound/closer calls section does match the total in the agent talk time and status section. The Agent(S) field in the inbound/closer calls section also matches (almost, off by 46 seconds, no big deal) the total talk and customer time under the agent activity section. Agent activity section and Inbound/closer calls section.