[cisco-voip] CDR report

[Ed Leatherman]

We route 911 and 9.911 also. We include that as part of training when we
install IP sets, and I also remind all the contact folks once a month in our
maintenance notice. We also stress that even if they dont mean to call it,
to stay on the line and let the dispatcher know they arent having an
emergency. We still get some hang ups to 911 though, i'm not sure what else
to do about it - management doesnt want us changing the dial patterns.

The message about connecting to emergency services is a good idea.

On 3/29/06, Pritchard, Jon <Jon_Pritchard at adp.com> wrote:
>
>  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 <BRiley at jackhenry.com>
>
> *To:* Pritchard, Jon <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.
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>


--
Ed Leatherman
IP Telephony Coordinator
West Virginia University
Telecommunications and Network Operations
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060330/55fce509/attachment-0001.html