vicidial.org

VICIDIAL astGUIclient discussion forum

Skip to content

Vicidial.org Home      Vicidial Forum      Vicidial Wiki      Vicidial Issue Tracker      astGUIclient Project Page


Agent Performance Detail

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Post a reply

Agent Performance Detail

Postby convertec » Thu Jan 10, 2008 7:31 pm

Sorry for the info overload here, this is my vicidial_agent_log database:
"agent_log_id","user","server_ip","event_time","lead_id","campaign_id","pause_epoch","pause_sec","wait_epoch","wait_sec","talk_epoch","talk_sec","dispo_epoch","dispo_sec","status","user_group","comments","sub_status"
"1","ajohnson","192.168.0.11","2007-12-28 13:44:40","","TESTCAMP","1198878280","26","1198878306","0","","0","","0","","ADMIN","","LOGIN"
"2","ajohnson","192.168.0.11","2007-12-28 13:45:56","31","TESTCAMP","1198878356","0","1198878356","0","","0","1198878450","0","N","ADMIN","MANUAL","LOGIN"
"3","ajohnson","192.168.0.11","2007-12-28 13:47:30","7","TESTCAMP","1198878450","0","1198878450","0","","0","1198878597","0","DC","ADMIN","MANUAL",""
"4","ajohnson","192.168.0.11","2007-12-28 13:49:57","8","TESTCAMP","1198878597","0","1198878597","0","","0","1198878622","0","A","ADMIN","MANUAL",""
"5","ajohnson","192.168.0.11","2007-12-28 13:50:22","9","TESTCAMP","1198878622","0","1198878622","0","","0","1198878652","0","A","ADMIN","MANUAL",""
"6","ajohnson","192.168.0.11","2007-12-28 13:50:52","","TESTCAMP","1198878652","1","1198878653","0","","0","","0","","ADMIN","",""
"7","1455","192.168.0.11","2008-01-09 17:23:24","","DGOODMAN","1199928204","171","1199928375","0","","0","","0","","DGOODMAN","","LOGIN"
"8","1455","192.168.0.11","2008-01-09 17:26:22","1291","DGOODMAN","1199928382","71","1199928453","0","","0","","0","","DGOODMAN","MANUAL","LOGIN"
"9","1455","192.168.0.11","2008-01-09 17:37:10","1292","DGOODMAN","1199929030","117","1199929147","0","","0","","0","","DGOODMAN","MANUAL","LOGIN"
"10","1455","192.168.0.11","2008-01-10 14:31:31","3859","DGOODMAN","1200004291","0","1200004291","0","","0","1200004443","0","N","DGOODMAN","MANUAL","LOGIN"
"11","1455","192.168.0.11","2008-01-10 14:34:03","3860","DGOODMAN","1200004443","0","1200004443","0","","0","1200004498","0","A","DGOODMAN","MANUAL",""
"12","1455","192.168.0.11","2008-01-10 14:34:58","3861","DGOODMAN","1200004498","0","1200004498","0","","0","1200004679","0","NI","DGOODMAN","MANUAL",""
"13","1455","192.168.0.11","2008-01-10 14:37:59","3862","DGOODMAN","1200004679","73","1200004752","0","","0","","0","","DGOODMAN","MANUAL",""
"14","1455","192.168.0.11","2008-01-10 14:39:54","3863","DGOODMAN","1200004794","80","1200004874","0","","0","","0","","DGOODMAN","MANUAL","LOGIN"
"15","1455","192.168.0.11","2008-01-10 15:06:00","3864","DGOODMAN","1200006360","0","1200006360","0","","0","1200006422","0","A","DGOODMAN","MANUAL","LOGIN"
"16","1455","192.168.0.11","2008-01-10 15:07:02","3865","DGOODMAN","1200006422","0","1200006422","0","","0","1200006463","0","N","DGOODMAN","MANUAL",""
"17","1455","192.168.0.11","2008-01-10 15:07:43","3866","DGOODMAN","1200006463","0","1200006463","0","","0","1200006535","0","DNC","DGOODMAN","MANUAL",""
"18","1455","192.168.0.11","2008-01-10 15:08:55","3867","DGOODMAN","1200006535","0","1200006535","0","","0","1200006583","0","A","DGOODMAN","MANUAL",""
"19","1455","192.168.0.11","2008-01-10 15:09:43","3868","DGOODMAN","1200006583","0","1200006583","0","","0","1200006665","0","NI","DGOODMAN","MANUAL",""
"20","1455","192.168.0.11","2008-01-10 15:11:05","3869","DGOODMAN","1200006665","0","1200006665","0","","0","1200006692","0","DC","DGOODMAN","MANUAL",""
"21","1455","192.168.0.11","2008-01-10 15:11:32","3870","DGOODMAN","1200006692","0","1200006692","0","","0","1200006747","0","DC","DGOODMAN","MANUAL",""
"22","1455","192.168.0.11","2008-01-10 15:12:27","3871","DGOODMAN","1200006747","0","1200006747","0","","0","1200006792","0","A","DGOODMAN","MANUAL",""
"23","1455","192.168.0.11","2008-01-10 15:13:12","3872","DGOODMAN","1200006792","0","1200006792","0","","0","1200006869","0","DEC","DGOODMAN","MANUAL",""
"24","1455","192.168.0.11","2008-01-10 15:14:29","3873","DGOODMAN","1200006869","0","1200006869","0","","0","1200006938","0","DEC","DGOODMAN","MANUAL",""
"25","1455","192.168.0.11","2008-01-10 15:15:38","3874","DGOODMAN","1200006938","0","1200006938","0","","0","1200006961","0","DC","DGOODMAN","MANUAL",""
"26","1455","192.168.0.11","2008-01-10 15:16:01","3875","DGOODMAN","1200006961","0","1200006961","0","","0","1200007011","0","A","DGOODMAN","MANUAL",""
"27","1455","192.168.0.11","2008-01-10 15:16:51","3876","DGOODMAN","1200007011","0","1200007011","0","","0","1200007073","0","DEC","DGOODMAN","MANUAL",""
"28","1455","192.168.0.11","2008-01-10 15:17:53","3877","DGOODMAN","1200007073","0","1200007073","0","","0","1200007116","0","DNC","DGOODMAN","MANUAL",""
"29","1455","192.168.0.11","2008-01-10 15:18:36","3878","DGOODMAN","1200007116","0","1200007116","0","","0","1200007180","0","NI","DGOODMAN","MANUAL",""
"30","1455","192.168.0.11","2008-01-10 15:19:40","3879","DGOODMAN","1200007180","0","1200007180","0","","0","1200007199","0","DNC","DGOODMAN","MANUAL",""
"31","1455","192.168.0.11","2008-01-10 15:19:59","3880","DGOODMAN","1200007199","0","1200007199","0","","0","1200007268","0","N","DGOODMAN","MANUAL",""
"32","1455","192.168.0.11","2008-01-10 15:21:08","3881","DGOODMAN","1200007268","0","1200007268","0","","0","1200007320","0","N","DGOODMAN","MANUAL",""
"33","1455","192.168.0.11","2008-01-10 15:22:00","3882","DGOODMAN","1200007320","0","1200007320","0","","0","1200007357","0","A","DGOODMAN","MANUAL",""
"34","1455","192.168.0.11","2008-01-10 15:22:37","3883","DGOODMAN","1200007357","0","1200007357","0","","0","1200007393","0","A","DGOODMAN","MANUAL",""
"35","1455","192.168.0.11","2008-01-10 15:23:13","3884","DGOODMAN","1200007393","0","1200007393","0","","0","1200007416","0","DNC","DGOODMAN","MANUAL",""
"36","1455","192.168.0.11","2008-01-10 15:23:36","3885","DGOODMAN","1200007416","0","1200007416","0","","0","1200007468","0","NI","DGOODMAN","MANUAL",""
"37","1455","192.168.0.11","2008-01-10 15:24:28","","DGOODMAN","1200007468","10","1200007478","0","","0","","0","","DGOODMAN","",""
"38","1455","192.168.0.11","2008-01-10 15:40:11","3886","DGOODMAN","1200008411","0","1200008411","0","","0","1200008452","65535","DC","DGOODMAN","MANUAL","LOGIN"
"39","1455","192.168.0.11","2008-01-10 15:40:52","3887","DGOODMAN","1200008452","0","1200008452","0","","0","1200008505","65535","N","DGOODMAN","MANUAL",""
"40","1455","192.168.0.11","2008-01-10 15:41:45","3888","DGOODMAN","1200008505","0","1200008505","0","","0","1200008552","65535","A","DGOODMAN","MANUAL",""
"41","1455","192.168.0.11","2008-01-10 15:42:32","3889","DGOODMAN","1200008552","0","1200008552","0","","0","1200008605","65535","N","DGOODMAN","MANUAL",""
"42","1455","192.168.0.11","2008-01-10 15:43:25","3890","DGOODMAN","1200008605","0","1200008605","0","","0","1200008649","65535","DC","DGOODMAN","MANUAL",""
"43","1455","192.168.0.11","2008-01-10 15:44:09","3891","DGOODMAN","1200008649","0","1200008649","0","","0","1200008705","65535","N","DGOODMAN","MANUAL",""
"44","1455","192.168.0.11","2008-01-10 15:45:05","3892","DGOODMAN","1200008705","0","1200008705","0","","0","1200008745","65535","A","DGOODMAN","MANUAL",""
"45","1455","192.168.0.11","2008-01-10 15:45:45","3893","DGOODMAN","1200008745","0","1200008745","0","","0","1200008807","65535","NI","DGOODMAN","MANUAL",""
"46","1455","192.168.0.11","2008-01-10 15:46:47","3894","DGOODMAN","1200008807","0","1200008807","0","","0","1200008884","65535","NI","DGOODMAN","MANUAL",""
"47","1455","192.168.0.11","2008-01-10 15:48:04","3895","DGOODMAN","1200008884","0","1200008884","0","","0","1200008940","65535","NI","DGOODMAN","MANUAL",""
"48","1455","192.168.0.11","2008-01-10 15:49:00","3896","DGOODMAN","1200008940","0","1200008940","0","","0","1200008987","65535","N","DGOODMAN","MANUAL",""
"49","1455","192.168.0.11","2008-01-10 15:49:47","3897","DGOODMAN","1200008987","0","1200008987","0","","0","1200009031","65535","DC","DGOODMAN","MANUAL",""
"50","1455","192.168.0.11","2008-01-10 15:50:31","3898","DGOODMAN","1200009031","0","1200009031","0","","0","1200009111","65535","NI","DGOODMAN","MANUAL",""
"51","1455","192.168.0.11","2008-01-10 15:51:51","3899","DGOODMAN","1200009111","0","1200009111","0","","0","1200009181","65535","NI","DGOODMAN","MANUAL",""
"52","1455","192.168.0.11","2008-01-10 15:53:01","","DGOODMAN","1200009181","9","1200009190","0","","0","","0","","DGOODMAN","",""


