Call duration

Any and all non-support discussions

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

Call duration

Postby RukuBaruku » Tue May 13, 2014 3:41 am

I'm trying to get from the server the call duration in minutes for the last month.

Can i do this with navicat? Is there any ready query?
Vicibox 5.03 from .iso | VERSION: 2.10-450a BUILD: 140822-1034 | 1.8.23.0-vici | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | HP ProLiant DL580 G5 E7310 1.6GHz Quad Core
RukuBaruku
 
Posts: 23
Joined: Mon Mar 17, 2014 4:47 am

Re: Call duration

Postby geoff3dmg » Tue May 13, 2014 7:59 am

Off the top of my head. So not tested.

Code: Select all
SELECT
    (SUM(vl.length_in_sec) DIV 60) AS Minutes
FROM
    asterisk.vicidial_log AS vl
WHERE
    vl.call_date BETWEEN ADDDATE(LAST_DAY(DATE_SUB(NOW(), INTERVAL 2 MONTH)),
        INTERVAL 1 DAY) AND DATE_SUB(NOW(), INTERVAL 1 MONTH)
Vicibox 5.03 from .iso | VERSION: 2.10-451a BUILD: 140902-0816 | Asterisk 1.8.28.2-vici | Multi-Server | Amfeltec H/W Timing Cards | No Extra Software After Installation | Dell PowerEdge 1850 | Pentium 4 'Prescott' Xenon Quad @ 3.40GHz
geoff3dmg
 
Posts: 403
Joined: Tue Jan 29, 2013 4:35 am
Location: Lancashire, UK

Re: Call duration

Postby williamconley » Mon Jul 07, 2014 11:49 pm

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) If you look at reports, you'll likely find that one or two of them will have totals and allow you to select date ranges. But are you looking for Agent time on calls? Or outbound calls to prospects? Or inbound calls from prospects? Or anything billable by your Carrier for a check against your invoice?

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!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 54 guests