Generating Agent report ( particularly in time )

Any and all non-support discussions

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

Generating Agent report ( particularly in time )

Postby myquerry1983 » Fri Jan 31, 2014 9:16 pm

Hi there,

Is there a way i can generate reports with regards to their log in and log out in the vicidial agent web ui ( specific time and date ),


Thanks,
myquerry1983
 
Posts: 38
Joined: Tue Jun 18, 2013 8:07 am

Re: Generating Agent report ( particularly in time )

Postby williamconley » Sat Feb 01, 2014 12:44 am

1) Welcome to the Party! 8-)

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) All reports are under the "reports" tab, go through one at a time ... if it's in there you'll find it that way.

4) If you don't find what you are looking for, consider using phpMyAdmin or straight MySQL to generate plain data (which can be exported to CSV ...) from the database directly from the appropriate table (in this case, it sounds like you're looking for the vicidial_user_log data ... try this:
Code: Select all
mysql -p1234 -u cron asterisk -e "SELECT * FROM vicidial_user_log order by event_date DESC"


5) Happy Hunting! 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Generating Agent report ( particularly in time )

Postby myquerry1983 » Wed Feb 12, 2014 4:10 pm

Hi,,

Thanks it helps me alot..thanks a lot sir.
myquerry1983
 
Posts: 38
Joined: Tue Jun 18, 2013 8:07 am


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 57 guests