and this is the Agent Performance Detail screen:

VICIDIAL: Agent Performance Detail 2008-01-10 16:16:08
Time range: 2008-01-10 00:00:00 to 2008-01-10 23:59:59

---------- AGENTS Details -------------

+-----------------+----------+--------+---------+--------+--------+--------+--------+--------+--------+--------+--------+----------+----------+----------+----------+----------+----------+
| USER NAME | ID | CALLS | TIME | PAUSE | PAUSAVG| WAIT | WAITAVG| TALK | TALKAVG| DISPO | DISPAVG| NI | N | DNC | DEC | DC | A |
+-----------------+----------+--------+---------+--------+--------+--------+--------+--------+--------+--------+--------+----------+----------+----------+----------+----------+----------+
| David Goodman | 1455 | 19 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 3 | 3 | 3 | 2 | 2 | 6 |
+-----------------+----------+--------+---------+--------+--------+--------+--------+--------+--------+--------+--------+----------+----------+----------+----------+----------+----------+
| TOTALS AGENTS:1 | 19| 0:00| 0:00| 0:00 | 0:00| 0:00 | 0:00| 0:00 | 0:00| 0:00 | 3 | 3 | 3 | 2 | 2 | 6 |
+----------------------------+--------+---------+--------+--------+--------+--------+--------+--------+--------+--------+----------+----------+----------+----------+----------+----------+

