[cisco-voip] CDR report

Wed Mar 29 21:49:40 EST 2006

We limit to 9.911 for many of our customers and in states where it's
required (like California) we label th phones.

Some customers opt for an outdial code of 8 instead of 9.  That helps a
lot.

Jon

________________________________

From: Voll, Scott [mailto:Scott.Voll at wesd.org] 
Sent: Wednesday, March 29, 2006 3:31 PM
To: Lelio Fulgenzi; Bill Riley III; Pritchard, Jon
Cc: cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] CDR report

I keep them in for slapping the end users who keep calling 911 then
hanging up.

Speaking of that, what does everyone else do?  I route both 9.911 and
911.  But I'm seeing a lot of 911 calls.  Have people moved to dialing
8. rather then 9. or are people not routing 911 and only 9.911.

Scott

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Lelio Fulgenzi
Sent: Wednesday, March 29, 2006 3:20 PM
To: Bill Riley III; Pritchard, Jon
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CDR report

There is a service parameter to enable/disable 0 lenght CDRs. I keep
them in for troubleshooting.

	----- Original Message ----- 

	From: Bill Riley III <mailto:BRiley at jackhenry.com>  

	To: Pritchard, Jon <mailto:Jon_Pritchard at adp.com>  

	Cc: cisco-voip at puck.nether.net 

	Sent: Wednesday, March 29, 2006 5:49 PM

	Subject: Re: [cisco-voip] CDR report

	I used a SQL query and then converted the time in Excel.  I took
out the calls that were 0 and less but isn't there a way to stop them
from being logged in the first place. 

	SELECT     dateTimeOrigination, callingPartyNumber,
finalCalledPartyNumber, originalCalledPartyNumber, duration
	FROM         CallDetailRecord
	WHERE     (callingPartyNumber LIKE '13%') AND (duration > '0')
AND (dateTimeOrigination < '1143615600') AND (dateTimeOrigination >
'1138777200')

	-----Original Message-----
	From: Pritchard, Jon [mailto:Jon_Pritchard at adp.com] 
	Sent: Wednesday, March 29, 2006 4:45 PM
	To: Bill Riley III
	Cc: cisco-voip at puck.nether.net
	Subject: RE: [cisco-voip] CDR report

	No dice.  We wrote our own.   For a third party take a look at
Syn-Apps call accounting.  They do good stuff.

	Jon

	-----------------------------------------------

	Date: Wed, 29 Mar 2006 15:49:49 -0600
	From: "Bill Riley III" <BRiley at jackhenry.com>
	Subject: [cisco-voip] CDR report
	To: <cisco-voip at puck.nether.net>
	Message-ID:
	<13591CB4B2359F4D96E2606DD6B840A0024B7BBD at smoxchg.jhacorp.com>
	Content-Type: text/plain; charset="us-ascii"

	I have a customer that wants to get all of the calls a certain
group of extensions made for the last 60 days. I am using the built in
CDR analysis and reporting and when I go to CDR>search>by User/Extension
and put in the extensions I want to search by, 13XX, and the date
ranges, it only gives me the first 100 rows. How do I increase the
output so it will not be truncated? 

	Thanks,

	Bill Riley

	                       All Content of this document is ADP
Confidential 2006
	Jon Pritchard - Sr. Network Engineer
	Network Solutions Group
	ADP Dealer Services, 2525 SW First Avenue, Portland, OR 97201
	phone: (503) 205-4428, fax: (503) 402-3277
	email: Jon_Pritchard at adp.com

	This message and any attachments are intended only for the use
of the addressee and may contain information that is privileged and
confidential. If the reader of the message is not the intended recipient
or an authorized representative of the intended recipient, you are
hereby notified that any dissemination of this communication is strictly
prohibited. If you have received this communication in error, please
notify us immediately by e-mail and delete the message and any
attachments from your system.

	NOTICE: This electronic mail message and any files transmitted
with it are intended exclusively for the individual or entity to which
it is addressed. The message, together with any attachment, may contain
confidential and/or privileged information. Any unauthorized review,
use, printing, saving, copying, disclosure or distribution is strictly
prohibited. If you have received this message in error, please
immediately advise the sender by reply email and delete all copies.

	_______________________________________________
	cisco-voip mailing list
	cisco-voip at puck.nether.net
	https://puck.nether.net/mailman/listinfo/cisco-voip

This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060329/6df8475f/attachment-0001.html 