My question is why isn't vicidial recording any thing other than 'pause' times, and why isn't 'pause' displayed in the reports screen if there are values in the database?

add'l info:
root@vici:~# screen -r
There are several suitable screens on:
2827.asterisk (Detached)
32020.ASTsend (Detached)
12059.ASTVDadapt (Detached)
32023.ASTlisten (Detached)
32026.ASTVDauto (Detached)
2792.ASTfastlog (Detached)
32017.ASTupdate (Detached)

VERSION: 2.0.4-119 BUILD: 71125-1751

Thanks!
convertec
 
Posts: 43
Joined: Sun Sep 03, 2006 2:27 pm
Location: Idaho
Top

Postby mflorell » Fri Jan 11, 2008 2:01 am

What kind of campaign are you doing?

What kind of calls are going in/out?

Have you modified any code?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida
Top

Postby convertec » Mon Jan 14, 2008 4:48 pm

Manual Dial Campaign, outboound calls only.

They are outbound SIP calls to the Gafachi network.

I have not modded any code, installed as per Scratch Install, Slackware.

some CLI output:
Code: Select all
    -- Executing MeetMe("Local/8600051@default-9db6,2", "8600051") in new stack
       > Channel Local/8600051@default-9db6,1 was answered.
    -- Executing AGI("Local/8600051@default-9db6,1", "agi://127.0.0.1:4577/call_log") in new stack
    -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
    -- Executing Dial("Local/8600051@default-9db6,1", "SIP/1NXXNXXXXXX@gafachi|55|tTo") in new stack
    -- Called 1NXXNXXXXXX@gafachi
    -- SIP/gafachi-08344138 is ringing
    -- SIP/gafachi-08344138 is making progress passing it to Local/8600051@default-9db6,1
  == No one is available to answer at this time (1:0/0/0)
    -- Executing Hangup("Local/8600051@default-9db6,1", "") in new stack
  == Spawn extension (default, 1NXXNXXXXXX, 3) exited non-zero on 'Local/8600051@default-9db6,1'
    -- Executing DeadAGI("Local/8600051@default-9db6,1", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----NOANSWER----------") in new stack
    -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----NOANSWER---------- completed, returning 0
  == Spawn extension (default, 8600051, 1) exited non-zero on 'Local/8600051@default-9db6,2'
    -- Executing DeadAGI("Local/8600051@default-9db6,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------") in new stack
    -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------- completed, returning 0

And here is some of my dial plan:
Code: Select all
   exten => _1NXXNXXXXXX,1,AGI(agi://127.0.0.1:4577/call_log)
   exten => _1NXXNXXXXXX,2,Dial(SIP/${EXTEN}@gafachi,55,tTo)
        exten => _1NXXNXXXXXX,3,Hangup

exten => h,1,DeadAGI(agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----${HANGUPCAUSE}-----${DIALSTATUS}-----${DIALEDTIME}-----${ANSWEREDTIME})

Thanks!
convertec
 
Posts: 43
Joined: Sun Sep 03, 2006 2:27 pm
Location: Idaho
Top

Postby convertec » Mon Jan 14, 2008 7:20 pm

Ok now I am starting to get some dial times, I only removed what looked like an extra ')' off the end of
Code: Select all
exten => h,1,DeadAGI(agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----${HANGUPCAUSE}-----${DIALSTATUS}-----${DIALEDTIME}-----${ANSWEREDTIME})

in the SCRATCH INSTALL (typo??)
and moved it AFTER the
Code: Select all
exten => _1NXXNXXXXXX,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _1NXXNXXXXXX,2,Dial(SIP/${EXTEN}@gafachi,55,tTo)
exten => _1NXXNXXXXXX,3,Hangup

in my dial plan.
convertec
 
Posts: 43
Joined: Sun Sep 03, 2006 2:27 pm
Location: Idaho
Top

Postby mflorell » Wed Jan 16, 2008 7:15 pm

Yep, we caught that ine a little while ago, the extra ) has been removed in SVN
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida
Top
Post a reply

Return to Support

Who is online

Users browsing this forum: No registered users and 124 guests

Powered by phpBB® Forum Software © phpBB Group